# PostgreSQL (npm · mcp-postgres-server)

MCP server for PostgreSQL: local, Docker, RDS, Neon, Supabase, or behind an SSH bastion.

- Trust score: 72/100 (medium)
- Registry status: active
- Liveness: live
- Owner verified: no
- Last scored: 2026-09-20

## Components

- npm · `mcp-postgres-server`: 72/100 (this document), [markdown](https://verifymcp.io/servers/antonorlov-mcp-postgres-server/mcp-postgres-server.md), [page](https://verifymcp.io/servers/antonorlov-mcp-postgres-server/mcp-postgres-server)

## Channel facts

- Registry: `npm`
- Package: `mcp-postgres-server`
- Version: `0.3.1`
- Transport: `stdio`

## Trust breakdown

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. Scores are 0–100 per category. Scoring method: https://verifymcp.io/docs/scoring (what has changed: https://verifymcp.io/docs/scoring/changelog)

Scored 2026-09-20.

- **Supply Chain Security**: 98/100
  - No malware found by supply-chain analysis.
  - No known CVEs affecting this package version or its production dependencies.
  - No install/post-install scripts declared.
  - 39 of 117 dependencies flagged as unhealthy.
- **Provenance & Transparency**: 48/100
  - Source repository is publicly reachable at the declared URL.
  - Provenance check failed: no build-provenance attestation is published.
  - Clear OSI-approved license (MIT).
  - Actively maintained (last published 5 days ago).
  - Publishes a security disclosure policy (SECURITY.md).
- **Schema Quality & AI Usability**: 83/100
  - AI-judged instruction clarity (excellent).
  - Tool/resource definitions use about 483 tokens (~96/item across 5 items; 5 tools + 0 resources), lean.
  - Usage-examples check failed: none of the tools include examples.
- **Stability & Change Management**: 0/100
  - Stability not yet verified: not enough scan history yet (needs a 30-day window).
- **Tool Coverage**: 100/100
  - 100% of tools have a non-trivial description (not blank, and not just the tool's name).
  - 100% of tool parameters carry a description.
- **Tool Safety**: 100/100
  - No prompt-injection markers were found in the server instructions, tool names or descriptions we captured.
  - All 1 tool(s) whose name or description implies an irreversible operation declare an MCP destructiveHint annotation.
  - An AI judge read all 5 captured unit(s) of tool text and found none that tries to manipulate the model reading it.
- **Capabilities**: 100/100
  - Implements a supported MCP spec version (2025-11-25); the latest is 2026-07-28.

**Unverified: 1 category.** A category scored 0 because we could not verify it: a data source with nothing on this package, evidence we could not reach, or a check we could not run. We only credit what we can confirm.

## Install

### How do I install the PostgreSQL MCP server?

PostgreSQL runs locally as an npm package, launched with npx -y mcp-postgres-server. Ready-made configuration for Claude, Cursor, VS Code, Codex and 5 more is on this page, copied from each client's own documentation.

### Claude

```bash
claude mcp add antonorlov-mcp-postgres-server -- npx -y mcp-postgres-server
```

### Cursor

```json
{
  "mcpServers": {
    "antonorlov-mcp-postgres-server": {
      "command": "npx",
      "args": [
        "-y",
        "mcp-postgres-server"
      ]
    }
  }
}
```

### VS Code

```json
{
  "servers": {
    "antonorlov-mcp-postgres-server": {
      "command": "npx",
      "args": [
        "-y",
        "mcp-postgres-server"
      ]
    }
  }
}
```

### Codex

```bash
codex mcp add antonorlov-mcp-postgres-server -- npx -y mcp-postgres-server
```

### opencode

```json
{
  "$schema": "https://opencode.ai/config.json",
  "mcp": {
    "antonorlov-mcp-postgres-server": {
      "type": "local",
      "command": [
        "npx",
        "-y",
        "mcp-postgres-server"
      ],
      "enabled": true
    }
  }
}
```

### OpenClaw

```bash
openclaw mcp add antonorlov-mcp-postgres-server --command npx --arg -y --arg mcp-postgres-server
```

### Hermes

```yaml
mcp_servers:
  antonorlov-mcp-postgres-server:
    command: "npx"
    args: ["-y", "mcp-postgres-server"]
```

### Netclaw

```json
{
  "McpServers": {
    "antonorlov-mcp-postgres-server": {
      "Transport": "stdio",
      "Command": "npx",
      "Arguments": [
        "-y",
        "mcp-postgres-server"
      ]
    }
  }
}
```

### Vellum

```bash
assistant mcp add antonorlov-mcp-postgres-server -t stdio -c npx -a -y mcp-postgres-server
```

### Other

```json
{
  "mcpServers": {
    "antonorlov-mcp-postgres-server": {
      "command": "npx",
      "args": [
        "-y",
        "mcp-postgres-server"
      ]
    }
  }
}
```

## Changelog

Every change recorded for this component, newest first. Days that predate change tracking, or that we cannot explain, say so: "we were watching and nothing happened" and "we were not watching" are different claims.

### 2026-09-15 (score 72, +26)

- [security improvement] Malware scan: unverified → pass
- [security improvement] Known CVEs: unverified → pass
- [functional improvement] Dependency health: unverified → 0.85

### 2026-09-14 (score 46)

First indexed and scored.

## MCP tools (5)

### `query` (~180 tokens)

Run read-only SQL

Run one read-only SQL statement against the connected PostgreSQL database and get rows back as JSON. Send exactly one statement per call (SELECT, WITH, EXPLAIN, or SHOW). It runs inside an engine-enforced read-only transaction, so any write is refused by the database. Use this tool for all data reading, aggregation, and query planning. Returns {rows, rowCount, returnedRows, truncated}, plus hint when truncated is true. Prefer $1, $2 placeholders with the params array over interpolating values. Results are capped at ~32768 bytes; truncated:true means rows were dropped - add LIMIT/WHERE or select fewer columns.

Input parameters:

- `params` (array): Positional parameter values bound to $1, $2, ... placeholders.
- `sql` (string, required): One SQL statement. Use $1, $2, ... for parameters.

### `execute` (~108 tokens)

Run a write statement (disabled)

Run a data-modifying SQL statement (INSERT/UPDATE/DELETE or DDL). Currently DISABLED: the server is read-only, so this returns an error and changes nothing. To enable writes, the operator must start the server with PG_ALLOW_WRITE=true.

Input parameters:

- `params` (array): Positional parameter values bound to $1, $2, ... placeholders.
- `sql` (string, required): One INSERT / UPDATE / DELETE / DDL statement. Use $1, $2, ... for parameters.

### `list_schemas` (~46 tokens)

List schemas

List every schema in the connected database. Start here when exploring an unfamiliar database, then call list_tables for the schema you care about. Returns {schemas: [name, ...]}.

### `list_tables` (~63 tokens)

List tables

List all tables in a schema (default: 'public'). Use this before querying tables you have not seen yet, then call describe_table for column details. Returns {tables: [name, ...]}.

Input parameters:

- `schema` (string): Schema name (default: 'public')

### `describe_table` (~86 tokens)

Describe a table

Show the structure of one table: column names, data types, nullability, defaults, and primary-key membership. Call this before writing non-trivial queries against a table. Returns {columns: [{column, type, nullable, default, is_primary_key}, ...]}.

Input parameters:

- `schema` (string): Schema name (default: 'public')
- `table` (string, required): Table name

## Diagnostics

Captured diagnostic sections: Provenance, Dependencies. The full working is on the page: https://verifymcp.io/servers/antonorlov-mcp-postgres-server/mcp-postgres-server#diagnostics

## Score history

- 2026-09-20: 72
- 2026-09-19: 72
- 2026-09-18: 72
- 2026-09-17: 72
- 2026-09-16: 72
- 2026-09-15: 72
- 2026-09-14: 46

## Common questions

### What is the PostgreSQL MCP server?

PostgreSQL is an MCP server listed in the public MCP registry as io.github.antonorlov/mcp-postgres-server. MCP server for PostgreSQL: local, Docker, RDS, Neon, Supabase, or behind an SSH bastion. This page covers its npm package (mcp-postgres-server).

### Is the PostgreSQL MCP server safe to use?

PostgreSQL scores 72 out of 100 on VerifyMCP. We found no known CVEs affecting it as of 20 September 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 expose?

PostgreSQL exposes 5 tools: query, execute, list_schemas, list_tables, describe_table. Their descriptions and schemas cost roughly 483 tokens of context every time the server is loaded.

### Is the PostgreSQL MCP server still maintained?

PostgreSQL is still listed as active in the MCP registry. We last reached this channel on 20 September 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 under?

PostgreSQL declares the MIT licence, which is OSI-approved. That covers the source only, and says nothing about the cost of any service it calls.

## Links

- npm package: https://www.npmjs.com/package/mcp-postgres-server
- Socket report: https://socket.dev/npm/package/mcp-postgres-server
- Repository: https://github.com/antonorlov/mcp-postgres-server
- Changelog RSS feed: https://verifymcp.io/servers/antonorlov-mcp-postgres-server/mcp-postgres-server.xml
- Changelog JSON feed: https://verifymcp.io/servers/antonorlov-mcp-postgres-server/mcp-postgres-server.json
- HTML version of this page: https://verifymcp.io/servers/antonorlov-mcp-postgres-server/mcp-postgres-server