home/categories/testing/altimateai-altimate-code-opencode-skills-dbt-unit-tests-skill-md
testingtesting-security

dbt-unit-tests

Generate dbt unit tests automatically for any model. Analyzes SQL logic (CASE/WHEN, JOINs, window functions, NULLs), creates type-correct mock inputs from manifest schema, and assembles complete YAML. Use when a user says "generate tests", "add unit tests", "test this model", or "test coverage" for dbt models.

AltimateAI
maintainer
AltimateAI
Updated 4/10/2026
Stars
519
Forks
43
quick start

Installation and usage

Generate dbt unit tests automatically for any model. Analyzes SQL logic (CASE/WHEN, JOINs, window functions, NULLs), creates type-correct mock inputs from manifest schema, and assembles complete YAML. Use when a user says "generate tests", "add unit tests", "test this model", or "test coverage" for dbt models.

Installation
$ install --globalskills.sh
Usage

Once installed, you can use this skill by running the following command in your terminal:

skills use dbt-unit-tests