Conventions and review steps for writing analytics SQL against the warehouse. Use whenever the task involves querying tables, building a report, or aggregating metrics.
Installation
Mit Codex oder Claude installieren Kopieren Sie diesen Prompt, fügen Sie ihn in Codex, Claude oder einen anderen Assistant ein und lassen Sie die Skill-Seite prüfen und installieren.
Conventions and review steps for writing analytics SQL against the warehouse. Use whenever the task involves querying tables, building a report, or aggregating metrics.
license
Apache-2.0
SQL Reporting Skill
Apply this skill before writing or running any analytics SQL so reports stay
consistent and safe.
When to Use This Skill
Use this skill when the task involves:
Querying warehouse tables for a metric, report, or dashboard figure
Aggregating rows (counts, sums, rolling windows)
Cross-referencing two or more tables
Conventions
Always SELECT explicit column names, never SELECT *.
Filter on a partition/date column first to bound the scan.
Alias aggregates with snake_case names (order_count, not count(*)).
Cap exploratory queries with LIMIT unless an aggregate already collapses
the result set.
Prefer COUNT(DISTINCT ...) over a sub-query when de-duplicating.
Review Checklist (run before returning an answer)
No SELECT *.
A date or partition predicate is present.
Every aggregate has an explicit alias.
The query reads only from tables the task actually needs.
Output Format
Return the final SQL in a fenced ```sql block, then one sentence describing
what the query returns.
