pgmcp
Read-only Postgres ops/DBA diagnostics: slow queries, EXPLAIN, locks, index and table health
What you can do with it
Share of each task's required capabilities it coversPrefer a ready-made agent?
An MCP server is a connector for your own assistant. These finished products do the job for you: query databases in plain language.Similar tools
Listed for the same task: query databases in plain languageReviews
No review yet. Used pgmcp? Be the first to help others choose.What it does
pgmcp is an MCP server, a connector that lets an AI assistant use it as a tool. It is installed locally as a package and runs on your machine.
From the publisher's description, Electra Index matched it to one capability: sql querying. That makes it a candidate for tasks such as query databases in plain language or build data pipelines.
Facts come from the Official MCP Registry, as declared by the publisher. Capabilities are matched automatically (low confidence). None of this is a test of the tool.
At a glance
How to connect
As declared in the Official MCP Registry · not tested by Electra IndexInstall packages
- MCP BUNDLE
https://github.com/pascalallen/pgmcp/releases/download/v1.1.0/pgmcp_1.1.0.mcpb· runs locally (stdio) - DOCKER
ghcr.io/pascalallen/pgmcp:1.1.0· runs locally (stdio)
Required: PGMCP_DATABASE_URL (get it from the publisher)
MCP settings (Claude Desktop, Cursor and other MCP clients)
{
"mcpServers": {
"pgmcp": {
"command": "docker",
"args": [
"run",
"-i",
"--rm",
"-e",
"PGMCP_DATABASE_URL",
"ghcr.io/pascalallen/pgmcp:1.1.0"
],
"env": {
"PGMCP_DATABASE_URL": "<your PGMCP_DATABASE_URL>"
}
}
}
}Replace the values in <angle brackets>.
Facts & evidence
Each fact shows where it was seen and when.| Fact | Value | Evidence | Source | Last confirmed |
|---|---|---|---|---|
| Install package | https://github.com/pascalallen/pgmcp/releases/download/v1.1.0/pgmcp_1.1.0.mcpb, ghcr.io/pascalallen/pgmcp:1.1.0 | DECLARED | SRC-001 Official MCP Registry | 14h ago |
| Package registries | mcpb, oci | DECLARED | SRC-001 Official MCP Registry | 14h ago |
| Local install (package) | yes | DECLARED | SRC-001 Official MCP Registry | 14h ago |
| Remote access (hosted) | no | DECLARED | SRC-001 Official MCP Registry | 14h ago |
| Website | https://github.com/pascalallen/pgmcp | DECLARED | SRC-001 Official MCP Registry | 14h ago |
| Repository | https://github.com/pascalallen/pgmcp | DECLARED | SRC-001 Official MCP Registry | 14h ago |
| Registry status | active | DECLARED | SRC-001 Official MCP Registry | 14h ago |
| Version | 1.1.0 | DECLARED | SRC-001 Official MCP Registry | 14h ago |
| MCP server | yes | DECLARED | SRC-001 Official MCP Registry | 14h ago |
Change history
Is this page accurate?
Flag it and our robot re-checks the official source. Reports never change a score.Is pgmcp still online?
Free alerts · no account▲ 0Do you publish pgmcp? Get it seen by people choosing a tool
For publishers · optionalLaunch Spotlight: 60 days of clearly labelled Sponsored visibility on the use-case pages where pgmcp already appears, plus the weekly Pulse. No click in 60 days? The next 60 days are free.
Sponsored placements never change a score or a rank.
Questions about pgmcp
How do I connect pgmcp?
Install the MCP bundle package https://github.com/pascalallen/pgmcp/releases/download/v1.1.0/pgmcp_1.1.0.mcpb. The exact settings are in "How to connect" above, as declared in the Official MCP Registry.
Does pgmcp need an API key or token?
Yes. The registry entry lists a required value: PGMCP_DATABASE_URL. Get it from the publisher.
What can I use pgmcp for?
Based on its description, it is most relevant to: query databases in plain language, build data pipelines.