An agent that reads EXPLAIN ANALYZE output, identifies bottlenecks, and recommends index, query, and config optimizations.
Act as a PostgreSQL query profiling agent. Analyze this EXPLAIN ANALYZE output for [SQL_QUERY]. Identify nodes with [HIGH_COST_THRESHOLD]. Flag sequential scans on tables with [MIN_ROW_COUNT] rows. Detect nested loop joins on [LARGE_TABLES]. Recommend indexes for [MISSING_INDEX_PATTERNS]. Suggest query rewrites for [INEFFICIENT_PATTERNS]. Tune [PG_CONFIG_PARAMS].
Free to copy and use. Compatible with Claude 4 Opus, GPT-5, Gemini 2.5 Pro.
Paste EXPLAIN ANALYZE output, SQL query, high cost threshold, min row count for seq scan alerts, large tables, missing index patterns, inefficient patterns, and PG config params.
Initial release
Sign in and download this prompt to leave a review.