pgmcp MCP
A read-only PostgreSQL operations and DBA diagnostics server for the Model Context Protocol. It allows agents to analyze slow queries, perform EXPLAIN analysis, monitor lock waits, check index and table health, view connections, replication status, and verify configuration settings using bounded SQL queries.
Package and access
Local package with source-attributed installation metadata. Koskamo does not execute packages during review.
What you can do with it
- Analyze slow queries and execution plans
- Monitor database lock waits and blocking sessions
- Check index and table health metrics
- Verify replication lag and configuration settings
Source and maintenance
Community listingRegistry 1.1.0
- Maintenance checked
Packages and installation
Source-provided package data. Koskamo has not executed or live-probed this package.
https://github.com/pascalallen/pgmcp/releases/download/v1.1.0/pgmcp_1.1.0.mcpb
mcpbSHA-256 supplied
https://github.com/pascalallen/pgmcp/releases/download/v1.1.0/pgmcp_1.1.0.mcpb package definition
{
"transport": "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",
"isRequired": true,
"description": "Postgres connection string (read-only role recommended)"
}
]
}Tools
Reported by the attributed source; not independently observed by Koskamo.
Let your agent find its tools
Find servers like pgmcp MCP from your agent. Add Koskamo once to search the index for endpoints, access requirements, and client setup. Public discovery needs no key.