Works with the AI Agents you already use

    Claude CodeClaude CodeCursorCursorCodex CLICodex CLIDeepSeekDeepSeekMuseMuse+22 more

    dbt Unit Test Designer

    1

    Design dbt model unit tests with minimal input fixtures, explicit expected rows, and adapter-aware edge cases.

    $5

    Secure checkout via Stripe

    Money-back guarantee

    Converts to your local currency at checkout

    Security scanned
    dbt Unit Test Designer

    dbt Unit Test Designer

    Example session with this skill installed

    Design test cases for a dbt model that sets is_priority to true when amount >= 100. NULL amounts should return false. Only propose fixtures.

    • Read your context and instructions
    • Compiled the dbt unit test

    Prepared editorial example; not a captured live test.

    Use amount inputs 99, 100, 101, and NULL, with expected is_priority values false,
    true, true, and false. The 100 row checks the inclusive boundary; NULL checks the
    specified fallback. Bind these rows to the model's actual upstream input once its
    ref/source name is supplied. No invented relation name or test-run result is provided.

    Connects securely to your tools. The creator never sees your data.

    About this skill

    Design dbt model unit tests with minimal input fixtures, explicit expected rows, and adapter-aware edge cases. This independent English adaptation provides a focused agent workflow, explicit evidence limits, and a prepared example. Fixture design and YAML authoring; actual execution needs a compatible dbt version, adapter, target, and upstream relation setup.

    Find more skills like this on the Claude Skills Marketplace, the Codex Skills Marketplace and the Gemini Skills Marketplace, or browse Claude Skills for Data & Databases.

    Requires dbt v1.8+ for native unit testing. Does not provide warehouse credentials. Scope is limited to columns and logic defined in provided model/source files.

    How to use

    1. 1

      Connect your agent to the Agensi MCP

      Copy the prompt and paste it into Claude, ChatGPT, Cursor or any agent that supports MCP. It sets up the connection for you. Manual setup

    2. 2

      Sign in to Agensi

      Your agent shows a sign-in link. Sign in and click Allow.

    3. 3

      Ask for what you need

      Your agent loads this skill and uses it on your task. It always asks before buying a skill.

    Reviews

    No reviews yet

    Be one of the first to try it. Every listed skill goes through the trust checks below.

    Security scanned

    Checked by our 8-point scan before listing

    Fresh listing

    Recently published to Agensi

    Money-back guarantee

    Doesn't do what its page promises? You get your money back.

    Trust & safety

    Security scan

    Security scan passed 22 days ago

    Software
    dbtdbt project adapter

    Needed for actual test runs; your dbt version must support unit tests.

    Permissions

    Read Files
    Write Files
    Terminal / Shell

    File Scopes

    User-selected
    dbt
    models
    and
    test
    fixtures/**

    Supplied-text or offline review modes need no live account. File changes, commands, and external connections are limited to the separately requested mode and user-selected scope.

    Listed22 days ago

    What's inside

    Frequently Asked Questions

    This skill analyzes your dbt SQL logic to identify high-risk edge cases—like NULL values or join fan-outs—and automatically generates the YAML fixtures needed for dbt's native unit testing framework. This eliminates the manual effort of hand-writing mock data and ensures your tests catch more than just basic 'happy path' scenarios.

    The skill is designed for use with dbt Core or dbt Cloud version 1.8 and above, which introduced native unit testing support. It supports all major adapters including Snowflake, BigQuery, Databricks, and Postgres, and can be used within any AI agent platform that supports dbt project file analysis.

    To get started, simply provide the SQL file of the dbt model you want to test along with its upstream schema definitions. The skill will then prompt you for specific logic you wish to isolate, such as incremental filters or complex window functions, before generating the ready-to-use YAML.

    Yes, the skill is 'adapter-aware' and can specifically mock scenarios for `is_incremental()` and other introspective macros. It generates separate test cases to verify how your model behaves during both full-refresh and incremental runs.

    You receive the full skill configuration, including the logic for edge-case detection and fixture generation, along with documentation on how to integrate it into your workflow. Buyers also receive lifetime access to any updates or improvements made to the logic as dbt evolves.

    New in Data & Databases