Ready to supercharge your AI agents?

Install any skill in seconds. Free to start, no credit card required.

dbt Transformation Patterns · dokhacgiakhoa | DecimalAI

databy dokhacgiakhoa

dbt Transformation Patterns

dokhacgiakhoa/dbt-transformation-patterns

Source dokhacgiakhoa/agent-skills-4-vibe-coding-cli ↗License NOASSERTION

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

SkillScore96Maintained

Automatic

Data Engineer pack

Last verified 8/29/2026

What it changes

Passed 22 of 23 test cases with the skill, and 19 of 23 without it.

Without skill83%

With skill96%

Checks it passed that the model alone missed

The response recommends using dbt seed to load CSV reference data.
The response uses dbt snapshots with timestamp or check strategies.
The response specifies table or incremental materialization for marts models.

3 fixed19 passed either way1 still failing0 broke

Pass-rate lift: +13 pp
Tokens: -7%
Agent turns: 0%
Response time: -22%

Model gemini-3.6-flashMeasured 8/29/2026v122 of 23 cases passed with skill

Tokens, turns and time describe resource use, not a dollar price.

Use this skill

Save it into your project's skills folder. Claude Code picks it up in its next session.

curl -fsSL --create-dirs -o .claude/skills/dokhacgiakhoa-dbt-transformation-patterns/SKILL.md https://app.decimal.ai/s/dokhacgiakhoa-dbt-transformation-patterns/SKILL.md

Want it pinned and updatable? pip install "decimalai>=0.15", then decimalai skills add dokhacgiakhoa-dbt-transformation-patterns, and start Claude Code with claude --plugin-dir "$(git rev-parse --show-toplevel)/.agents"

1 · One-time — install the CLI (docs ↗)

pip install "decimalai>=0.15"

2 · Get the skill — writes .agents/skills/dokhacgiakhoa-dbt-transformation-patterns/ and pins it in .decimal/skills.lock

decimalai skills add dokhacgiakhoa-dbt-transformation-patterns

No CLI? Get the same file — curl · raw file

curl -fsSL --create-dirs -o .claude/skills/dokhacgiakhoa-dbt-transformation-patterns/SKILL.md https://app.decimal.ai/s/dokhacgiakhoa-dbt-transformation-patterns/SKILL.md

Raw file: /s/dokhacgiakhoa-dbt-transformation-patterns/SKILL.md ↗ · machine-readable summary at /s/dokhacgiakhoa-dbt-transformation-patterns.json ↗

Safety checks: 3 of 3 passed

Code scan CleanIntent PassedContent Clean

See it in action

One of 3 test cases the skill fixed. Same model, same prompt, with and without the skill.

1 of 3

Prompt

We need to expose final revenue metrics to Tableau dashboards. Should BI tools query raw staging views directly, or how should business-ready datasets be exposed?

What was checked, without and with the skill
Checked	Without skill	With skill
The response recommends exposing dimensional entities and fact tables in a marts layer.	Passed	Passed
The response specifies table or incremental materialization for marts models.	Missed	Passed

case-04 · gemini-3.6-flash · 8/29/2026 · answers are capped and redacted

What's inside

The instructions your model reads when the skill loads.

SKILL.md34 linessingle file

dbt Transformation Patterns

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

Use this skill when

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

Do not use this skill when

The project is not using dbt or a warehouse-backed workflow
You only need ad-hoc SQL queries
There is no access to source data or schemas

Instructions

Define model layers, naming, and ownership.
Implement tests, documentation, and freshness checks.
Choose materializations and incremental strategies.
Optimize runs with selectors and CI workflows.
If detailed patterns are required, open resources/implementation-playbook.md.

Resources

resources/implementation-playbook.md for detailed dbt patterns and examples.

🧠 Knowledge Modules (Fractal Skills)

1. implementation-playbook

Track record

Benchmark

22 / 23

test cases passed, vs 19 / 23 without

Adoption

Users: 5
Times used: 99

Safety and source details

SkillSafety

✓ 3 of 3 passed

Code scan15 of 15 checks clean

0 critical · 0 warning · 0 info — scanner v4 — 8/10/2026

View 15 scanner checks

live_secretremote_code_executionreverse_shelldata_exfiltrationssrf_metadataagent_snoopinganti_refusaldestructive_commandsobfuscated_unicodeunicode_homoglyphopaque_blobsuspicious_urltool_overreachtrigger_abuseprompt_injection_phrasing

IntentSafe

LLM judge · does the skill do what it claims

ContentClean

LLM judge · policy & harmful-content review

Source

Imported

dokhacgiakhoa / agent-skills-4-vibe-coding-cli

.agent/skills/dbt-transformation-patterns/SKILL.md

View on GitHub ↗

License NOASSERTIONImported 8/10/2026Version v1

Other skills for the same job

Published skills whose descriptions closely match this one, with their headline benchmark lift.

More skills from the same source and nearby in the registry, with their headline benchmark lift.

Ready to supercharge your AI agents?

See it in action

What's inside

dbt Transformation Patterns

Use this skill when

Do not use this skill when

Instructions

Resources

🧠 Knowledge Modules (Fractal Skills)

1. implementation-playbook

Track record

Benchmark

Adoption

SkillSafety

Source

Other skills for the same job

Related skills