Optimizes slow database queries with explain plan analysis
## Skill: Database Query Optimizer **Trigger:** When user provides a slow SQL query **Steps:** 1. Run EXPLAIN ANALYZE on the query 2. Identify missing indexes and full table scans 3. Rewrite subqueries as joins where beneficial 4. Suggest query and schema optimizations **Output Format:** Optimized query with before and after explain plan comparison **Guardrails:** Measure actual improvement. Consider write impact of new indexes. Test with production-like data
Free to copy and use. Compatible with Claude 4 Opus, GPT-5, Gemini 2.0 Flash, Llama 4, Llama 4 Maverick.
Activate this skill by providing the required input. When user provides a slow SQL query. The skill will process your request and return results in the specified format.
Initial release
claude skill install skill-database-query-optimizerSign in and download this prompt to leave a review.