Loading…
Read-only Postgres ops/DBA diagnostics: slow queries, EXPLAIN, locks, index and table health.
pgmcp is an MCP server entry in ChatHome Skills, sourced from Official MCP Registry and scored 73/100. As a Model Context Protocol server, it exposes tools that MCP-compatible LLM clients such as Claude, Cursor, and Copilot can call directly, extending an agent's reach beyond its built-in capabilities. ChatHome Skills discovered this entry through its daily ingest of official registries and GitHub discovery queries, and re-verifies repository facts, freshness signals, and install metadata on every run. The quality score weighs official-registry presence, a working install command, license clarity, GitHub star trajectory, and repository freshness — the full formula is on the Sources page. The install command above is ready to copy. Review the last-pushed date and repository status before adding pgmcp to a production agent workflow; the snapshot facts below are point-in-time values from the most recent ingest.
docker run -i --rm ghcr.io/pascalallen/pgmcp:1.1.0Review the upstream source before running this command.
{
"_meta": {
"io.modelcontextprotocol.registry/official": {
"status": "active",
"isLatest": true,
"updatedAt": "2026-08-20T19:02:27.150786Z",
"publishedAt": "2026-08-20T19:02:27.150786Z",
"statusChangedAt": "2026-08-20T19:02:27.150786Z"
}
},
"server": {
"name": "io.github.pascalallen/pgmcp",
"title": "pgmcp",
"$schema": "https://static.modelcontextprotocol.io/schemas/2025-12-11/server.schema.json",
"version": "1.1.0",
"packages": [
{
"transport": {
"type": "stdio"
},
"identifier": "ghcr.io/pascalallen/pgmcp:1.1.0",
"registryType": "oci",
"environmentVariables": [
{
"name": "PGMCP_DATABASE_URL",
"isSecret": true,
"isRequired": true,
"description": "Postgres connection string (read-only role recommended)"
}
]
},
{
"transport": {
"type": "stdio"
},
"fileSha256": "10c7a4c328edddbcc0e1b0c3df7f25113b865676861bed79a52d9a4b9246ad13",
"identifier": "https://github.com/pascalallen/pgmcp/releases/download/v1.1.0/pgmcp_1.1.0.mcpb",
"registryType": "mcpb",
"environmentVariables": [
{
"name": "PGMCP_DATABASE_URL",
"isSecret": true,
"isRequired": true,
"description": "Postgres connection string (read-only role recommended)"
}
]
}
],
"repository": {
"url": "https://github.com/pascalallen/pgmcp",
"source": "github"
},
"websiteUrl": "https://github.com/pascalallen/pgmcp",
"description": "Read-only Postgres ops/DBA diagnostics: slow queries, EXPLAIN, locks, index and table health."
}
}