SQL Query Writer
Correct SQL against real schemas, including the hard parts.
Test report
- Verdict
- Tested · Works
- Score
- Tested
- Jun 23, 2026
- Environment
- Claude Code 2.x + Postgres 16
Wrote window-function and CTE-heavy queries against a 12-table schema; results verified row-by-row against hand-written equivalents.
Scored on four weighted criteria — install, triggering, output vs. baseline, docs. How scoring works
- Installs cleanly 5/5
- Triggers reliably 5/5
- Output vs. baseline 9/10
- Docs & honesty 4/5
What it does
Schema-aware SQL generation that handles window functions, CTEs and gnarly joins. We verify output correctness, not just "it runs" — this one earned its pass.
Before / after — same task, with and without the skill
Without the skill
SELECT * FROM orders WHERE status = 'paid' — then an afternoon of hand-aggregating cohorts in a spreadsheet.
With SQL Query Writer
One window-function query with cohort buckets and correct timezone handling — verified row-by-row against a hand-built answer.
Install
Copy the skill folder into ~/.claude/skills/ and share your schema (or let Claude introspect it).
Skills live in ~/.claude/skills/ (global) or .claude/skills/
(per-project). Restart Claude Code after installing.
Appears in