Data Quality Framework — Portable Skills Bundle

Everything needed to deploy the Scope × Basis testing framework on a client project. Copy these files into any Claude Code project’s .claude/skills/ directory.

What’s in the bundle

1. Testing Matrix Template

Source: ~/rdco-vault/01-projects/data-quality-framework/testing-matrix-template.md

The framework document itself — 3×6 matrix (Column/Row/Aggregate × Absolute/Relative:Source/Relative:Production/Relative:Recon/Temporal/Human), two populated examples (Salesforce closed-won, ARR waterfall), blank template, SQL patterns reference, SoR identification, and severity tiers (Stop/Pause/Go).

2. /audit-model skill

Source: ~/.claude/skills/audit-model/SKILL.md

Interactive skill with two modes:

• Plan — interviews the engineer to build a test matrix for a model. Extracts schema, identifies SoR, walks each matrix cell with targeted questions, generates a filled test plan with severity assignments.
• Audit — reads existing tests, maps them to the matrix, identifies coverage gaps, assigns severity, offers to generate missing tests.

3. /generate-tests skill

Source: ~/.claude/skills/generate-tests/SKILL.md

Takes a filled matrix and outputs:

• dbt test YAML (schema.yml with native + dbt_expectations tests)
• OR Snowflake SQL worksheet
• Coverage report flagging scope gaps

How to deploy on a client project

# From the client project root
mkdir -p .claude/skills/audit-model
mkdir -p .claude/skills/generate-tests

# Copy skills
cp ~/.claude/skills/audit-model/SKILL.md .claude/skills/audit-model/
cp ~/.claude/skills/generate-tests/SKILL.md .claude/skills/generate-tests/

# Copy the framework template to the project docs
cp ~/rdco-vault/01-projects/data-quality-framework/testing-matrix-template.md docs/data-quality-framework.md

Then in the project’s CLAUDE.md, add:

## Data Quality
When writing or reviewing tests, reference the framework at `docs/data-quality-framework.md`.
Use `/audit-model plan` to build test plans for new models.
Use `/audit-model audit` to check coverage gaps on existing models.

Usage on Progress (MG)

For the Progress project specifically:

1. Start with /audit-model audit on the most critical model (probably the opportunity pipeline or ARR waterfall equivalent)
2. The audit will map existing dbt tests to the matrix and show gaps
3. Use /audit-model plan for any new models in the sprint
4. The severity tiers (Stop/Pause/Go) map to dbt test severity: error for Stop, warn for Pause

Differences from cc-wrapped /ac and /review-build