DBT Patterns

Use when designing, reviewing, or operating a dbt project; structure SQL transformations, tests, documentation, lineage, incremental models, and production workflows with explicit data contracts.

9 stars 3 forksDatabases

Install

skills CLI (Claude Code, Cursor, Codex and more)
npx skills add sandbaseai/workbuddy-skill --skill dbt-patterns
Manual install
git clone --depth 1 https://github.com/sandbaseai/workbuddy-skill.git /tmp/workbuddy-skill
mkdir -p ~/.claude/skills
cp -r /tmp/workbuddy-skill/skills/dbt-patterns ~/.claude/skills/dbt-patterns

Personal skills live in ~/.claude/skills. Use .claude/skills in a project folder to share a skill with your team.

From the SKILL.md

# dbt Patterns

Use this skill for SQL-first ELT transformations, analytics models, warehouse data quality, lineage, and dbt delivery. Treat the warehouse as a production system: preserve source semantics, make model contracts observable, and separate evidence from assumptions.

Do not use it to guess warehouse-specific SQL behavior. Confirm the adapter, dbt version, materialization semantics, timezone rules, and available privileges before proposing executable code. Do not run a production build, full-refresh, seed replacement, snapshot operation, or destructive cleanup without explicit authorization.

## Establish the project contract

Before changing a model, record:

- dbt Core/platform version, adapter, target warehouse, schemas, environments, and deployment owner;
- source tables, freshness expectations, grain, primary keys, event-time semantics, nullability, and sensitive columns;
- downstream dashboards, exports, reverse ETL, ML features, contracts, and consumers of the model;
- acceptable freshness, latency, cost, backfill window, and failure/rollback behavior;
- whether the change is additive, a semantic correction, a grain change, or a breaking contract change.

Inspect representative, redacted samples. Check duplicates, late arrivals, deletes, nulls, timezone boundaries, schema drift, maximum values, and historical anomalies. Never place production credentials or raw sensitive rows in models, logs, fixtures, or documentation.

## Layer models by responsibility
Read the full skill on GitHub

Details

Skill name
dbt-patterns
Path
skills/dbt-patterns/SKILL.md
License
MIT
Repo updated
8 September 2026

FAQ

What does the DBT Patterns skill do?

Use when designing, reviewing, or operating a dbt project; structure SQL transformations, tests, documentation, lineage, incremental models, and production workflows with explicit data contracts.

How do I install the DBT Patterns skill?

skills CLI (Claude Code, Cursor, Codex and more): npx skills add sandbaseai/workbuddy-skill --skill dbt-patterns. Skills go in ~/.claude/skills (personal) or .claude/skills (project), and Claude loads them automatically when a task matches the description.

Is DBT Patterns popular?

It lives in sandbaseai/workbuddy-skill, which has 9 GitHub stars and 3 forks.

Related skills

Browse the most popular Claude skills, all databases skills, or write your own with the skills generator.