# isdaniel/pgtuner_mcp

Source: https://glimind.com/server/awesome%2Fisdaniel%2Fpgtuner_mcp
Registry id: `awesome/isdaniel/pgtuner_mcp`
Status: unknown

## Tools (12)

- `analyze_io_performance`: Analyze disk read/write patterns across tables and indexes
- `analyze_query_plan`: Analyze query execution plans with EXPLAIN ANALYZE
- `estimate_index_size`: Estimate index size before creation
- `find_unused_indexes`: Find unused and duplicate indexes for cleanup
- `get_health_score`: Comprehensive health scoring with multiple checks
- `get_slow_queries`: Retrieve slow queries from pg_stat_statements with detailed statistics
- `get_slow_query_details`: Get detailed statistics for a specific slow query
- `monitor_active_queries`: Monitor active queries and detect long-running transactions
- `recommend_indexes`: AI-powered index recommendations based on query workload analysis
- `review_configuration`: Review PostgreSQL settings by category and get recommendations
- `test_hypothetical_index`: Test query plans with proposed indexes using HypoPG
- `track_vacuum_progress`: Track long-running VACUUM and VACUUM FULL operations

Measured by Glimind (https://glimind.com): MCP handshake + tool list only, no tool is ever called. CC BY 4.0.