Read-only Postgres ops/DBA diagnostics: slow queries, EXPLAIN, locks, index and table health.
Run one of the commands below, then add the client config underneath.
Dockerdocker run -i --rm ghcr.io/pascalallen/pgmcp:1.1.0mcpbhttps://github.com/pascalallen/pgmcp/releases/download/v1.1.0/pgmcp_1.1.0.mcpb
pgmcp is listed in the Health & Medical category of the MCPNav directory. It is distributed as Docker, mcpb and can be loaded by any client that speaks the Model Context Protocol.
Typical uses include giving your assistant scoped access to the corresponding service so it can answer questions and take actions with real data instead of guessing. Always review what a server can access before you enable it — see our MCP security guide.
pgmcp is an MCP server by pascalallen. Read-only Postgres ops/DBA diagnostics: slow queries, EXPLAIN, locks, index and table health.
Install it with: docker run -i --rm ghcr.io/pascalallen/pgmcp:1.1.0. Then add the JSON config to your client's MCP settings and restart the client.
The MCP server itself is free to install. The source is public on https://github.com/pascalallen/pgmcp. Any third-party API it calls (such as a search or maps API) may require its own key and billing.
Any MCP-compatible client can use it, including Claude Desktop, Cursor, VS Code, Windsurf and custom agents.