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
Parallel Agent Task Decomposer
Breaks a complex software project or task into parallelisable sub-tasks suitable for running multiple AI coding agents simultaneously in isolated git branches.
System Design Evaluator
Evaluate and improve system architecture designs
API Design Reviewer
Review and improve REST API designs with best practices
On-Device AI App Feature Planner
Plans a mobile app feature set that runs entirely on-device using small AI models like Gemma 4 or Llama, with offline-first architecture and privacy-by-design principles.