PostgreSQL MCP Server
NPM · @ITUNIFIED.IO/MCP-POSTGRES
PostgreSQL MCP Server — 27 tools for queries, schema, CRUD, DBA, HA & server management
Available components
Last scanned (43 minutes ago)
Scores higher than 46% of npm servers
Category Databases
How this component scores in each security and reliability category. Every signal is checked automatically from public evidence about the published package, including repeated runs of it in an isolated sandbox, and we only credit what we can confirm. How we score → Why this is hard to score →
Supply Chain Security81
- No malware found by supply-chain analysis.Pass
- CVE check failed: a known high-severity CVE affects zod 3.25.76, a direct dependency. A fixed version is available. View diagnostics → Fail
- No install/post-install scripts declared.Pass
- 34 of 107 dependencies flagged as unhealthy. View diagnostics → Partial
Provenance & Transparency19
- Repository check failed: the declared repository URL returned HTTP 404. See how to fix → View diagnostics → Fail
- Provenance check failed: no build-provenance attestation is published. See how to fix → View diagnostics → Fail
- Clear OSI-approved license (AGPL-3.0-only).Pass
- Actively maintained (last published 208 days ago).Pass
- Security-disclosure policy not yet verified: we couldn't inspect the source repository.Unverified
Schema Quality & AI Usability81
- AI-judged instruction clarity (excellent).Pass
- Tool/resource definitions use about 1416 tokens (~50/item across 28 items; 28 tools + 0 resources), lean.Pass
- Usage-examples check failed: none of the tools include examples. See how to fix → Fail
Stability & Change Management100
- No destabilizing schema changes in the last 30 days.Pass
Tool Coverage100
- 100% of tools have a non-trivial description (not blank, and not just the tool's name).Pass
- 100% of tool parameters carry a description.Pass
Tool Safety75
- No prompt-injection markers were found in the server instructions, tool names or descriptions we captured.Pass
- 0 of 2 tool(s) whose name or description implies an irreversible operation declare an MCP destructiveHint annotation; "pg_query" implies "execute" and declares no destructiveHint at all, which the MCP spec reads as destructive by default. See how to fix → Fail
- An AI judge read all 28 captured unit(s) of tool text and found none that tries to manipulate the model reading it.Pass
Capabilities100
- Implements a supported MCP spec version (2025-11-25); the latest is 2026-07-28.Pass
Every change we have recorded for this component, newest first. Security-relevant changes are always shown. ▲ marks a change for the better, ▼ a change for the worse; unmarked changes are neutral.
- 3 Nov 26 0
- Stability: 0.97 → pass security
- 2 Nov 26 0
- Stability: pass → 0.97 functional
- 24 Oct 26 −5
- CVE-2023-54404 affects this package: high ▼ security
- Known CVEs: pass → fail ▼ security
- 21 Oct 26 0
- Stability: 0.97 → pass security
- 20 Oct 26 0
- Stability: pass → 0.97 functional
- 17 Oct 26 +2
- Stability: 0.83 → pass security
- 16 Oct 26 +1
No change was recorded against any check on this day. Stability & Change Management went from 80 to 83. That category is still filling its 30-day observation window: 24 days of observed history at the previous scan, 25 at this one. The score rises as the window fills, whether or not the server changes.
- 15 Oct 26 −3
- Stability: pass → 0.80 functional
Diagnostic detail from the automated scan of this channel: what the scanner observed at each step, so you can see exactly where a check passed or failed. It is informational only and never changes the trust score.
Captured 5 Nov 2026 · Analysed npm/@itunified.io/mcp-postgres@2026.4.10-1
Provenance No attestation
The registry publishes no build provenance for this version, so there is nothing to verify.
| Result | No attestation |
|---|---|
| Ecosystem | npm |
Background: How many MCP packages publish verified provenance →
Vulnerabilities 1 finding
| ID | CVE | Severity | Vector | Fix available |
|---|---|---|---|---|
| GHSA-mrhx-c7xc-m3w5 | CVE-2023-54404 | high | CVSS:3.1/AV:N/AC:L/PR:N/UI:N/S:U/C:N/I:N/A:H | yes |
Background: What a vulnerability scan can and cannot prove →
Dependencies 107 packages
| Packages resolved | 107 |
|---|---|
| Stale | 34 |
| Tree resolution | Complete |
Background: SBOMs and build attestations, explained →
The tools this component advertises to a client, with an estimated token cost for each. Expand a tool to see its parameters and schema. The per-tool counts are indicative and are not scored directly; the schema's total context footprint is one signal in Schema Quality & AI Usability. A tool's description is untrusted text the model reads on every call, which is what makes this list a security surface and not just an inventory: how tool poisoning works →
pg_connect ~83
Connect to a PostgreSQL server profile. If multiple profiles are configured, specify which one. Otherwise connects to the default profile.
| Name | Type | Req | Description |
|---|---|---|---|
| database | string | – | Deprecated — use "profile" instead. Kept for backward compatibility. |
| profile | string | – | Named connection profile from config file (optional, uses default if omitted). Each profile points to a PostgreSQL server instance. |
No output schema declared.
No examples provided.
pg_connection_status ~51
Check connection pool health for the active profile or a specific named profile.
| Name | Type | Req | Description |
|---|---|---|---|
| database | string | – | Deprecated — use "profile" instead. |
| profile | string | – | Named profile (omit for active profile) |
No output schema declared.
No examples provided.
pg_constraint_list ~49
List constraints (primary key, foreign key, unique, check) for a table.
| Name | Type | Req | Description |
|---|---|---|---|
| schema | string | – | Schema name (default: 'public') |
| table | string | yes | Table name |
No output schema declared.
No examples provided.
pg_database_size ~15
Show size of all databases.
Input schema present but exposes no named parameters.
No output schema declared.
No examples provided.
pg_delete ~82
Delete rows matching a WHERE clause. Requires confirm: true.
| Name | Type | Req | Description |
|---|---|---|---|
| confirm | boolean | yes | Must be true to execute |
| params | array | – | Parameter values for WHERE clause |
| schema | string | – | Schema name (default: 'public') |
| table | string | yes | Table name |
| where | string | yes | WHERE clause (use $N for params) |
No output schema declared.
No examples provided.
pg_disconnect ~53
Disconnect from a PostgreSQL server profile. Omit profile to disconnect all.
| Name | Type | Req | Description |
|---|---|---|---|
| database | string | – | Deprecated — use "profile" instead. |
| profile | string | – | Named profile to disconnect (omit to disconnect all) |
No output schema declared.
No examples provided.
pg_enum_list ~17
List all enum types and their values.
Input schema present but exposes no named parameters.
No output schema declared.
No examples provided.
pg_extension_list ~17
List installed PostgreSQL extensions with versions.
Input schema present but exposes no named parameters.
No output schema declared.
No examples provided.
pg_function_list ~27
List functions and procedures with their signatures.
| Name | Type | Req | Description |
|---|---|---|---|
| schema | string | – | Schema name filter |
No output schema declared.
No examples provided.
pg_index_list ~47
List indexes for a table with type, columns, uniqueness, and size.
| Name | Type | Req | Description |
|---|---|---|---|
| schema | string | – | Schema name (default: 'public') |
| table | string | yes | Table name |
No output schema declared.
No examples provided.
pg_insert ~67
Insert one or more rows into a table. Returns inserted rows.
| Name | Type | Req | Description |
|---|---|---|---|
| columns | array | yes | Column names |
| schema | string | – | Schema name (default: 'public') |
| table | string | yes | Table name |
| values | array | yes | Values to insert (matches column order) |
No output schema declared.
No examples provided.
pg_list_connections ~34
List all configured connection profiles and their status. Each profile represents a PostgreSQL server instance (not a database within a server).
Input schema present but exposes no named parameters.
No output schema declared.
No examples provided.
pg_query ~60
Execute a parameterized SQL query. Returns rows as JSON. Use $1, $2, ... for parameters.
| Name | Type | Req | Description |
|---|---|---|---|
| params | array | – | Parameter values for placeholders |
| sql | string | yes | SQL query with $1, $2, ... placeholders |
No output schema declared.
No examples provided.
pg_query_explain ~133
Run EXPLAIN on a query. mode=plan (default, safe) shows the plan without executing. mode=analyze executes the statement and shows actual timing — ALWAYS requires confirm: true because EXPLAIN ANALYZE executes the statement.
| Name | Type | Req | Description |
|---|---|---|---|
| confirm | boolean | – | Required for mode=analyze. EXPLAIN ANALYZE executes the statement. |
| mode | string | – | Explain mode: 'plan' (safe, default) or 'analyze' (executes statement, requires confirm) |
| params | array | – | Parameter values |
| sql | string | yes | SQL query to explain |
No output schema declared.
No examples provided.
pg_query_prepared ~116
[DEPRECATED] Manage named prepared statements: PREPARE, EXECUTE, DEALLOCATE. ⚠️ Prepared statements are session-local in PostgreSQL and unreliable with connection pools — each pool checkout may get a different backend. Use parameterized pg_query instead.
| Name | Type | Req | Description |
|---|---|---|---|
| action | string | yes | Action to perform |
| name | string | yes | Prepared statement name (SQL identifier: letters, digits, underscores) |
| params | array | – | Parameters (for execute) |
| sql | string | – | SQL query (required for prepare) |
No output schema declared.
No examples provided.
pg_reload_config ~35
Reload server configuration files (postgresql.conf). Requires confirm: true.
| Name | Type | Req | Description |
|---|---|---|---|
| confirm | boolean | yes | Must be true to execute |
No output schema declared.
No examples provided.
pg_schema_list ~16
List all schemas in the database.
Input schema present but exposes no named parameters.
No output schema declared.
No examples provided.
pg_settings ~29
Show or search server configuration parameters.
| Name | Type | Req | Description |
|---|---|---|---|
| name | string | – | Filter settings by name (partial match) |
No output schema declared.
No examples provided.
pg_switch_database ~51
Deprecated — use pg_switch_profile instead. Switch the active connection profile.
| Name | Type | Req | Description |
|---|---|---|---|
| database | string | yes | Named profile to switch to (deprecated param name) |
| profile | string | – | Named profile to switch to |
No output schema declared.
No examples provided.
pg_switch_profile ~61
Switch the active connection profile. All subsequent queries will use this profile unless overridden. Each profile targets a specific PostgreSQL server instance.
| Name | Type | Req | Description |
|---|---|---|---|
| database | string | – | Deprecated — use "profile" instead. |
| profile | string | yes | Named profile to switch to |
No output schema declared.
No examples provided.
pg_table_describe ~50
Describe a table: columns, data types, defaults, nullability, and constraints.
| Name | Type | Req | Description |
|---|---|---|---|
| schema | string | – | Schema name (default: 'public') |
| table | string | yes | Table name |
No output schema declared.
No examples provided.
pg_table_list ~38
List tables in the database. Optionally filter by schema name.
| Name | Type | Req | Description |
|---|---|---|---|
| schema | string | – | Schema name filter (default: all user schemas) |
No output schema declared.
No examples provided.
pg_table_sizes ~39
Show table sizes with index and toast breakdown, sorted by total size descending.
| Name | Type | Req | Description |
|---|---|---|---|
| schema | string | – | Schema name filter (default: 'public') |
No output schema declared.
No examples provided.
pg_update ~94
Update rows matching a WHERE clause. Requires confirm: true.
| Name | Type | Req | Description |
|---|---|---|---|
| confirm | boolean | yes | Must be true to execute |
| params | array | – | Parameter values for WHERE clause |
| schema | string | – | Schema name (default: 'public') |
| set | object | yes | Column-value pairs to update |
| table | string | yes | Table name |
| where | string | yes | WHERE clause (use $N for params) |
No output schema declared.
No examples provided.
pg_upsert ~88
Insert or update on conflict. Requires confirm: true.
| Name | Type | Req | Description |
|---|---|---|---|
| columns | array | yes | Column names |
| confirm | boolean | yes | Must be true to execute |
| conflict_columns | array | yes | Columns for ON CONFLICT clause |
| schema | string | – | Schema name (default: 'public') |
| table | string | yes | Table name |
| values | array | yes | Values to insert |
No output schema declared.
No examples provided.
pg_uptime ~16
Show server uptime and start time.
Input schema present but exposes no named parameters.
No output schema declared.
No examples provided.
pg_version ~17
Get PostgreSQL version string and numeric version.
Input schema present but exposes no named parameters.
No output schema declared.
No examples provided.
pg_view_list ~31
List views with their definitions. Optionally filter by schema.
| Name | Type | Req | Description |
|---|---|---|---|
| schema | string | – | Schema name filter |
No output schema declared.
No examples provided.
How do I install the PostgreSQL MCP Server server?
PostgreSQL MCP Server runs locally as an npm package, launched with npx -y @itunified.io/mcp-postgres. Ready-made configuration for Claude, Cursor, VS Code, Codex and 5 more is on this page, copied from each client's own documentation.
npm · @itunified.io/mcp-postgres
claude mcp add itunified-io-postgres -- npx -y @itunified.io/mcp-postgres
What is the PostgreSQL MCP Server server?
PostgreSQL MCP Server is listed in the public MCP registry as io.github.itunified-io/postgres. PostgreSQL MCP Server, 27 tools for queries, schema, CRUD, DBA, HA & server management. This page covers its npm package (@itunified.io/mcp-postgres).
Is the PostgreSQL MCP Server server safe to use?
PostgreSQL MCP Server scores 73 out of 100 on VerifyMCP. We recorded 1 known advisory against it as of 5 November 2026. It declares no install or post-install scripts. That is a record of what we were able to check automatically, not an endorsement. The category breakdown on this page shows every signal behind the number, including the ones we could not confirm.
What tools does the PostgreSQL MCP Server server expose?
PostgreSQL MCP Server exposes 28 tools: pg_connect, pg_disconnect, pg_connection_status, pg_list_connections, pg_switch_profile, and 23 more. Their descriptions and schemas cost roughly 1,416 tokens of context every time the server is loaded.
Is the PostgreSQL MCP Server server still maintained?
PostgreSQL MCP Server is still listed as active in the MCP registry. We last reached this channel on 5 November 2026. Those dates come from our own scans of the registry and the channel itself, not from anything the publisher announced.
What licence is the PostgreSQL MCP Server server under?
PostgreSQL MCP Server declares the AGPL-3.0-only licence, which is OSI-approved. That covers the source only, and says nothing about the cost of any service it calls.