dbt

name	dbt
description	Skills for analytics engineering with dbt - building models, writing tests, querying the semantic layer, troubleshooting jobs, and more. Use when doing any dbt analytics engineering work.
license	Apache-2.0
metadata	{"category":"development","author":"dbt-labs","source":{"repository":"https://github.com/dbt-labs/dbt-agent-skills","path":"skills/dbt","commit":"f30da77590f0ec1a4c78ff03599c3c715077f1c1"}}

dbt Analytics Engineering Skills

A comprehensive collection of skills for analytics engineering with dbt. Covers building models, writing tests, querying the semantic layer, troubleshooting jobs, and more.

Included Skills

using-dbt-for-analytics-engineering

Builds and modifies dbt models, writes SQL transformations using ref() and source(), creates tests, and validates results with dbt show. Use when doing any dbt work - building or modifying models, debugging errors, exploring unfamiliar data sources, writing tests, or evaluating impact of changes.

adding-dbt-unit-test

Creates unit test YAML definitions that mock upstream model inputs and validate expected outputs. Use when adding unit tests for a dbt model or practicing test-driven development (TDD) in dbt.

building-dbt-semantic-layer

Use when creating or modifying dbt Semantic Layer components - semantic models, metrics, dimensions, entities, measures, or time spines. Covers MetricFlow configuration, metric types (simple, derived, cumulative, ratio, conversion), and validation for both latest and legacy YAML specs.

answering-natural-language-questions-with-dbt