postgres-mcp

postgres-mcp

4.2

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@mcpreview.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