Distributism logoDistributism

Data & APIs

Postgres MCP Pro

postgres-mcp connects agents to PostgreSQL for schema inspection, query assistance, and database operations. Official docs recommend Docker or pipx; the Docker config below is the safest default for local development.

Stars

3.1k

Installs

95.0k

License

MIT

Kind

MCP

Trust evidence

Verified

Verified MCP — curated catalog entry with reviewed setup metadata.

  • Stars: 3.1k · catalog
  • Freshness: Updated 2026-06-01
  • Used in 0 known stacks (editorial graph may still apply)

Prerequisites

  • · Host app that loads MCP config (Cursor, Claude Desktop, etc.)
  • · Environment: DATABASE_URI
  • · Python 3 + pip

Reference command

{
  "mcpServers": {
    "postgres": {
      "command": "docker",
      "args": [
        "run",
        "-i",
        "--rm",
        "-e",
        "DATABASE_URI",
        "crystaldba/postgres-mcp",
        "--access-mode=unrestricted"
      ],
      "env": {
        "DATABASE_URI": "postgresql://username:password@localhost:5432/dbname"
      }
    }
  }
}

Often stacked with