CtrlK
BlogDocsLog inGet started
Tessl Logo
SkillPublic

dbt-transformation-patterns

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.

65

Quality

82%

Does it follow best practices?

Run evals on this skill

Adds up to 20 points to the overall score

View guide
SecuritybySnyk

Passed

No findings from the security scan

SKILL.md
Quality
Evals
Security

Quality

Content

72%Weight 40%Scale 1-5

Reviews the quality of instructions and guidance provided to agents. Good implementation is clear, handles edge cases, and produces reliable results.

A well-structured, token-efficient overview tier that correctly delegates deep content to a real one-level reference file. Its main gaps are the absence of a validation feedback loop in the build workflow (capped at 3) and no executable model SQL or dbt commands in the top tier.

Suggestions

Sequence a validation loop into the workflow, e.g. 'Build staging → run `dbt test` on staging → fix and re-run before moving to intermediate/marts', so batch materialization has an explicit checkpoint.

Inline one minimal executable example (a small stg_ model SQL plus the `dbt run` / `dbt test` commands) in the Quick Start so the top tier is actionable without opening the reference.

Trim generic bullets Claude already knows ("Version control - dbt project in Git", "Don't test in prod") in favor of dbt-specific guidance like `--select state:modified` or dev-target usage.

DimensionReasoningScore

Conciseness

The body is almost entirely operational (layer diagram, naming table, dbt_project.yml, project tree) with no padding or concept explanations, but a few bullets state things Claude already knows — "Version control - dbt project in Git" and "Don't test in prod - Use dev target" are generic advice that could be trimmed, matching the anchor for efficient-with-minor-over-explanation rather than the every-token-earns-its-place level.

4 / 5

Actionability

The Quick Start provides a concrete, copy-paste dbt_project.yml and an exact directory tree, and the naming table gives real examples like `stg_stripe__payments` and `fct_orders`. It stops short of fully executable coverage: no inline model SQL and no dbt commands (`dbt run`, `dbt test`) appear in SKILL.md itself — those live entirely in references/details.md — so it fits 'mostly executable with minor gaps' rather than the copy-paste-ready-for-common-cases level.

4 / 5

Workflow Clarity

The medallion flow (sources → staging → intermediate → marts) establishes build order, and testing is named as a practice ("Test aggressively - Not null, unique, relationships"), but no validation checkpoint is sequenced into the workflow (e.g. build staging, run `dbt test`, fix, then proceed). Since dbt materialization is a batch/database operation, the missing feedback loop caps this at the 'sequence present but checkpoints missing' level.

3 / 5

Progressive Disclosure

SKILL.md is a clean navigation tier (concepts, naming, quick start, best practices) with a single well-signaled, one-level-deep reference — "Detailed pattern documentation lives in `references/details.md`. Read that file when the navigation tier above is insufficient." The bundle confirms references/details.md exists and contains the actual 447-line pattern content (7 worked patterns plus a commands section) rather than a pointer chain, so it matches the clear-overview/easy-navigation anchor; not below it because nothing that belongs in the overview is buried, and not above because 5 is the maximum.

5 / 5

Total

16

/

20

Passed

Description

83%Weight 40%Scale 1-5

Based on the skill's description, can an agent find and select it at the right time? Clear, specific descriptions lead to better discovery.

A well-formed description that explicitly covers both what the skill does and when to use it, with the key 'dbt' trigger term front and center. The residual weaknesses are trigger-phrase breadth that could pull in generic data-engineering requests and capability areas stated as topics rather than concrete actions.

Suggestions

Make the capabilities action-verb concrete, e.g. "Organize models into staging/intermediate/marts layers, write data-quality tests, and configure incremental materializations".

Narrow the when-clause triggers to dbt-specific phrasing ("Use when writing dbt models, configuring dbt_project.yml, or building an ELT/analytics-engineering layer in dbt") to reduce overlap with generic data-pipeline and SQL skills.

DimensionReasoningScore

Specificity

"model organization, testing, documentation, and incremental strategies" lists several distinct capability areas, going beyond the 1-2 actions of the mid anchor. It falls short of the comprehensive level because the areas are named as topics rather than concrete actions (e.g. it does not say 'organize models into staging/intermediate/marts layers' or 'build incremental models with unique keys').

4 / 5

Completeness

The 'what' is explicit ("Master dbt ... with model organization, testing, documentation, and incremental strategies") and the 'when' is an explicit trigger clause with three concrete conditions ("Use when building data transformations, creating data models, or implementing analytics engineering best practices"), matching the anchor that answers both what and when with concrete trigger phrases. Not below 5 because neither half is vague or merely implied.

5 / 5

Trigger Term Quality

Strong natural terms are present — "dbt", "data build tool", "data transformations", "data models", "analytics engineering" — phrases users would actually say. A few common variations are missing (e.g. "data warehouse", "ELT", "staging/marts", "SQL models"), so it sits at good-but-not-comprehensive coverage rather than the synonym-and-extension-saturated level.

4 / 5

Distinctiveness Conflict Risk

"dbt (data build tool)" carves out a clear niche with dedicated triggers, but the when-clause phrases "building data transformations" and "creating data models" are broad enough to also match generic SQL, data-pipeline, or data-engineering skills, giving minor overlap risk with closely related skills. It is well above the 'somewhat specific but could still overlap' level because the dbt naming anchors it.

4 / 5

Total

17

/

20

Passed

Validation

100%

Checks the skill against the spec for correct structure and formatting. All validation checks must pass before discovery and implementation can be scored.

Validation — 16 / 16 Passed

Validation for skill structure

No warnings or errors.

Repository

wshobson/agents

Path

plugins/data-engineering/skills/dbt-transformation-patterns/SKILL.md

Reviewed

Table of Contents

Is this your skill?

If you maintain this skill, you can claim it as your own. Once claimed, you can manage eval scenarios, bundle related skills, attach documentation or rules, and ensure cross-agent compatibility.