SQL Query Optimizer
Optimize SQL queries for performance and best practices
Content
Optimize the following SQL query: ```sql {{sql_query}} ``` Database: {{database_type}} Table context: {{table_context}} Provide: 1. Optimized query with improvements explained 2. Index recommendations 3. Performance analysis 4. Potential issues with original query 5. Execution plan comparison
Related Prompts
API Endpoint Designer
Design RESTful API endpoints with proper naming, methods, and documentation
Debug Root Cause Analyzer
Systematically diagnose bugs and errors using structured root cause analysis — get a clear explanation, fix options, and prevention strategy from any error message or unexpected behavior.
Red Team Security Tester
Act as a red team attacker to identify vulnerabilities in systems, code, or proposals
Reasoning Model Debug Prompt (Chain-of-Thought Code Fixer)
Uses chain-of-thought reasoning to systematically diagnose and fix code bugs, explaining each step of the reasoning process before proposing a fix.