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
Multi-Agent Orchestrator
Design and coordinate multiple AI agents to work together on complex tasks with role assignment and communication protocols.
Technical Debt Audit & Refactoring Plan
Analyzes a codebase description or code sample to identify technical debt, prioritize refactoring opportunities, and produce an actionable cleanup plan with effort estimates.
RAG Knowledge Base Query Optimizer
Optimize queries for retrieval-augmented generation systems
Vibe Coding Project Kickstarter
Generate a complete project scaffold using natural language for vibe coding tools