Claude Code Skills·Claude Skills·The open SKILL.md registry for Claude
ClaudSkills / Engineering / data-engineering

Dbt Strategy

Category: Engineering  ·  Sub-category: data-engineering  ·  Last updated:
Use when creating or modifying dimensional dbt models in warehouse-backed analytics projects. Covers a four-layer warehouse architecture (sources/staging/core/marts), naming conventions, no-alias SQL rule, surrogate-key and missing-record patterns, incremental strategies, deduplication, and common project macros. Use when building fact tables, dimension tables, staging models, writing SQL, or designing tests.

From the source SKILL.md

Patterns for building dbt models in warehouse-backed analytics projects using Kimball-style dimensional modeling.

What this skill does

Dbt Strategy is a community-contributed Claude Code skill in the data-engineering sub-category. It ships as a SKILL.md file that Claude Code auto-discovers under ~/.claude/skills/dbt-strategy/ and loads when your prompt matches the skill's trigger.

When to invoke it: Use when creating or modifying dimensional dbt models in warehouse-backed analytics projects. Covers a four-layer warehouse architecture (sources/staging/core/marts), naming conventions, no-alias SQL rule, surrogate-key and missing-record patterns, incremental strategies, deduplication, and common project macros.

Who uses this skill

The Dbt Strategy Claude Code skill is built for software engineers, backend developers, full-stack teams, and technical leads building and maintaining production systems. It's part of ClaudSkills (also referred to as Claude Skills or Claude Code Skills) — the open community-curated registry of 69,000+ SKILL.md files for Anthropic's Claude Code agent and the wider Claude ecosystem (Claude API, Claude Agent SDK).

How to install

Free

Manual install (2 steps)

mkdir -p ~/.claude/skills/dbt-strategy
curl -L https://claudskills.com/skills/dbt-strategy/SKILL.md \
  -o ~/.claude/skills/dbt-strategy/SKILL.md

Or just download SKILL.md directly and drop it into ~/.claude/skills/dbt-strategy/. Claude Code auto-discovers it on next session.

Skills live at ~/.claude/skills/dbt-strategy/SKILL.md on macOS/Linux, or %USERPROFILE%\.claude\skills\dbt-strategy\SKILL.md on Windows. See the full install guide for step-by-step instructions.

Pro

One-click install via the desktop app

The ClaudSkills desktop app installs any skill directly into ~/.claude/skills/ with one click — no terminal required. Pro starts at $9/mo or $149 lifetime.

Pro

For the full experience including quality scoring and one-click install features for each skill — upgrade to Pro.

See pricing → Download desktop app

Attribution & license

More Engineering skills

Browse all Engineering skills in the ClaudSkills registry, or explore these other picks from the same category:

Browse all Engineering skills → Top 100 skills
Part of ClaudSkills — the open registry for Claude Skills & Claude Code Skills.  ·  What's New  ·  Install guide  ·  About  ·  llms.txt

Part of Acreator Store — Adam Lankamer's AI tools: PerfectStudio · Ucaption · UTagger · AutoXPoster · TestYourSkills · AutomationFlows · Au Naturel

Categories

Use cases

Popular tags

Learn

Site