Postgres MCP Pro
JSON →An MCP server for PostgreSQL providing index tuning, explain plans, health checks, and safe SQL execution.
Install
pip install postgres-mcp Tools · 5
- Database Health Analyze index health, connection utilization, buffer cache, vacuum health, sequence limits, replication lag, and more.
- Index Tuning Explore thousands of possible indexes to find the best solution for your workload, using industrial-strength algorithms.
- Query Plans Validate and optimize performance by reviewing EXPLAIN plans and simulating the impact of hypothetical indexes.
- Schema Intelligence Context-aware SQL generation based on detailed understanding of the database schema.
- Safe SQL Execution Configurable access control, including support for read-only mode and safe SQL parsing, making it usable for both development and production.
Environment variables
OPENAI_API_KEY
Links
★ 2,813 GitHub stars