New: 98,000+ skills indexed from GitHub repos with 100+ stars · every skill safety-checkedBrowse top skillsTop skills
Esc to closeBrowse all skills
Submit a skillBrowse skills
Submit a skillBrowse skills

Agent skill

Dbt Transformation Patterns

by wshobson in wshobson/agents

Master dbt (data build tool) for analytics engineering with model organization, testing, documentation, and incremental strategies.

MITAuto-check passedData & Analytics

Install Dbt Transformation Patterns

skills CLI
$ npx skills add wshobson/agents --skill dbt-transformation-patterns -a claude-code

Project install by default; add -g for ~/.claude/skills/.

GitHub CLI
$ gh skill install wshobson/agents dbt-transformation-patterns --agent claude-code

Project scope by default; add --scope user for a personal install. Needs GitHub CLI 2.90.0 or later (public preview).

Manual copy
$ git clone --depth 1 https://github.com/wshobson/agents.git skills-src && mkdir -p .claude/skills && cp -r skills-src/plugins/data-engineering/skills/dbt-transformation-patterns .claude/skills/dbt-transformation-patterns && rm -rf skills-src

Use ~/.claude/skills/ instead of .claude/skills for a personal install. The folder must contain SKILL.md.

Claude Code skills documentation · loads skills from .claude/skills/

Facts

Skill name
dbt-transformation-patterns
GitHub stars
40k
Used in
9 other repos
Token cost
~781 tokens
SKILL.md length
173 words
Files
2 (incl. references)
Skills in repo
142
Repo updated
First seen
Licence
MIT

At a glance

Master dbt (data build tool) for analytics engineering with model organization, testing, documentation, and incremental strategies.

  • Works in 2 steps: Model Layers (Medallion Architecture) → Naming Conventions
  • Building data transformations
  • SKILL.md covers When to Use This Skill, Core Concepts, Quick Start and Detailed patterns and worked…, plus 1 more section
  • Instructions only: no scripts, shell commands, URLs or credentials in SKILL.md

What it does

Dbt Transformation Patterns is an agent skill from wshobson/agents. Master dbt (data build tool) for analytics engineering with model organization, testing, documentation, and incremental strategies. Use when building data transformations, creating data models, or implementing analytics engineering best practices.

Its SKILL.md is about 780 tokens, which your agent loads only when the skill is triggered. The skill folder holds 2 other files, including reference files (for example `references/details.md`).

It sits in Data & Analytics, covering Data pipelines and ETL and Data cleaning. It works with dbt. The repository describes itself as: Multi-harness agentic plugin marketplace for Claude Code, Codex, Cursor, OpenCode, GitHub Copilot, Google Antigravity, and Pi. The licence is MIT.

When your agent uses it

  • Building data transformations
  • Creating data models
  • Implementing analytics engineering best practices

Example prompts

  • “/dbt-transformation-patterns”

Workflow steps

2 steps, taken from the step headings in SKILL.md.

  1. Model Layers (Medallion Architecture)
  2. Naming Conventions

What it can do on your machine

Read from SKILL.md and the folder at commit 46891e7. It shows what the files ask for, not the result of running them.

  • Tool permissions

    Pre-approves nothing: there is no allowed-tools line, so your agent's usual permission prompts apply.

    From allowed-tools in the SKILL.md frontmatter.

  • Runs code

    No scripts in the folder and no shell commands in SKILL.md (its code samples are yaml).

    From the folder's file list and the shell code blocks in SKILL.md.

  • Network

    No URLs in SKILL.md.

    From URLs in SKILL.md, links to its own repository left out.

  • Credentials

    Names no API keys, tokens, secrets or passwords.

    From names ending in _API_KEY, _TOKEN, _SECRET, _KEY or _PASSWORD in SKILL.md.

Context cost

Dbt Transformation Patterns loads about 781 tokens when it runs, and up to ~3.4k if it reads all its reference files. Until then it costs about 69 tokens; SKILL.md has 173 words of instructions outside code blocks.

Always · name and description, kept in context so the agent knows when to use it
~69
When it runs · the whole SKILL.md, loaded when a task matches
~781
With references · SKILL.md plus every file in references/, read only if the agent opens them
~3.4k

