Skip to content
plugmcp
DirectorySkillsCategoriesBlog
EN/δΈ­ζ–‡
Sign inSign up
Directory/io.github.antonorlov
P
MCP serverOfficial registry

PostgreSQL

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

by io.github.antonorlovv0.3.1GitHubnpmWebsite

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.

Power your agent

Add this server

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

Step-by-step: add this in Claude

Remote URL or a command on your machine? How the two installs differ

Run on PlugMCP

Host a copy with our keys and logs.

A new server you create. It is not this listing's official endpoint. Use the publisher install when you want their URL and their credentials.

Launch
Related MCP

More like this

View more

  • 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

    Official
    io.github.awkoy

    Token-auth Notion MCP: pages, databases, blocks, comments, files. Runs headless in CI and agents.

    175 starsLocal

  • Context7

    upstash

    Context7 Platform -- Up-to-date code documentation for LLMs and AI code editors

    63k starsRemotevibe-coding

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

Suggested
  • FirecrawlπŸ”₯ Official Firecrawl MCP Server - Adds powerful web scraping and search to Cursor, Claude and any other LLM clients.
  • N
    NotionToken-auth Notion MCP: pages, databases, blocks, comments, files. Runs headless in CI and agents.
  • Context7Context7 Platform -- Up-to-date code documentation for LLMs and AI code editors

README is not crawled yet. Open the repository

Suggested
  • FirecrawlπŸ”₯ Official Firecrawl MCP Server - Adds powerful web scraping and search to Cursor, Claude and any other LLM clients.
  • N
    NotionToken-auth Notion MCP: pages, databases, blocks, comments, files. Runs headless in CI and agents.
  • Context7Context7 Platform -- Up-to-date code documentation for LLMs and AI code editors
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.
Suggested
  • FirecrawlπŸ”₯ Official Firecrawl MCP Server - Adds powerful web scraping and search to Cursor, Claude and any other LLM clients.
  • N
    NotionToken-auth Notion MCP: pages, databases, blocks, comments, files. Runs headless in CI and agents.
  • Context7Context7 Platform -- Up-to-date code documentation for LLMs and AI code editors

No tool list yet. Remote servers get one after the first health check.

Suggested
  • FirecrawlπŸ”₯ Official Firecrawl MCP Server - Adds powerful web scraping and search to Cursor, Claude and any other LLM clients.
  • N
    NotionToken-auth Notion MCP: pages, databases, blocks, comments, files. Runs headless in CI and agents.
  • Context7Context7 Platform -- Up-to-date code documentation for LLMs and AI code editors
plugmcp

Plug any tool into any agent. MCP servers for people who do not write servers. Gateway for volume, n8n for apps.

  • github.com/TODO
  • x.com/TODO
  • linkedin.com/company/TODO

PlugMCP, 2026

Product
  • Browse
  • Install
  • Host your own
  • Voice mode
  • Browser
Directory
  • All MCP servers
  • Agent skills
  • Categories
  • New
  • Voice
  • Submit a server
Developers
  • Docs
  • Blog
  • What is MCP
  • What is WebMCP
  • Status
Company
  • About
  • Contact
  • Terms
  • Privacy
  • DPA
  • [email protected]