- Home
- Skills
- Data & Databases
- dbt Unit Test Designer
Works with the AI Agents you already use
dbt Unit Test Designer
Design dbt model unit tests with minimal input fixtures, explicit expected rows, and adapter-aware edge cases.
$5
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
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
Sign in to Agensi
Your agent shows a sign-in link. Sign in and click Allow.
- 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
File Scopes
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.