postgres-mcp

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