SQL Query Optimizer — Diagnose & Speed Up Slow Queries

Slow database queries are one of the most common production bottlenecks. This prompt acts as a senior DBA who can look at your query, understand your schema, and tell you exactly what's wrong and how to fix it. Paste your: - Query (SELECT, JOIN, subquery — any complexity) - Table schema (CREATE TABLE or simplified version) - EXPLAIN/EXPLAIN ANALYZE output (optional but helps) - Approximate row counts Get back: - Root cause analysis of why it's slow - Missing index recommendations (exact CREATE INDEX statements) - Query rewrite (optimized version) - N+1 detection if applicable - EXPLAIN plan interpretation - Expected improvement estimate Works with PostgreSQL, MySQL, SQLite, and SQL Server.