Dbt Model Generator - Auto-activating skill for Data Pipelines. Triggers on: dbt model generator, dbt model generator Part of the Data Pipelines skill category.
36
Quality
3%
Does it follow best practices?
Impact
97%
0.98xAverage score across 3 eval scenarios
Passed
No known issues
Optimize this skill with Tessl
npx tessl skill review --optimize ./planned-skills/generated/11-data-pipelines/dbt-model-generator/SKILL.mddbt staging model with source definition and tests
Source definition file
100%
100%
source() function used
100%
100%
Staging naming convention
100%
100%
Column renaming
100%
100%
Type casting
100%
100%
Schema YAML with tests
100%
100%
Primary key tested
100%
100%
Model materialization
100%
100%
Model documentation
100%
100%
dbt_project.yml present
100%
100%
Production-ready SQL
100%
100%
Without context: $0.3338 · 1m 20s · 22 turns · 25 in / 4,293 out tokens
With context: $0.4579 · 1m 33s · 28 turns · 187 in / 5,134 out tokens
Incremental materialization and ETL pipeline pattern
Incremental materialization
100%
100%
unique_key defined
100%
100%
is_incremental() macro used
100%
100%
Timestamp-based incremental filter
100%
100%
ref() for staging dependency
100%
100%
Correct aggregation grain
100%
100%
Source definition present
100%
100%
Schema YAML with tests
100%
100%
Unique/not_null on grain key
100%
50%
Production-ready SQL
100%
100%
full-refresh documented
100%
100%
Without context: $0.5150 · 2m 14s · 28 turns · 28 in / 8,023 out tokens
With context: $0.6782 · 2m 44s · 34 turns · 66 in / 9,778 out tokens
Multi-layer dbt project with documentation and inter-model dependencies
Three staging models
100%
100%
Staging naming convention
100%
100%
Source definitions
100%
100%
source() in staging
100%
100%
Intermediate or mart model with ref()
100%
100%
Final mart model
100%
100%
Mart naming convention
100%
100%
Schema YAML across layers
100%
100%
Data quality tests present
100%
100%
Primary key tested on mart
50%
37%
Production-ready SQL
100%
100%
Layer structure documented
100%
100%
Without context: $0.5204 · 2m 5s · 27 turns · 28 in / 8,426 out tokens
With context: $0.6707 · 2m 37s · 35 turns · 68 in / 9,952 out tokens
0c08951
Table of Contents
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.