postgres-mcp
275
Postgres MCP Pro is an open-source MCP server that enhances AI agents' ability to manage PostgreSQL databases. It offers advanced index tuning and query optimization, ensuring efficient database performance. Key features include safe SQL execution, schema intelligence, and support for various communication transports.
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