Overview
What it is
A Claude Skill that explains a SQL query in plain English, calls out likely bugs (joins, nulls, dedup), and suggests perf improvements. Great for cross-team SQL literacy.
When to use it
Before merging dashboards, when reviewing someone else's query, or when learning SQL.
Who it’s for
Data Science, plus PMs and ops folks writing their own queries.
Expected output
A 3-part response: explanation, correctness issues, performance suggestions.
Setup instructions
- Open Claude → Skills → New.
- Paste sql-reviewer.md.
- Attach the warehouse schema reference.
Usage
Good inputs
- • The query
- • What it's supposed to answer
- • Schema or table descriptions if non-obvious
Example prompts
- Review this query that calculates 28-day active members and explain it line by line.
Expected outputs
- • Plain-English walk-through plus a bug/perf checklist.
Tips & limitations
- • Always verify the explanation against EXPLAIN output before trusting it.
- • Pair with a real reviewer for production queries.
Tags
#data
#sql
#review