{"slug":"crystaldba/postgres-mcp","name":"Postgres MCP Pro","description":"An MCP server for PostgreSQL providing index tuning, explain plans, health checks, and safe SQL execution.","category":"database","tags":[],"official":false,"stars":2813,"transport":"stdio","install":[{"cmd":"pip install postgres-mcp","imports":[]}],"tools":[{"name":"Database Health","description":"Analyze index health, connection utilization, buffer cache, vacuum health, sequence limits, replication lag, and more."},{"name":"Index Tuning","description":"Explore thousands of possible indexes to find the best solution for your workload, using industrial-strength algorithms."},{"name":"Query Plans","description":"Validate and optimize performance by reviewing EXPLAIN plans and simulating the impact of hypothetical indexes."},{"name":"Schema Intelligence","description":"Context-aware SQL generation based on detailed understanding of the database schema."},{"name":"Safe SQL Execution","description":"Configurable access control, including support for read-only mode and safe SQL parsing, making it usable for both development and production."}],"env_vars":["OPENAI_API_KEY"],"auth_type":"none","github":"https://github.com/crystaldba/postgres-mcp","homepage":"","server_url":"","status":"active","source":"mcpservers.org","updated_at":"Thu May 28"}