Browse skills

Analyze SQL queries and EXPLAIN plans to identify performance bottlenecks, then produce optimized rewrites with index recommendations. Supports PostgreSQL, MySQL, SQLite, and SQL Server dialects. Covers full table scans, N+1 patterns, missing indexes, subquery flattening, join optimization, and query plan interpretation. Returns optimized query, index DDL, and estimated improvement.

Inspect a SQL statement before it runs. Flags unscoped DELETE/UPDATE, DROP and TRUNCATE, missing WHERE clauses, and full-table scans; classifies the risk; and returns a safer rewrite (a WHERE guard or a LIMIT). Stops an agent from nuking a table by accident.