Skip to contentpgmcp MCP Server — Install for Claude, Cursor & VS Code | MCPpediaPpgmcp MCP Server
Read-only Postgres ops/DBA diagnostics: slow queries, EXPLAIN, locks, index and table health.
47FairInstall
~/Library/Application Support/Claude/claude_desktop_config.json
{
"mcpServers": {
"pascalallen-pgmcp": {
"command": "docker",
"args": [
"run",
"-i",
"--rm",
"ghcr.io/pascalallen/pgmcp:1.1.0"
],
"env": {
"PGMCP_DATABASE_URL": "YOUR_PGMCP_DATABASE_URL"
}
}
}
}
Related servers
MCP server for interacting with the Supabase platform
Environment
| Name | Required | Notes |
|---|
| PGMCP_DATABASE_URL | Yes | Postgres connection string (read-only role recommended) Secret. |
| PGMCP_DATABASE_URL | Yes | Postgres connection string (read-only role recommended) Secret. |
Tools show up when the registry metadata or the repository README lists them. GitHub enrichment fills this in when a token is configured.
About
Read-only Postgres ops/DBA diagnostics: slow queries, EXPLAIN, locks, index and table health.
FAQ
- What is pgmcp?
- Read-only Postgres ops/DBA diagnostics: slow queries, EXPLAIN, locks, index and table health.
- How do I install pgmcp?
- Pick a client above and copy the generated config. Cursor and VS Code also have a deep link when the server can run locally or remotely.
- Is pgmcp official?
- No. Registry-listed is not the same as vendor-official. Read the methodology for the difference.
- How is the trust score calculated?
- This listing scores 47 (Fair). The formula is published on the methodology page.
Reviews
0 published · no average
Sign in to review this server.
61
Good
SSH server management for agents, with per-server read-only and allowlist security modes
MCP Toolbox for Databases enables your agent to connect to your database.
ZAgent memory: working, episodic, semantic, procedural and core layers. Local SQLite, no account.
RNatural language interface designed for agentic applications to manage and search data in Redis.
HMake your agent's memory work like a brain. Hippo is long-term memory for coding agents.