dbt

dbt Develop

Build dbt models that fit the project.

Build and edit dbt models that fit your project: right layers, naming, refs, YAML, and validation.

Build dbt models that actually fit your project.

The problem it solves

A generic AI tool can write SQL, but dbt development also requires project architecture: staging/intermediate/marts, refs, sources, materializations, naming conventions, and validation.

What it does

Discovers project structure and existing patterns.
Creates or modifies dbt model SQL.
Wires refs, sources, configs, and YAML when appropriate.
Validates generated work using dbt and Altimate analysis tools.

When to use it

WHEN

creating a new staging, intermediate, mart, or incremental model

WHEN

modifying an existing model

WHEN

scaffolding model YAML or sources

WHEN

reorganizing dbt project structure

How it works

The skill plans the model, discovers dependencies and conventions, writes changes, and validates the result against project expectations.

Tools used

schema_search

Search indexed schemas, tables, and columns by keyword.

dbt_profiles

Resolve dbt profiles and connection context for a project.

altimate_core_validate

Run deterministic SQL or data-engineering validation through Altimate Core.

altimate_core_column_lineage

Compute column-level lineage through Altimate Core.

Related skills

Testing

→dbt Test

Add the right data quality tests to dbt models.

dbt

→dbt Docs

Turn empty dbt docs into useful business context.

dbt

→dbt Troubleshoot

Debug broken dbt builds with project context.

← All skills & tools