Postgres

@modelcontextprotocol/server-postgres·by modelcontextprotocol·v0.4.1

Read-only access to Postgres databases, including schema introspection and parameterized queries.

ProvenanceWhere Atlas found this server. Each entry links back to the original listing.

§ Install

Edit your claude_desktop_config.json and add the following entry under mcpServers:

"postgres": {
  "command": "npx",
  "args": [
    "-y",
    "@modelcontextprotocol/server-postgres",
    "postgresql://localhost/mydb"
  ]
}

query()Run a read-only SQL SELECT against the configured database. Parameterized values supported.

list_tables()Return all user tables across the database, with schema and row count estimates.

describe_table()Return columns, types, defaults, and indexes for a given table.

list_schemas()Return all schemas the configured user can read.

Claude DesktopVerified

ClineVerified

ContinueReported working

CursorVerified

ZedReported working

Custom clientstdio compatible

Reads from your databaseThe configured user's read permissions apply. Use a dedicated read-only role.

Returns query results to your modelSensitive rows in returned data become part of the model context.

No write or DDL operationsINSERT, UPDATE, DELETE, and schema changes are rejected.

Connection string contains credentialsAvoid committing config files. Prefer environment variables.