{"slug":"postgres-mcp-pro","kind":"mcp","name":"Postgres MCP Pro","summary":"Community Postgres server with restricted and unrestricted modes, query plan tools, and index and health analysis.","owner":"crystaldba","repoUrl":"https://github.com/crystaldba/postgres-mcp","license":"MIT","licenseTier":"permissive","trust":"community","stars":0,"logoUrl":"https://github.com/crystaldba.png?size=96","linkOnly":false,"categories":["databases"],"tags":["postgres","sql","indexes","query-tuning","readonly"],"runtime":"python","local":true,"cloudCapable":true,"cloudCapability":"yes","cloudReadyOnPlatform":false,"needsApiKey":true,"reviewed":false,"syncedAt":"2026-10-13T00:00:00.000Z","sample":false,"url":"https://conduits.dev/tools/postgres-mcp-pro","language":"Python","transports":["stdio","sse"],"install":{"pypi":"postgres-mcp"},"requirements":{"env":[{"name":"DATABASE_URI","secret":true,"required":true,"description":"Postgres connection string"}],"system":["uv (for uvx)"],"service":"PostgreSQL","upstreamMayCharge":false},"tools":[{"name":"list_schemas","description":"List schemas"},{"name":"list_objects","description":"List tables and other objects"},{"name":"execute_sql","description":"Run SQL (restricted mode is read-only)"},{"name":"explain_query","description":"Show a query plan"},{"name":"get_top_queries","description":"Show slow queries"},{"name":"analyze_db_health","description":"Check database health"}],"readme":"# Postgres MCP Pro\n\nCommunity Postgres server with restricted and unrestricted modes, query plan tools, and index and health analysis.\n\n## Install\n\n```bash\nuvx postgres-mcp\n```\n\n## Configuration\n\n| Variable | Required | Description |\n| --- | --- | --- |\n| `DATABASE_URI` | Yes | Postgres connection string |\n\n## Tools\n\n- `list_schemas` — List schemas\n- `list_objects` — List tables and other objects\n- `execute_sql` — Run SQL (restricted mode is read-only)\n- `explain_query` — Show a query plan\n- `get_top_queries` — Show slow queries\n- `analyze_db_health` — Check database health\n\n## About this listing\n\nDetails were gathered from the project's public pages on 2026-10-13 and have not been reviewed by a person yet. Read the project's own documentation before giving it access to anything sensitive.\n\nSources:\n\n- <https://github.com/crystaldba/postgres-mcp>"}