Estimates: characters ÷ 4, the usual rule of thumb; real counts depend on the model's tokenizer. Scripts and assets cost tokens only if the agent reads them.

Safety

Auto-check passed

The automated check found no risky patterns in SKILL.md.

Automated static check — not a guarantee. Review scripts before installing. It scans the text of SKILL.md for risky patterns (piping downloads into a shell, reading credential files, hidden Unicode, destructive commands); files beside SKILL.md are not scanned.

SKILL.md

The full file from wshobson/agents at commit 46891e7, republished under its MIT licence (© wshobson). 173 words, ~781 tokens.

Download SKILL.mdSave it as .claude/skills/dbt-transformation-patterns/SKILL.md (or your agent's skills folder). This skill also uses 1 other file; get the full folder from GitHub.
name
dbt-transformation-patterns
description
Master dbt (data build tool) for analytics engineering with model organization, testing, documentation, and incremental strategies. Use when building data transformations, creating data models, or implementing analytics engineering best practices.

dbt Transformation Patterns

Production-ready patterns for dbt (data build tool) including model organization, testing strategies, documentation, and incremental processing.

When to Use This Skill

  • Building data transformation pipelines with dbt
  • Organizing models into staging, intermediate, and marts layers
  • Implementing data quality tests
  • Creating incremental models for large datasets
  • Documenting data models and lineage
  • Setting up dbt project structure

Core Concepts

1. Model Layers (Medallion Architecture)
sources/          Raw data definitions
    ↓
staging/          1:1 with source, light cleaning
    ↓
intermediate/     Business logic, joins, aggregations
    ↓
marts/            Final analytics tables
2. Naming Conventions
LayerPrefixExample
Stagingstg_stg_stripe__payments
Intermediateint_int_payments_pivoted
Martsdim_, fct_dim_customers, fct_orders

Quick Start

yaml
# dbt_project.yml
name: "analytics"
version: "1.0.0"
profile: "analytics"

model-paths: ["models"]
analysis-paths: ["analyses"]
test-paths: ["tests"]
seed-paths: ["seeds"]
macro-paths: ["macros"]

vars:
  start_date: "2020-01-01"

models:
  analytics:
    staging:
      +materialized: view
      +schema: staging
    intermediate:
      +materialized: ephemeral
    marts:
      +materialized: table
      +schema: analytics
# Project structure
models/
├── staging/
│   ├── stripe/
│   │   ├── _stripe__sources.yml
│   │   ├── _stripe__models.yml
│   │   ├── stg_stripe__customers.sql
│   │   └── stg_stripe__payments.sql
│   └── shopify/
│       ├── _shopify__sources.yml
│       └── stg_shopify__orders.sql
├── intermediate/
│   └── finance/
│       └── int_payments_pivoted.sql
└── marts/
    ├── core/
    │   ├── _core__models.yml
    │   ├── dim_customers.sql
    │   └── fct_orders.sql
    └── finance/
        └── fct_revenue.sql

Detailed patterns and worked examples

Detailed pattern documentation lives in references/details.md. Read that file when the navigation tier above is insufficient.

Best Practices

Do's
  • Use staging layer - Clean data once, use everywhere
  • Test aggressively - Not null, unique, relationships
  • Document everything - Column descriptions, model descriptions
  • Use incremental - For tables > 1M rows
  • Version control - dbt project in Git
Don'ts
  • Don't skip staging - Raw → mart is tech debt
  • Don't hardcode dates - Use {{ var('start_date') }}
  • Don't repeat logic - Extract to macros
  • Don't test in prod - Use dev target
  • Don't ignore freshness - Monitor source data

© wshobson, MIT. Rendered from Markdown: HTML in the file is shown as text, images as links, and headings moved down two levels. Raw file

Files

SKILL.md and 1 other file (references) in plugins/data-engineering/skills/dbt-transformation-patterns of wshobson/agents.

  • SKILL.md
  • references/details.md

Open the folder on GitHubat commit 46891e7

Used in 9 other repositories

We found 27 copies of this SKILL.md (exact, near-identical or edited) in other folders, from 9 other GitHub owners. This page covers the copy in wshobson/agents, which our catalogue first saw on October 7, 2026.

Compare with similar skills

Dbt Transformation Patterns next to the 5 skills that share the most tags, products or categories with it. Stars are the repository's; “used in” counts other GitHub owners with a copy.

Dbt Transformation Patterns compared with similar skills
SkillStarsUsed inTokensAuto-checkLicenceRepo updated
Dbt Transformation Patterns this skillwshobson/agents40k9 repos~781Automated safety check: PassMIT
Authoring Data Quality ChecksPostHog/posthog40k—~2.8kAutomated safety check: PassCustom licence
Data Quality Checksmohitagw15856/pm-claude-skills1.4k—~919Automated safety check: PassMIT
Dbt Model Specmohitagw15856/pm-claude-skills1.4k—~939Automated safety check: PassMIT
Dbt TestingKilo-Org/kilo-marketplace190—~4kAutomated safety check: PassApache-2.0
Dbt Databricks PR Readydatabricks/dbt-databricks380—~2.8kAutomated safety check: PassApache-2.0

Similar skills

  • Authoring Data Quality Checks

    PostHog/posthog

    Official

    Adds and runs data quality checks (dbt-test style assertions) on a project's warehouse tables and saved-query views, and HogQL catalog metrics: not-null, uniqueness, accepted values, referential…

    40k GitHub stars~2.8k tokensUpdated today
    Data & AnalyticsAuto-check passed

  • Data Quality Checks

    mohitagw15856/pm-claude-skills

    Design the data quality checks for a table or pipeline across the standard dimensions.

    1.4k GitHub stars~919 tokensUpdated yesterday
    Data & AnalyticsAuto-check passed

  • Dbt Model Spec

    mohitagw15856/pm-claude-skills

    Spec a dbt model — its grain, sources, transformations, tests, and materialization.

    1.4k GitHub stars~939 tokensUpdated yesterday
    Data & AnalyticsAuto-check passed

  • Dbt Testing

    Kilo-Org/kilo-marketplace

    dbt testing strategies using dbtconstraints for database-level enforcement, generic tests, and singular tests.

    190 GitHub stars~4k tokensUpdated 10 days ago
    Data & AnalyticsAuto-check passed

  • Dbt Databricks PR Ready

    databricks/dbt-databricks

    Official

    A skill your agent uses for an open dbt-databricks pull request, including your own PR or a fork PR, to assess merge readiness and optionally repair selected gaps on the PR head branch.

    380 GitHub stars~2.8k tokensUpdated today
    Data & AnalyticsAuto-check passed

  • Mz Dbt Release

    MaterializeInc/materialize

    Cut a dbt-materialize PyPI release: bump the version in version.py and setup.py, date the Unreleased CHANGELOG entry, and open the release PR with a Ship: <url body.

    6.4k GitHub stars~1.2k tokensUpdated today
    Data & AnalyticsAuto-check passed

More from wshobson/agents

All 142 skills in this repo

  • Billing Automation

    wshobson/agents

    Covers building subscription billing: billing cycles, subscription states, invoice generation, proration, tax handling and dunning for failed payments.

    40k GitHub starsUsed in 14 repos~473 tokens
    Auto-check passed

  • Cloud Cost Optimization

    wshobson/agents

    Cuts cloud spend across AWS, Azure, GCP and OCI with cost tagging, rightsizing, commitment and spot pricing models, and architecture changes.

    40k GitHub starsUsed in 14 repos~1.7k tokens
    Auto-check passed

  • Python Performance Optimization

    wshobson/agents

    Profiles slow Python code with cProfile and memory profilers, then applies targeted fixes for CPU, memory, I/O and query bottlenecks.

    40k GitHub starsUsed in 13 repos~814 tokens
    Auto-check passed

  • Portfolio Risk Metrics

    wshobson/agents

    Covers portfolio risk measurement with VaR, CVaR, Sharpe, Sortino and drawdown, plus guidance on limits, stress tests and tail risk.

    40k GitHub starsUsed in 13 repos~502 tokens
    Auto-check passed

  • Bats Shell Testing Patterns

    wshobson/agents

    Writes unit tests for shell scripts with Bats: error-condition tests, fixtures and mocks, cross-shell checks, parallel runs, helper files and CI integration.

    40k GitHub starsUsed in 12 repos~1.3k tokens
    Auto-check passed

  • DGX Spark Memory and Thermal Ops

    wshobson/agents

    Plans memory headroom, works through out-of-memory failures and watches temperature and power during long ML training jobs on NVIDIA DGX Spark.

    40k GitHub starsUsed in 1 repo~2k tokens
    Auto-check passed

Works with

Categories

Questions about Dbt Transformation Patterns

What does Dbt Transformation Patterns do?

Master dbt (data build tool) for analytics engineering with model organization, testing, documentation, and incremental strategies. Dbt Transformation Patterns is an agent skill from wshobson/agents. Master dbt (data build tool) for analytics engineering with model organization, testing, documentation, and incremental strategies.

When should I use Dbt Transformation Patterns?

Dbt Transformation Patterns fits situations like: building data transformations; creating data models; implementing analytics engineering best practices.

How do I install Dbt Transformation Patterns in Claude Code?

Run `npx skills add wshobson/agents --skill dbt-transformation-patterns -a claude-code`. Or copy the skill folder (plugins/data-engineering/skills/dbt-transformation-patterns in wshobson/agents) into .claude/skills/dbt-transformation-patterns in your project. Claude Code loads it when a task matches its description.

How do I install Dbt Transformation Patterns in Codex?

Run `npx skills add wshobson/agents --skill dbt-transformation-patterns -a codex`. Or copy the skill folder (plugins/data-engineering/skills/dbt-transformation-patterns in wshobson/agents) into .agents/skills/dbt-transformation-patterns in your project. Codex loads it when a task matches its description.

Can I use Dbt Transformation Patterns in Cursor, Gemini CLI or GitHub Copilot?

Cursor, Gemini CLI, GitHub Copilot and OpenCode also load SKILL.md folders. With the skills CLI, run `npx skills add wshobson/agents --skill dbt-transformation-patterns -a cursor` (or -a gemini-cli, github-copilot or opencode for the others). To copy it by hand, put the folder in .cursor/skills/dbt-transformation-patterns, .gemini/skills/dbt-transformation-patterns, .github/skills/dbt-transformation-patterns and .opencode/skills/dbt-transformation-patterns in your project.

What does Dbt Transformation Patterns need to run?

SKILL.md names no scripts, command-line tools or credentials: Dbt Transformation Patterns is instructions for the agent only.

Does Dbt Transformation Patterns access the network?

SKILL.md contains no URLs. Any network use would come from the scripts or tools the agent runs. This is read from the text; nothing was executed.

Is Dbt Transformation Patterns safe to install?

Our automated static check of SKILL.md found no risky patterns, such as piping downloads into a shell, reading credential files or hidden Unicode. It is not a guarantee. Review the folder before installing.

What licence does Dbt Transformation Patterns use?

Dbt Transformation Patterns is published under the MIT licence (the repository's licence). It allows redistribution, so the full SKILL.md is shown on this page.

How many tokens does Dbt Transformation Patterns use?

About 781 tokens (SKILL.md is roughly 3.1k characters). Agents keep only the skill's name and description in context until a task matches; then they load SKILL.md in full. Its references folder adds about 2.6k tokens, read only when the agent opens those files.

What are the alternatives to Dbt Transformation Patterns?

Skills that share tags, products or a category with Dbt Transformation Patterns: Authoring Data Quality Checks (PostHog/posthog, 40k stars), Data Quality Checks (mohitagw15856/pm-claude-skills, 1.4k stars), Dbt Model Spec (mohitagw15856/pm-claude-skills, 1.4k stars) and Dbt Testing (Kilo-Org/kilo-marketplace, 190 stars). The comparison table on this page puts their stars, adoption, token cost, safety result and licence side by side.

Who maintains Dbt Transformation Patterns?

wshobson (a GitHub user) maintains it in wshobson/agents, which has 40,287 GitHub stars. The repository holds 142 skills in this directory. The repository was last updated on October 5, 2026.

Source: wshobson/agents on GitHub. Facts on this page come from the repository at the commit we read; the author's words are quoted as theirs.