Postgres MCP Pro

What it does

• Way beyond query passthrough: index tuning, EXPLAIN plan analysis, health checks (buffer cache, vacuum, replication lag)
• --access-mode=restricted for read-only + resource limits; unrestricted for dev
• Docker (crystaldba/postgres-mcp), pipx, uvx or uv — all driven by a DATABASE_URI env var
• SSE transport option lets several clients share one server

When to use it

When 'run a SELECT' isn't enough — ask Claude to actually tune the database: find missing indexes, validate query plans, flag unhealthy tables. The strongest Postgres MCP for real DBA work.

Getting started

{
  "command": "uvx",
  "args": ["postgres-mcp", "--access-mode=restricted"],
  "env": { "DATABASE_URI": "postgresql://user:pass@localhost:5432/dbname" }
}

Docker variant remaps localhost → host.docker.internal automatically on macOS/Windows.

Things to know

Index tuning and full analysis need pg_stat_statements + hypopg extensions installed on the database — not every hosted Postgres allows that (RDS does, many serverless offerings don't). unrestricted mode is real write access.