postgres-mcp
If you are the rightful owner of postgres-mcp and would like to certify it and/or have it hosted online, please leave a comment on the right or send an email to henry@mcphub.com.
Postgres MCP Pro is an open-source Model Context Protocol server designed to enhance database performance and management through advanced tools and features.
Postgres MCP Pro is an open-source Model Context Protocol (MCP) server that supports AI agents throughout the development process, from coding to production tuning. It offers features like database health analysis, index tuning, query plan validation, schema intelligence, and safe SQL execution. The server supports both stdio and SSE transports, providing flexibility in different environments. It is designed to improve database performance and management by leveraging industrial-strength algorithms and tools.
Features
- 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 a detailed understanding of the database schema.
- Safe SQL Execution: Configurable access control, including support for read-only mode and safe SQL parsing.
Tools
list_schemas
List all database schemas
list_objects
List database objects in the specified schema
get_object_details
Get detailed information about a specific database object
execute_sql
Execute SQL statements
explain_query
Get the execution plan of SQL query
get_top_queries
Report the slowest SQL query
analyze_workload_indexes
Analyze workloads and recommend indexes
analyze_query_indexes
Analyze specific queries and recommend indexes
analyze_db_health
Perform a comprehensive database health check
