| name | data-sql-analysis |
| description | Use when reviewing or creating SQL for analysis, metric definitions, joins, filters, aggregation, and validation queries. |
| metadata | {"version":"0.2","updated":"2026-06-11"} |
SQL Analysis Skill
Use this workflow for SQL review or SQL-based analysis.
Steps
- Identify the business question and expected output grain.
- Review source tables and join keys.
- Check join cardinality and risk of fan-out or dropped rows.
- Check filters, date ranges, timezone assumptions, null handling, and status fields.
- Review grouping, window functions, and aggregation logic.
- Verify numerator, denominator, and metric definitions.
- Add validation queries for row counts, totals, duplicates, and edge cases.
- Explain limitations and ambiguous definitions.
Do not
- Do not execute destructive SQL.
- Do not assume metric definitions that are not stated.
- Do not hide ambiguous filters, time ranges, or denominators.
Output
Return:
- Query purpose and grain
- Logic review
- Metric definition review
- Risk list
- Validation queries
- Recommended changes