Adding Dbt Unit Test

dbt-labs/dbt-agent-skillsOfficial

This handles the YAML scaffolding for dbt unit tests, mocking upstream inputs and defining expected outputs for your models. It's designed for test-driven development workflows where you want to validate SQL logic before materializing anything in production. The skill comes directly from dbt Labs and includes comprehensive reference docs for different warehouse-specific quirks (BigQuery, Snowflake, Redshift, etc.) plus guidance on testing incremental models and ephemeral dependencies. One thing to note: you'll need upstream models to exist in your warehouse before running unit tests standalone, though the docs explain how to use the empty flag to create schema-only versions cheaply. Best suited for testing complex SQL logic like window functions, date math, or gnarly case statements where you want confidence before deploying.

skills.sh installs

1.1K

GitHub stars

759

last updated

Aug 21, 2026

Sponsors

Promote your product hereReach 125k+ visitors monthlyPromote your product hereReach 125k+ visitors monthlyAgent CaffeineSponsoredClose your lid, come back to finished workSnugSponsoredThe clipboard manager for the AI eraPromote your product hereReach 125k+ visitors monthlyWaxSponsoredBlock anything with supervision, without erasing your iPhonePromote your product hereReach 125k+ visitors monthlyknobsSponsoredSee your site on any phone, any day, in any language

Recommended

More Testing & QA

1appbuilder-e2e-testingadobe/skillsUse this skill whenever the user wants browser-based end-to-end tests for an Adobe App Builder application. Covers Playwright E2E testing for ExC Shell SPAs, AE800skills.sh installs

2e2e-testing-automationaj-geddes/useful-ai-promptsBuild end-to-end automated tests that simulate real user interactions across the full application stack. Use for E2E test, Selenium, Cypress, Playwright, browse695skills.sh installs

3vitest-testingexistential-birds/beagleVitest testing framework patterns and best practices. Use when writing unit tests, integration tests, configuring vitest.config, mocking with vi.mock/vi.fn, usi471skills.sh installs

4umbraco-e2e-testingumbraco/umbraco-cms-backoffice-skillsE2E testing for Umbraco backoffice extensions using Playwright and @umbraco-cms/acceptance-test-helpers380skills.sh installs

5unit-test-generatorpatricio0312rev/skillsGenerates comprehensive unit tests with AAA pattern (Arrange-Act-Assert), edge cases, error scenarios, and coverage analysis. Creates test files matching source374skills.sh installs

6cypress-playwright-setuppatricio0312rev/skillsSets up end-to-end testing with Cypress or Playwright including page objects, fixtures, and CI integration. Use when users request "E2E testing", "Cypress setup309skills.sh installs