PostgreSQL MCP Server
NPM · @ITUNIFIED.IO/MCP-POSTGRES · SCANNED AUG 3
PostgreSQL MCP Server — 27 tools for queries, schema, CRUD, DBA, HA & server management
Available components
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 →
Supply Chain Security87
- No malware found by supply-chain analysis.Pass
- Only part of the dependency tree could be resolved (109 of 113), so this covers what we could see, not the whole tree.Partial
- No install/post-install scripts declared.Pass
- Only part of the dependency tree could be resolved (109 of 113), so this covers what we could see, not the whole tree. View diagnostics → Partial
Provenance & Transparency45
- Source repository is publicly reachable at the declared URL. View diagnostics → Pass
- 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 114 days ago).Pass
- Disclosure check failed: no security disclosure policy was found in the source repository. See how to fix → Fail
Schema Quality & AI Usability73
- AI-judged instruction clarity (good).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 Management27
- Stability observed for 8 of 30 days with no destabilising changes; credit accrues until the full window elapses.Partial
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
Capabilities100
- Implements a supported MCP spec version (2025-11-25); the latest is 2026-07-28.Pass
Add this component to your MCP client. Where a client-specific snippet is available, pick your client below and copy it straight into your config; otherwise use the connection detail shown.
npm · @itunified.io/mcp-postgres
claude mcp add itunified-io-postgres -- npx -y @itunified.io/mcp-postgres
codex mcp add itunified-io-postgres -- npx -y @itunified.io/mcp-postgres
{
"$schema": "https://opencode.ai/config.json",
"mcp": {
"itunified-io-postgres": {
"type": "local",
"command": [
"npx",
"-y",
"@itunified.io/mcp-postgres"
],
"enabled": true
}
}
} openclaw mcp add itunified-io-postgres --command npx --arg -y --arg @itunified.io/mcp-postgres
mcp_servers:
itunified-io-postgres:
command: "npx"
args: ["-y", "@itunified.io/mcp-postgres"] {
"mcpServers": {
"itunified-io-postgres": {
"command": "npx",
"args": [
"-y",
"@itunified.io/mcp-postgres"
]
}
}
} 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 Aug 26 +1
No change was recorded against any check on this day. Stability & Change Management went from 23 to 27. That category is still filling its 30-day observation window: 7 days of observed history at the previous scan, 8 at this one. The score rises as the window fills, whether or not the server changes.
- 2 Aug 26 +42
- Provenance: unverified → fail ▼ security
- Known CVEs: unverified → partial ▲ security
- Install scripts: unverified → pass ▲ security
- Malware scan: unverified → pass ▲ security
- Stability: Stability not yet verified: we do not have a sandbox capture of the MCP schema this version of the package serves yet. security
- Capabilities: pass → unverified ▼ functional
- Schema quality: unverified → good ▲ functional
- Maintenance: unverified → pass ▲ functional
- Dependency health: unverified → partial ▲ functional
- Stability: unverified → 0.23 ▲ functional
- License: unverified → pass ▲ functional
- Licence: AGPL-3.0-only functional
- 1 Aug 26 +5
- Stability: Stability not yet verified: not enough scan history yet (needs a 30-day window). security
- MCP protocol: unverified → pass ▲ functional
- 31 Jul 26 −7
- We updated how we score, so this day's move reflects our rubric, not a change to the server See what changed → functional
- 30 Jul 26 −18
- Malware scan: pass → unverified ▼ security
- 28 Jul 26 +22
- Tool coverage: unverified → 100 ▲ functional
- First check of Schema quality: fail functional
- First check of Tool coverage: 100 functional
- First check of Schema quality: unverified functional
- First check of Schema quality: pass functional
- 27 Jul 26 24
First indexed and scored.
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 3 Aug 2026 · Analysed npm/@itunified.io/[email protected]
Provenance none
Ecosystem: npm · Outcome: none
Dependencies 109 packages
109 packages in the resolved dependency tree · 109 deprecated · 33 stale.
The dependency tree was only partially resolved, so these counts may be incomplete.
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.
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.