I
io.github.pascalallen/pgmcp
Read-only Postgres ops/DBA diagnostics: slow queries, EXPLAIN, locks, index and table health.
No known CVEs
MIT license
Actively maintained
Last commit 6d ago
Works with most clients
Transport: stdio, http
0 tools
Grade F
MCPpedia last refreshed this data
io.github.pascalallen/pgmcp is an MCP server that read-only Postgres ops/DBA diagnostics: slow queries, EXPLAIN, locks, index and table health. Its tool list has not been published yet over stdio and http, requires no API key, and scores 37/100 on MCPpedia's security, maintenance and efficiency rubric.
Step 1
Install in your client
Config is the same across clients — only the file and path differ.
CD
Supported in Claude Desktopstdio, http · Node 18+
Paste into ~/Library/Application Support/Claude/claude_desktop_config.json
{
"mcpServers": {
"pgmcp": {
"env": {
"PGMCP_DATABASE_URL": "postgres://pgmcp:…@db.internal:5432/app?sslmode=require"
},
"command": "pgmcp"
}
}
}Are you the author?
Add this badge to your README to show your security score and help users find safe servers.
Embed in your READMEAbout badges →
[](https://mcppedia.org/s/io-github-pascalallen-pgmcp)
Read me
What io.github.pascalallen/pgmcp does
pgmcp is a read-only PostgreSQL ops/DBA server for the Model Context Protocol, built on the official modelcontextprotocol/go-sdk. It answers the questions a DBA asks during an incident — which statements are slow, why this plan is slow, which indexes are dead weight, which tables autovacuum has fallen behind on, who is blocking whom, how far the standby is lagging — and it is read-only by construction rather than by convention: a dedicated database role that holds no write privilege, a BEGIN REA
Test This Server
No automated test available for this server. Check the GitHub README for setup instructions.
Scored, not listed
Why this score
Five weighted categories — click any category to see the underlying evidence.
Score breakdown
37/100across 5 weighted dimensions
0255075100
12
9
10
−63
Security
Maintenance
Efficiency
Documentation
Compatibility
Categoriesclick a row to see evidence
Security
OSV.devNo known CVEs.
No package registry to scan.
Community
Reviews
Be the first to review
Have you used this server?
Share your experience — it helps other developers decide.
How easy was setup?Did it work reliably?How was the documentation?
Sign in to write a review.
Frequently Asked Questions
- Is io.github.pascalallen/pgmcp safe to use?
- io.github.pascalallen/pgmcp has no known CVEs as of the latest MCPpedia security scan. It does not require authentication, so any local process can connect — keep this in mind in shared environments. Licensed under MIT.
- How do I install io.github.pascalallen/pgmcp?
- io.github.pascalallen/pgmcp supports copy-paste install configs on its MCPpedia page for Claude Desktop, Cursor, and Claude Code. Scroll to the Quick Install section and select your client.
- What AI clients work with io.github.pascalallen/pgmcp?
- io.github.pascalallen/pgmcp is compatible with claude-desktop, cursor, claude-code. It uses stdio and http transport.
- Is io.github.pascalallen/pgmcp actively maintained?
- io.github.pascalallen/pgmcp is actively maintained — last commit was 6 days ago.
Related
Similar servers
Others in data
Supabase MCP Server96Manage Supabase projects — databases, auth, storage, and edge functions
2.9k 4
Dbhub96Zero-dependency, token-efficient database MCP server for Postgres, MySQL, SQL Server, MariaDB, SQLite.
3.4k 2
Firecrawl Mcp Server95🔥 Official Firecrawl MCP Server - Adds powerful web scraping and search to Cursor, Claude and any other LLM clients.
7.3k 4
Mcp Server Typescript95DataForSEO API modelcontextprotocol server
242 9
MCP Security Weekly
Get CVE alerts and security updates for io.github.pascalallen/pgmcp and similar servers.
Community
Discussion
Start a conversation
Ask a question, share a tip, or report an issue.
Has anyone used this with Cursor?How do you handle auth?Any alternatives?
Sign in to join the discussion.