Data & analytics
data-sql-analysis
Use when reviewing or creating SQL for analysis, metric definitions, joins, filters, aggregation, and validation queries.
BlueSkyXN · Static checks on file
Installation
Read the source and dependencies before running a command. Copying does not install or execute anything.
npx skills add BlueSkyXN/Codex-is-all-you-need --skill data-sql-analysisAbout this skill
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