SQL Optimizer

SQL Optimizer analyzes your queries and database schema to find performance bottlenecks and suggest improvements. It understands execution plans, index selection, join strategies, and query planner behavior across PostgreSQL, MySQL, and SQLite.

How It Works

1. Query analysis — Parses SQL to identify anti-patterns like SELECT *, implicit type casts, and missing WHERE clauses
2. Execution plan review — Reads EXPLAIN/EXPLAIN ANALYZE output to find sequential scans, hash joins, and sort operations
3. Index recommendation — Suggests indexes based on WHERE, JOIN, ORDER BY, and GROUP BY columns
4. Query rewrite — Transforms slow patterns: N+1 to JOINs, correlated subqueries to CTEs, DISTINCT to EXISTS
5. Benchmark comparison — Provides before/after cost estimates from execution plans

Best For

• Optimizing slow API endpoints caused by inefficient queries
• Database performance audits before scaling infrastructure
• Reviewing ORM-generated queries for hidden performance issues
• Learning SQL optimization patterns through explained rewrites

Database Support

Full support for PostgreSQL (including JSONB, array operations, and partial indexes), MySQL/MariaDB, SQLite, and basic support for SQL Server and Oracle.