Read-only Postgres ops/DBA diagnostics: slow queries, EXPLAIN, locks, index and table health.
Runs locally over stdio
This server isn't hosted — your MCP client launches it from a package registry. Use one of the commands below, or drop the config into your client (e.g. Claude Desktop).
Run
docker run -i --rm ghcr.io/pascalallen/pgmcp:1.1.0
MCP client config
{
"mcpServers": {
"pgmcp": {
"command": "docker",
"args": [
"run",
"-i",
"--rm",
"ghcr.io/pascalallen/pgmcp:1.1.0"
]
}
}
}Distributed as an MCP bundle (`https://github.com/pascalallen/pgmcp/releases/download/v1.1.0/pgmcp_1.1.0.mcpb`) — download it and import the bundle in your MCP client.