MCPg
by devopam
PostgreSQL MCP server with 279 tools for safe queries, database operations, tuning, search, and specialized extensions.
Install MCPg
Pick your client, then add it in one click or paste the config.
~/Library/Application Support/Claude/claude_desktop_config.json{
"mcpServers": {
"devopam-mcpg": {
"command": "uvx",
"args": [
"mcpg"
],
"env": {
"MCPG_DATABASE_URL": "YOUR_VALUE_HERE"
}
}
}
}
Settings → Developer → Edit Config, merge this into mcpServers, then fully quit and reopen Claude Desktop.
Values are written into the snippet above so you can paste it as is. They never leave your browser.
We couldn’t confirm it starts correctly
We ran the install command but it didn't respond within our test window — this can mean a slow first-time install rather than a real problem.
uvx mcpgNo response to initialize.
This is an experimental automated check and can have false negatives — missing environment variables, a slow cold install, etc. It doesn’t necessarily mean something’s wrong. Last checked .
Overview
Use cases
- Inspect PostgreSQL schemas and system catalogs
- Generate and validate SQL from natural-language requests
- Tune indexes and analyze query plans
- Monitor locks, replicas, vacuum activity, and database health
- Query vector, time-series, spatial, or graph data
Key features
- 279 PostgreSQL-focused MCP tools
- AST-validated SQL with read-only defaults
- stdio and HTTP/SSE transports
- pgvector, TimescaleDB, PostGIS, and Apache AGE support
- Connection pooling, replica routing, and multi-tenancy controls
- Prometheus metrics and redacted audit events
Security & health
What it can reach and how reliably it runs — from our own checks, not the maintainer’s claims.
Recent health check succeeded.
Supply-chain signal
No high-severity advisories surfaced by our automated scan.
Scanned 2d ago via OSV.dev · mcpg (PyPI)
Adoption & maintenance
Factual signals from GitHub, npm, and our automated checks — not a rating.
How MCPg works
Written by AllMCPs with AI assistance from the project’s README and listing data. How we build listings
Reviews
No reviews yet — be the first to share how it worked for you.
Frequently Asked Questions about MCPg
Related MCP servers
Add a badge to your READMEShow it’s listed — live SVG, Markdown or HTML.
AllMCPs Directory Badge
Showcase your server listing on GitHub or your project documentation. Embed this dynamic SVG badge to highlight official listing status and live engagement.
[](https://allmcps.com/mcp/devopam-mcpg)<a href="https://allmcps.com/mcp/devopam-mcpg"><img src="https://allmcps.com/api/badge/devopam-mcpg?style=directory" alt="MCPg on AllMCPs" /></a>