PostgreSQL MCP

v0.3.1

io.github.antonorlov/mcp-postgres-server

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

transport:stdio runtime:npm

View source Website

Target client

run in your project directory

DATABASE_URL

PG_HOST

PG_PORT

PG_USER

PG_PASSWORD

PG_DATABASE

PG_ALLOW_WRITE

PG_SSLMODE

PG_SSL_CA

PG_ENABLE_RUNTIME_CONNECT

PG_MAX_RESULT_BYTES

PG_STATEMENT_TIMEOUT

PG_CONNECT_TIMEOUT

PG_SSH_HOST

PG_SSH_PORT

PG_SSH_USER

PG_SSH_PRIVATE_KEY

PG_SSH_PASSPHRASE

PG_SSH_AGENT

PG_SSH_PASSWORD

PG_SSH_FINGERPRINT

PG_SSH_KEEPALIVE_INTERVAL

Held in this page only — never stored, logged, or sent anywhere but back to your screen.

claude mcp add mcp-postgres-server -e DATABASE_URL=<DATABASE_URL> -e PG_HOST=<PG_HOST> -e PG_PORT=<PG_PORT> -e PG_USER=<PG_USER> -e PG_PASSWORD=<PG_PASSWORD> -e PG_DATABASE=<PG_DATABASE> -e PG_ALLOW_WRITE=<PG_ALLOW_WRITE> -e PG_SSLMODE=<PG_SSLMODE> -e PG_SSL_CA=<PG_SSL_CA> -e PG_ENABLE_RUNTIME_CONNECT=<PG_ENABLE_RUNTIME_CONNECT> -e PG_MAX_RESULT_BYTES=<PG_MAX_RESULT_BYTES> -e PG_STATEMENT_TIMEOUT=<PG_STATEMENT_TIMEOUT> -e PG_CONNECT_TIMEOUT=<PG_CONNECT_TIMEOUT> -e PG_SSH_HOST=<PG_SSH_HOST> -e PG_SSH_PORT=<PG_SSH_PORT> -e PG_SSH_USER=<PG_SSH_USER> -e PG_SSH_PRIVATE_KEY=<PG_SSH_PRIVATE_KEY> -e PG_SSH_PASSPHRASE=<PG_SSH_PASSPHRASE> -e PG_SSH_AGENT=<PG_SSH_AGENT> -e PG_SSH_PASSWORD=<PG_SSH_PASSWORD> -e PG_SSH_FINGERPRINT=<PG_SSH_FINGERPRINT> -e PG_SSH_KEEPALIVE_INTERVAL=<PG_SSH_KEEPALIVE_INTERVAL> -- npx -y mcp-postgres-server