{"repo":"isdaniel/pgtuner_mcp","free":true,"listed":false,"github":"https://github.com/isdaniel/pgtuner_mcp","clone":"git clone https://github.com/isdaniel/pgtuner_mcp.git","description":"provides AI-powered PostgreSQL performance tuning capabilities.","language":"Python","stars":26,"topics":["ai","mcp-server","python","python3"],"license":"Apache-2.0","category":"mcp-servers","readme_excerpt":"PostgreSQL Performance Tuning MCP A Model Context Protocol (MCP) server that provides AI-powered PostgreSQL performance tuning capabilities. This server helps identify slow queries, recommend optimal indexes, analyze execution plans, and leverage HypoPG for hypothetical index testing. Features Query Analysis - Retrieve slow queries from pg stat statements with detailed statistics - Analyze query execution plans with EXPLAIN and EXPLAIN ANALYZE - Identify performance bottlenecks with automated plan analysis - Monitor active queries and detect long-running transactions Index Tuning - AI-powered index recommendations based on query workload analysis - Hypothetical index testing with HypoPG extension (no disk usage) - Find unused and duplicate indexes for cleanup - Estimate index sizes before creation - Test query plans with proposed indexes before implementing Database Health - Comprehensive health scoring with multiple checks - Connection utilization monitoring - Cache hit ratio analysis (buffer and index) - Lock contention detection - Vacuum health and transaction ID wraparound monitoring - Replication lag monitoring - Background writer and checkpoint analysis Vacuum Monitoring - Track long-running VACUUM and VACUUM FULL operations in real-time - Monitor autovacuum progress and performance - Identify tables that need vacuuming - View recent vacuum activity history - Analyze autovacuum configuration effectiveness I/O Performance Analysis - Analyze disk read/write patterns acros","default_branch":null,"files":null,"tree":[],"storefront":"/r/isdaniel","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/isdaniel/pgtuner_mcp/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}