Query catalog
The index of every named query under sql/. If you add a .sql file there, add a row here in the same PR.
For column-level table reference, see schema/. For the entity-level mental model, see data-model.md.
Analytics
Recurring reporting queries — KPIs, exports, dashboard sources.
| File | Purpose | Owner | Used by | Cost |
|---|---|---|---|---|
| none yet |
Ops
One-off operational queries — debugging incidents, auditing data, manual fixes.
| File | Purpose | Owner | Used by | Cost |
|---|---|---|---|---|
| none yet |
How to add a query
- Drop the file into
sql/analytics/orsql/ops/(kebab-case filename, verb first). - Include the header block — see
sql/README.md. - Add a row to this catalog with a one-line purpose.
- Commit both in the same PR.
Template row
| [`name-of-query.sql`](../sql/analytics/name-of-query.sql) | What it answers in one line | @petter | Weekly dashboard | cheap |