postgres-mcp-pro

Local
15
GitHub Repo

Overview

Provides configurable read/write access and performance analysis for PostgreSQL databases

Transport

sse

Tools

  • list_schemas
  • list_objects,
  • get_object_details
  • execute_sql
  • explain_query
  • get_top_queries
  • analyze_workload_indexes
  • analyze_query_indexes
  • analyze_db_health

Key Capabilities

  • Database schema and object exploration with detailed metadata
  • SQL query execution with EXPLAIN analysis for performance optimization
  • Workload and query performance monitoring with top queries analysis
  • Database health analysis with index recommendations and optimization suggestions

How It Works

The server provides comprehensive PostgreSQL database management and performance analysis through:

  1. Schema exploration with list_schemas, list_objects, and get_object_details tools
  2. SQL execution and query analysis with execute_sql and explain_query
  3. Performance monitoring using get_top_queries and workload analysis tools
  4. Database health checks and index optimization using analyze_db_health and index analysis tools