SQL Query Performance Optimizer
Analyze and optimize SQL queries for better performance with index suggestions and query restructuring.
Content
Analyze and optimize the following SQL query: Database: {{database_type}} Query: {{sql_query}} Current Performance Issues: {{issues}} Provide: 1. **Performance Analysis**: Explain what the query does and potential bottlenecks 2. **Optimization Recommendations**: Specific changes to improve performance 3. **Index Suggestions**: New indexes that would help 4. **Rewritten Query**: An optimized version of the query 5. **Execution Plan Explanation**: What the query plan shows 6. **Alternatives**: Different approaches if applicable Focus on practical improvements that will have measurable impact.
Related Prompts
Code Migration Plan Generator
Creates a comprehensive migration plan for moving from legacy codebases to modern frameworks, including risk assessment and rollback strategies.
Technical Documentation Writer
Transform code or APIs into clear, developer-friendly documentation
Agentic Code Architect
Generate autonomous agent code with self-correction, planning, and execution capabilities
Senior-Level AI Code Review & Refactor Guide
Performs a thorough senior-engineer-level code review with prioritized refactoring recommendations, security checks, and performance improvements.