PluginBench
MCP Server
Active

Postgres MCP MCP Server

io.github.edelciomolina/postgres-mcp

RepositoryRegistry
How to choose

What this kind of tool is for

  • Query, inspect, or seed a database without writing a one-off script.
  • Let your agent look up schema details before it writes migration code.
  • Move a small dataset between tools without leaving the terminal.

How to compare servers like this

Engine match:
Confirm it speaks your exact database and version, not just the family.
Access scope:
Read-only connections are the safe default — start there before granting writes.
Safety rails:
Check whether destructive statements need an explicit confirmation before they run.
Maintenance signal:
Database drivers change; a recently updated tool is less likely to break mid-query.

This page carries your copy-paste config: pick your MCP client in the install section on this page and use the copy button.

What is the Postgres MCP MCP server?

PostgreSQL MCP wrapper with .env credential mapping, tool selection, and safe read-only defaults.

How to install Postgres MCP

Copy-paste configuration for popular MCP clients.

transport: stdio
Config generated by PluginBench — verify against the source before use.
Environment / auth
  • MCP_KEY_HOST

    Name of the .env variable that holds the database host

  • MCP_KEY_PORT

    Name of the .env variable that holds the database port

  • MCP_KEY_NAME

    Name of the .env variable that holds the database name

  • MCP_KEY_USER

    Name of the .env variable that holds the database user

  • MCP_KEY_PASS

    Name of the .env variable that holds the database password

  • MCP_KEY_SSLMODE

    Name of the .env variable that holds the SSL mode (e.g. require)

~/Library/Application Support/Claude/claude_desktop_config.json
JSON config
{
  "mcpServers": {
    "postgres-mcp": {
      "command": "npx",
      "args": [
        "-y",
        "@edelciomolina/postgres-mcp"
      ],
      "env": {
        "MCP_KEY_HOST": "<YOUR_MCP_KEY_HOST>",
        "MCP_KEY_PORT": "<YOUR_MCP_KEY_PORT>",
        "MCP_KEY_NAME": "<YOUR_MCP_KEY_NAME>",
        "MCP_KEY_USER": "<YOUR_MCP_KEY_USER>",
        "MCP_KEY_PASS": "<YOUR_MCP_KEY_PASS>",
        "MCP_KEY_SSLMODE": "<YOUR_MCP_KEY_SSLMODE>"
      }
    }
  }
}

Related MCP servers

Agentic visitor analytics — five tools that hand the next CRO fix to your coding agent.

View repository →

Remote MCP for Japan's EDINET DB — 3,800 listed companies' financials & filings (OAuth)

0
MIT
View repository →

MCP tools for Malawian food search, clinical nutrition calculators, and RAG-backed guidance.

0
TypeScript
MIT
View repository →

Read-only MCP server for licensed Healthpoint HL7 FHIR API access.

0
Rust
Apache-2.0
View repository →

Scan websites for AI visibility and marketing health with interactive dashboard.

0
JavaScript
View repository →

Search 529K US statute sections. 50 states + USC + CFR. Semantic search, citation graph, MCP.

View repository →