Loading
P
Summary
MCP server for PostgreSQL: local, Docker, RDS, Neon, Supabase, or behind an SSH bastion.
Install in Cursor, Claude, and VS Code
Publisher config for PostgreSQL. Paste it into the client. This is not a PlugMCP endpoint.
Cursor
{
"mcpServers": {
"io.github.antonorlov-mcp-postgres-server": {
"command": "npx",
"args": [
"-y",
"[email protected]"
],
"env": {
"DATABASE_URL": "<secret>",
"PG_HOST": "<value>",
"PG_PORT": "<value>",
"PG_USER": "<value>",
"PG_PASSWORD": "<secret>",
"PG_DATABASE": "<value>",
"PG_ALLOW_WRITE": "<value>",
"PG_SSLMODE": "<value>",
"PG_SSL_CA": "<value>",
"PG_ENABLE_RUNTIME_CONNECT": "<value>",
"PG_MAX_RESULT_BYTES": "<value>",
"PG_STATEMENT_TIMEOUT": "<value>",
"PG_CONNECT_TIMEOUT": "<value>",
"PG_SSH_HOST": "<value>",
"PG_SSH_PORT": "<value>",
"PG_SSH_USER": "<value>",
"PG_SSH_PRIVATE_KEY": "<value>",
"PG_SSH_PASSPHRASE": "<secret>",
"PG_SSH_AGENT": "<value>",
"PG_SSH_PASSWORD": "<secret>",
"PG_SSH_FINGERPRINT": "<value>",
"PG_SSH_KEEPALIVE_INTERVAL": "<value>"
}
}
}
}Claude Desktop
{
"mcpServers": {
"io.github.antonorlov-mcp-postgres-server": {
"command": "npx",
"args": [
"-y",
"[email protected]"
],
"env": {
"DATABASE_URL": "<secret>",
"PG_HOST": "<value>",
"PG_PORT": "<value>",
"PG_USER": "<value>",
"PG_PASSWORD": "<secret>",
"PG_DATABASE": "<value>",
"PG_ALLOW_WRITE": "<value>",
"PG_SSLMODE": "<value>",
"PG_SSL_CA": "<value>",
"PG_ENABLE_RUNTIME_CONNECT": "<value>",
"PG_MAX_RESULT_BYTES": "<value>",
"PG_STATEMENT_TIMEOUT": "<value>",
"PG_CONNECT_TIMEOUT": "<value>",
"PG_SSH_HOST": "<value>",
"PG_SSH_PORT": "<value>",
"PG_SSH_USER": "<value>",
"PG_SSH_PRIVATE_KEY": "<value>",
"PG_SSH_PASSPHRASE": "<secret>",
"PG_SSH_AGENT": "<value>",
"PG_SSH_PASSWORD": "<secret>",
"PG_SSH_FINGERPRINT": "<value>",
"PG_SSH_KEEPALIVE_INTERVAL": "<value>"
}
}
}
}Claude Code
DATABASE_URL=<secret> PG_HOST=<value> PG_PORT=<value> PG_USER=<value> PG_PASSWORD=<secret> PG_DATABASE=<value> PG_ALLOW_WRITE=<value> PG_SSLMODE=<value> PG_SSL_CA=<value> PG_ENABLE_RUNTIME_CONNECT=<value> PG_MAX_RESULT_BYTES=<value> PG_STATEMENT_TIMEOUT=<value> PG_CONNECT_TIMEOUT=<value> PG_SSH_HOST=<value> PG_SSH_PORT=<value> PG_SSH_USER=<value> PG_SSH_PRIVATE_KEY=<value> PG_SSH_PASSPHRASE=<secret> PG_SSH_AGENT=<value> PG_SSH_PASSWORD=<secret> PG_SSH_FINGERPRINT=<value> PG_SSH_KEEPALIVE_INTERVAL=<value> claude mcp add io.github.antonorlov-mcp-postgres-server -- npx -y [email protected]
VS Code
{
"servers": {
"io.github.antonorlov-mcp-postgres-server": {
"type": "stdio",
"command": "npx",
"args": [
"-y",
"[email protected]"
],
"env": {
"DATABASE_URL": "<secret>",
"PG_HOST": "<value>",
"PG_PORT": "<value>",
"PG_USER": "<value>",
"PG_PASSWORD": "<secret>",
"PG_DATABASE": "<value>",
"PG_ALLOW_WRITE": "<value>",
"PG_SSLMODE": "<value>",
"PG_SSL_CA": "<value>",
"PG_ENABLE_RUNTIME_CONNECT": "<value>",
"PG_MAX_RESULT_BYTES": "<value>",
"PG_STATEMENT_TIMEOUT": "<value>",
"PG_CONNECT_TIMEOUT": "<value>",
"PG_SSH_HOST": "<value>",
"PG_SSH_PORT": "<value>",
"PG_SSH_USER": "<value>",
"PG_SSH_PRIVATE_KEY": "<value>",
"PG_SSH_PASSPHRASE": "<secret>",
"PG_SSH_AGENT": "<value>",
"PG_SSH_PASSWORD": "<secret>",
"PG_SSH_FINGERPRINT": "<value>",
"PG_SSH_KEEPALIVE_INTERVAL": "<value>"
}
}
}
}Tools, access, and transport
- Transport
- stdio
- API key
- 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
- Pricing
- Not listed
No tool list on this record yet.
Alternatives
- Firecrawl — 🔥 Official Firecrawl MCP Server - Adds powerful web scraping and search to Cursor, Claude and any other LLM clients.
- Notion — Token-auth Notion MCP: pages, databases, blocks, comments, files. Runs headless in CI and agents.
- Context7 — Context7 Platform -- Up-to-date code documentation for LLMs and AI code editors
- RenCosta2025 Context7fork — Get up-to-date, version-specific documentation and code examples from official sources directly in…
- Exa — Exa MCP for web search and web crawling!
- Invisible Playwright — Playwright MCP server undetected by anti-bots and captchas: AI agent browses the web on anti-detect stealth Firefox, Python, undetected browser automation, scraping, computer use.
FAQ
- How do I install PostgreSQL?
- Copy the stdio config for Cursor, Claude Desktop, Claude Code, or VS Code on this page. It uses the publisher's install, not a PlugMCP proxy.
- Does PostgreSQL need an API key?
- The publisher lists these environment variables: 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.
- What transport does PostgreSQL use?
- PostgreSQL runs locally over stdio.
- When was PostgreSQL last checked?
- Last checked 2026-10-16. MCP server for PostgreSQL: local, Docker, RDS, Neon, Supabase, or behind an SSH bastion.
Last checked 2026-10-16. Publisher: io.github.antonorlov.
接入你的智能体
添加此服务器
The publisher's own command. Not a PlugMCP endpoint.
Local command
npx -y [email protected]
Credentials from the publisher
- DATABASE_URL — Full connection string (preferred). Supports sslmode in the URL.
- PG_HOST — Database host (fallback when DATABASE_URL is not set).
- PG_PORT — Database port.
- PG_USER — Database user.
- PG_PASSWORD — Database password.
- PG_DATABASE — Database name.
- PG_ALLOW_WRITE — When true, execute performs writes and reads are sent directly. Off (default) is read-only: execute refuses writes and each read runs in a READ ONLY transaction.
- PG_SSLMODE — TLS mode. require/allow/prefer encrypt without verifying the certificate; verify-ca/verify-full verify it (supply a CA via PG_SSL_CA). Unlike libpq, allow/prefer do not fall back to plaintext, so a server without TLS needs disable.
- PG_SSL_CA — Path to a CA certificate file. Setting it by itself implies verify-full.
- PG_ENABLE_RUNTIME_CONNECT — Register the connect_db tool (runtime credential switching).
- PG_MAX_RESULT_BYTES — Byte budget for a query result sent to the model. Whole rows are kept while they fit; over the budget returnedRows < rowCount and truncated is true.
- PG_STATEMENT_TIMEOUT — Statement timeout in milliseconds, applied to every session.
- PG_CONNECT_TIMEOUT — Timeout in milliseconds for a single connect attempt (raise it for slow links or SSH tunnels).
- PG_SSH_HOST — SSH bastion host. Setting it enables tunneling: the server reaches the database only through an SSH tunnel to this host. Needs the ssh2 optional dependency.
- PG_SSH_PORT — SSH bastion port.
- PG_SSH_USER — SSH username.
- PG_SSH_PRIVATE_KEY — Path to a private key file. If unset, auth falls back like ssh: a running agent (SSH_AUTH_SOCK), then a default key (~/.ssh/id_ed25519, id_rsa, id_ecdsa).
- PG_SSH_PASSPHRASE — Passphrase for the private key, if encrypted.
- PG_SSH_AGENT — true to use the ambient agent (SSH_AUTH_SOCK), or an explicit socket path / Windows named pipe.
- PG_SSH_PASSWORD — SSH login password. Opt-in; a key or agent takes precedence. Prefer keys, a bastion often disables password auth.
- PG_SSH_FINGERPRINT — Pinned host-key fingerprint (SHA256:...). Host-key verification is mandatory and set only this way: without it the tunnel refuses to connect. Get it with ssh-keygen -lF host.
- PG_SSH_KEEPALIVE_INTERVAL — SSH keepalive interval in ms; the tunnel drops after 3 unanswered keepalives, and the next call reconnects.
Provider
Claude Code
DATABASE_URL=<secret> PG_HOST=<value> PG_PORT=<value> PG_USER=<value> PG_PASSWORD=<secret> PG_DATABASE=<value> PG_ALLOW_WRITE=<value> PG_SSLMODE=<value> PG_SSL_CA=<value> PG_ENABLE_RUNTIME_CONNECT=<value> PG_MAX_RESULT_BYTES=<value> PG_STATEMENT_TIMEOUT=<value> PG_CONNECT_TIMEOUT=<value> PG_SSH_HOST=<value> PG_SSH_PORT=<value> PG_SSH_USER=<value> PG_SSH_PRIVATE_KEY=<value> PG_SSH_PASSPHRASE=<secret> PG_SSH_AGENT=<value> PG_SSH_PASSWORD=<secret> PG_SSH_FINGERPRINT=<value> PG_SSH_KEEPALIVE_INTERVAL=<value> claude mcp add io.github.antonorlov-mcp-postgres-server -- npx -y [email protected]
Run in a terminal.
Claude Desktop
{
"mcpServers": {
"io.github.antonorlov-mcp-postgres-server": {
"command": "npx",
"args": [
"-y",
"[email protected]"
],
"env": {
"DATABASE_URL": "<secret>",
"PG_HOST": "<value>",
"PG_PORT": "<value>",
"PG_USER": "<value>",
"PG_PASSWORD": "<secret>",
"PG_DATABASE": "<value>",
"PG_ALLOW_WRITE": "<value>",
"PG_SSLMODE": "<value>",
"PG_SSL_CA": "<value>",
"PG_ENABLE_RUNTIME_CONNECT": "<value>",
"PG_MAX_RESULT_BYTES": "<value>",
"PG_STATEMENT_TIMEOUT": "<value>",
"PG_CONNECT_TIMEOUT": "<value>",
"PG_SSH_HOST": "<value>",
"PG_SSH_PORT": "<value>",
"PG_SSH_USER": "<value>",
"PG_SSH_PRIVATE_KEY": "<value>",
"PG_SSH_PASSPHRASE": "<secret>",
"PG_SSH_AGENT": "<value>",
"PG_SSH_PASSWORD": "<secret>",
"PG_SSH_FINGERPRINT": "<value>",
"PG_SSH_KEEPALIVE_INTERVAL": "<value>"
}
}
}
}claude_desktop_config.json
Remote URL or a command on your machine? How the two installs differ
Related MCP
More like this
Firecrawl
firecrawl🔥 Official Firecrawl MCP Server - Adds powerful web scraping and search to Cursor, Claude and any other LLM clients.
7.6k starsRemotebatch-processingclaude- N
Notion
Officialio.github.awkoyToken-auth Notion MCP: pages, databases, blocks, comments, files. Runs headless in CI and agents.
175 starsLocal Context7
upstashContext7 Platform -- Up-to-date code documentation for LLMs and AI code editors
63k starsRemotevibe-coding
Related skills
Skills nearby
postgresql-table-design
wshobsonUse this skill when designing or reviewing a PostgreSQL-specific schema. Covers best-practices, data types, indexing, constraints, performance patterns, and advanced features
40.9k starssql-queries
phurynGenerate SQL queries from natural language descriptions. Supports BigQuery, PostgreSQL, MySQL, and other dialects. Reads database schemas from uploaded diagrams or documentation. Use when writing SQL,
27.1k stars- D
database-optimizer
JeffallanOptimizes database queries and improves performance across PostgreSQL and MySQL systems. Use when investigating slow queries, analyzing execution plans, or optimizing database performance. Invoke for
11.9k stars
MCP server for PostgreSQL: local, Docker, RDS, Neon, Supabase, or behind an SSH bastion.
README is not crawled yet. Open the repository
- How do I install PostgreSQL?
- Copy the stdio config for Cursor, Claude Desktop, Claude Code, or VS Code on this page. It uses the publisher's install, not a PlugMCP proxy.
- Does PostgreSQL need an API key?
- The publisher lists these environment variables: 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.
- What transport does PostgreSQL use?
- PostgreSQL runs locally over stdio.
- When was PostgreSQL last checked?
- Last checked 2026-10-16. MCP server for PostgreSQL: local, Docker, RDS, Neon, Supabase, or behind an SSH bastion.
No tool list yet. Remote servers get one after the first health check.