SQL prompts
Query writing and optimization.
SQL Query Writer with Explanation
Writes correct SQL from a plain-English question and your schema — states its assumptions, explains the query in plain language, and flags the edge cases in your data.
Slow Query Optimizer
Diagnoses a slow SQL query from its EXPLAIN plan: identifies the actual bottleneck, proposes fixes in order of effort, and predicts the improvement of each.
Zero-Downtime Schema Migration Review
Reviews DDL migrations for the locks and table rewrites that take production down — version-aware for Postgres and MySQL, with a safe step-by-step rewrite for anything risky.
Analytics SQL Correctness Review
Reviews analytical queries for the bugs that produce confidently wrong numbers: join fan-out double counting, NULL traps, timezone truncation, and averaged averages.