What it does
An MCP server for PostgreSQL that helps find and fix performance problems. It reads slow queries from pg_stat_statements, runs EXPLAIN plans, and monitors active and long-running transactions. It recommends indexes, tests hypothetical ones with HypoPG, and finds unused and duplicate indexes.
Use cases
- 01Find the slowest queries in a workload
- 02Test an index idea with HypoPG before creating it
- 03Detect unused or duplicate indexes