pgmcp for Claude Code
io.github.pascalallen/pgmcp
Read-only Postgres ops/DBA diagnostics: slow queries, EXPLAIN, locks, index and table health.
client:Claude Code
transport:stdio
runtime:oci
Install pgmcp in Claude Code
run in your project directory
claude mcp add pgmcp -e PGMCP_DATABASE_URL=<PGMCP_DATABASE_URL> -- docker run -i --rm ghcr.io/pascalallen/pgmcp:1.1.0
Adds it for this project only. Append --scope user to make it available everywhere. Claude Code docs