SQL skills for Claude Code, from queries your team verified

One agent file per role, exported to Claude Code, Codex, and Cursor

Each CHION.md is one persona’s worth of verified SQL: finance, ops, growth, etc. Compile up to ~40 personas on the Max plan; together they’re your team’s SQL knowledge base across personas. Same database, scoped knowledge per persona. Each file is a verified SQL agent the persona owns; the library compounds as your team works.

Chion's SQL Skills Generator creates a CHION.md file: your portable Postgres SQL skills library. It auto-generates a SQL Analytics Agent file (the .md suffix follows the CLAUDE.md / AGENTS.md / SKILL.md convention); the four filenames are interchangeable mirrors with byte-identical content. Pick whichever your agent (Claude Code, Codex, Cursor) reads natively.

CHION.md is a SQL Analytics Agent file for your database: a portable, version-controlled instruction file an AI reads before doing any work. The difference vs. hand-written agent files: yours is auto-written from your real analytics conversations, fully editable, and re-exportable on every refresh. Every verified SQL query teaches it; every PII column closes off; every business rule is cited back to the row that proved it.

The export ships as one folder any AI tool can read: CHION.md at the root + a three-tier .claude/skills/ cascade beneath it (workspace catalog → department catalog → role SKILL.md with verified scripts). Sister-paired roles within each department cover complementary axes (recognized vs. forecast, between-warehouse vs. inside-warehouse, acquisition vs. in-product) so cross-axis questions resolve without the agent inventing a join.

One compile per persona. Same input → same agent file. Deterministic, not generated-on-the-fly.

A real Northwind Logistics agent file. Every Layer 2 line cites [src=…] back to the row that proved it. No hallucinated columns.

Key facts. Frontmatter contract: 11 fields. Framework version: 7. Layer 2: 11–13 density-gated slots, every line [src=…]-cited. One Claude Opus compile per persona; deterministic; same input → same output. Fully editable; export as CHION.md / CLAUDE.md / AGENTS.md / SKILL.md.

---
artifact_type: domain_sql_sme_prompt
artifact_version: 2.5.0
framework_version: 7
archetype: logistics_supply_chain
chosen_primitives: [pre_aggregate_grain, snapshot_latest,
                    ratio_reconstruction, period_over_period_lag]
refreshed_at: 2026-04-30T18:22:11Z
---

# Analyst Persona
You are Northwind Logistics' supply-chain analyst. Your day is
shipments, lanes, carriers, and SLA breaches. You reason in
on-time-delivery rates and cost-per-mile. You refuse avg_of_ratios;
you reconstruct ratios from numerator + denominator at lane-grain.

# Curated SQL Rule Pack
### snapshot_latest
  use-when: balance-style metrics (inventory_on_hand)
  sql-shape: SELECT … ORDER BY ts DESC LIMIT 1 per entity
  guards: never SUM across snapshots

### ratio_reconstruction
  use-when: on_time_rate, fill_rate, defect_rate
  guards: SUM(numerator) / NULLIF(SUM(denominator),0)

# Layer 2 — Domain Profile
## 2.1 Questions You Compute
- on_time_rate = SUM(delivered_on_time) / NULLIF(SUM(shipments),0)
  [src=column_profiles:shipments.delivered_on_time, kpi_metrics:otd]
- avg_cost_per_mile = SUM(total_cost) / NULLIF(SUM(miles),0)
  [src=metric_concepts:cpm_lane]

## 2.6 Stop Signals
- never SUM(inventory_on_hand) across days
  [src=donts:snapshot_sum, decision_record:wh_audit_2026q1]
- never AVG(rates) — reconstruct from numerator + denominator
  [src=donts:avg_of_ratios, decision_record:metric_audit_2026q1]

Department is the top-level axis; role is the brain. Each department contains two sister-paired roles: finance (finance-analyst ↔ fp-and-a-analyst), operations (ops-supply-chain ↔ warehouse-operations), growth (growth-marketing ↔ product-analytics). Verified queries land under the role that owns the data shape; cross-axis questions route to both sister roles.

Each role's scripts/ folder mirrors every verified query under that role as a {README.md, query.sql} pair the agent wraps as a CTE rather than rewriting.

chion-skills-workspace/
├── CHION.md                                      ← root agent file (canonical)
├── README.md
├── LICENSE
└── .claude/skills/
    ├── _INDEX.md                                 ← workspace catalog · vocabulary · routing
    │
    ├── finance/                                  ← department · 2 sister-paired roles
    │   ├── _INDEX.md                             ← department catalog · sister-pair logic
    │   ├── finance-analyst/                      ← recognized revenue · ARR/MRR · margin
    │   │   ├── SKILL.md                          ← persona brain · rule pack · scripts index
    │   │   └── scripts/
    │   │       ├── arr-by-segment/{README.md, query.sql}
    │   │       ├── mrr-trend-12mo/{README.md, query.sql}
    │   │       └── …
    │   └── fp-and-a-analyst/                     ← forecast · variance · runway · burn
    │       ├── SKILL.md
    │       └── scripts/…
    │
    ├── operations/                               (between-warehouse + inside-warehouse)
    │   ├── _INDEX.md
    │   ├── ops-supply-chain/{SKILL.md, scripts/}
    │   └── warehouse-operations/{SKILL.md, scripts/}
    │
    └── growth/                                   (acquisition + in-product)
        ├── _INDEX.md
        ├── growth-marketing/{SKILL.md, scripts/}
        └── product-analytics/{SKILL.md, scripts/}

A typical SKILL.md frontmatter: name + description drive native AI-tool skill discovery; trigger-keywords + department/role drive the CHION.md cascade:

---
name: finance-analyst
description: |
  The default analyst role for the finance department.
  Owns recognized-revenue P&L, segment-margin reconstruction,
  ARR/MRR roll-ups, and renewal recognition.
must-read: [_INDEX.md, ../_INDEX.md]
trigger-keywords: [revenue, recognized revenue, ARR, MRR,
                   GAAP, gross margin, segment margin, renewal]
department: finance
role: finance-analyst
archetype: saas_finance
chosen_primitives: [pre_aggregate_grain,
                    period_over_period_lag,
                    ratio_reconstruction]
status: verified
---

Bottom of every SKILL.md carries a deterministic Scripts Index: trigger phrases mapped to verified scripts/ folders. No LLM judgment between trigger match and SQL execution.

Verified queries  →  1 Opus pass per persona  →  6 agent files
                                                 ┌─ finance-analyst, fp-and-a-analyst
                                                 ├─ ops-supply-chain, warehouse-operations
                                                 └─ growth-marketing, product-analytics

Max plan economics. ~20 credits per persona compile · 750 credits/month on Max → up to ~40 per-persona agent files, each carrying 10+ verified queries. One ship covers a full ~40-person data team. Re-compile any persona anytime; supersedes the prior version cleanly.

Indexable, navigable, version-controlled. Diff your agent file across releases the same way you diff code.