pgtuner_mcp

Overview

pgtuner_mcp is a Python-based MCP server that analyzes PostgreSQL query plans and configuration to suggest performance improvements. It connects to a PostgreSQL database, retrieves slow queries and configuration settings, and returns tuning recommendations.

Best for

Best for
Developers and DBAs who want automated PostgreSQL tuning suggestions via MCP

Use cases

• Identify and optimize slow PostgreSQL queries
• Get configuration tuning suggestions for PostgreSQL
• Automate performance review in CI/CD pipelines

How to use

Install

pip install pgtuner_mcp

Tools exposed

• min_calls
• min_mean_time_ms
• order_by
• DATABASE_URI
• PGTUNER_EXCLUDE_USERIDS
• PGTUNER_STATEMENT_TIMEOUT_MS
• PGTUNER_IDLE_TXN_TIMEOUT_MS
• PGTUNER_LOCK_TIMEOUT_MS
• PGTUNER_CORS_ALLOW_ORIGINS
• PGTUNER_LINT_DISABLED_RULES
• get_slow_queries
• analyze_query
• get_table_stats
• analyze_disk_io_patterns
• get_index_recommendations
• explain_with_indexes
• manage_hypothetical_indexes
• find_unused_indexes
• check_database_health
• get_active_queries

Tested with

Claude Desktop

Notes

pgtuner_mcp is a Python-based MCP server that analyzes PostgreSQL query plans and configuration to suggest performance improvements. It connects to a PostgreSQL database, retrieves slow queries and configuration settings, and returns tuning recommendations.

24 stars on GitHub. Last updated 2026-05-31. Licensed Apache-2.0.

Use cases

• Identify and optimize slow PostgreSQL queries
• Get configuration tuning suggestions for PostgreSQL
• Automate performance review in CI/CD pipelines

Pros

• Directly integrates with PostgreSQL for real-time analysis
• Lightweight Python implementation with MCP protocol
• Open source with active community contributions

Cons

• Limited to PostgreSQL databases only
• Requires database credentials and network access
• Small user base may mean fewer tested scenarios

Indexed from awesome-mcp-servers-punkpeye and enriched against its public facts.