Blog Docs Log inGet started

PluginPublic

dbt-labs/dbt-agent-skills

A curated collection of Agent Skills for working with dbt, to help AI agents understand and execute dbt workflows more effectively.

70

Quality

88%

Does it follow best practices?

Run evals on this skill

Adds up to 20 points to the overall score

Securityby

Low

Low-risk findings worth noting

Unit testing versioned SQL models

If your model has multiple versions, the default unit test will run on all versions of your model. To specify version(s) of your model to unit test, use include or exclude for the desired versions in your model versions config:

models/schema.yml

# my test_is_valid_email_address unit test will run on all versions of my_model
unit_tests:
  - name: test_is_valid_email_address
    model: my_model
    ...
            
# my test_is_valid_email_address unit test will run on ONLY version 2 of my_model
unit_tests:
  - name: test_is_valid_email_address 
    model: my_model 
    versions:
      include: 
        - 2
    ...
            
# my test_is_valid_email_address unit test will run on all versions EXCEPT 1 of my_model
unit_tests:
  - name: test_is_valid_email_address
    model: my_model 
    versions:
      exclude: 
        - 1
    ...

.changes

.claude

.claude-plugin

.cursor-plugin

.github

scripts

skills

dbt

.claude-plugin

.cursor-plugin

skills

adding-dbt-unit-test

references

special-cases-ephemeral-dependency.md

special-cases-incremental-model.md

special-cases-special-case-overrides.md

special-cases-versioned-model.md

warehouse-bigquery-caveats.md

warehouse-bigquery-data-types.md

warehouse-postgres-data-types.md

warehouse-redshift-caveats.md

warehouse-redshift-data-types.md

warehouse-snowflake-data-types.md

warehouse-spark-data-types.md

answering-natural-language-questions-with-dbt

building-dbt-semantic-layer

configuring-dbt-mcp-server

fetching-dbt-docs

maintaining-dbt-documentation

querying-the-dbt-information-schema

running-dbt-commands

troubleshooting-dbt-job-errors

using-dbt-for-analytics-engineering

using-dbt-state

working-with-dbt-mesh

dbt-extras

dbt-migration

tests

CONTRIBUTING.md