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.
Install
npx skills add sandbaseai/workbuddy-skill --skill dbt-patternsgit 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-patternsPersonal 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
Details
- Skill name
dbt-patterns- Repository
- sandbaseai/workbuddy-skill
- 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
Access Control Security Best Practices
9sandbaseai/workbuddy-skill
Design, review, implement, and verify least-privilege access controls across users, services, tenants, resources, and administrative workflows.
Accessibility Review
9sandbaseai/workbuddy-skill
Use when reviewing a web interface or interaction for semantic, keyboard, focus, screen-reader, ARIA, and contrast accessibility risks.
Acquire Codebase Knowledge
9sandbaseai/workbuddy-skill
Use when the user asks to map, document, or onboard into an existing codebase and needs evidence-backed architecture, structure, conventions, integrations, testing, and concerns documentation.
DBT Transformation Patterns
9sandbaseai/workbuddy-skill
Use when organizing dbt analytics projects, designing source/staging/intermediate/mart models, adding tests and documentation, building incremental models, or reviewing lineage and transformation risk.
Database Query Optimizer
9sandbaseai/workbuddy-skill
Use when investigating slow SQL, execution plans, missing or redundant indexes, lock contention, deadlocks, or database scaling bottlenecks in PostgreSQL or MySQL.
Farm Stack
5Sagargupta16/claude-skills
Use when building or scaffolding FastAPI + React + MongoDB (FARM stack) applications. Covers project structure, async MongoDB with Motor, Pydantic v2 models, config patterns, Docker setup, and testing conventions.
Browse the most popular Claude skills, all databases skills, or write your own with the skills generator.