Adding Dbt Unit Test
Creates unit test YAML definitions that mock upstream model inputs and validate expected outputs. Use when adding unit tests for a dbt…
- Type
- Skill
- Repository
- dbt-labs/dbt-agent-skills
- GitHub stars
- 726
- License
- Apache-2.0
- Repo last updated
- Sep 24, 2026
- Source file
- README.md
What Adding Dbt Unit Test is
Adding Dbt Unit Test is a skill published in the dbt-labs/dbt-agent-skills repository on GitHub, which has about 726 stars. The repository describes itself as: “A curated collection of Agent Skills for working with dbt, to help AI agents understand and execute dbt workflows more effectively.”
A skill is a folder with a SKILL.md file: frontmatter with a name and a description, followed by instructions Claude follows. Claude loads a skill automatically when a task matches its description, and you can also run it directly with a slash and its name.
Skills work in Claude Code and in Claude Cowork, which makes Adding Dbt Unit Test a portable way to give Claude the same method everywhere.
How to install Adding Dbt Unit Test
Claude Code
- Download the adding-dbt-unit-test folder from the repository.
- Save it as ~/.claude/skills/<skill-name>/SKILL.md for all projects, or .claude/skills/<skill-name>/SKILL.md for one project.
- Claude loads it automatically when a task matches; you can also run it with / and its name.
Claude Cowork
- Zip the skill folder so SKILL.md sits at the top level of the folder.
- Open Customize → Skills, click +, then upload the ZIP.
- Start a task that matches the description, or call it by name with /.
New to extending Cowork? Our plugins guide and Customize guide explain how skills, plugins, and connectors fit together.
Inside the source file
An excerpt from README.md, shared under the repository's Apache-2.0 license. Read the full file on GitHub.
A curated collection of Agent Skills for working with dbt. These skills help AI agents understand and execute dbt workflows more effectively.
What are Agent Skills?
Agent Skills are folders of instructions, scripts, and resources that agents can discover and use to do things more accurately and efficiently.
How They Work
These skills are not slash commands or user-invoked actions. Once installed, the agent automatically loads the relevant skill when your prompt matches its use case. Just describe what you need in natural language and the agent handles the rest. See skill invocation control for more details.
What's Included
- Analytics engineering: Build and modify dbt models, write tests, explore data sources
- Semantic layer: Create metrics, dimensions, and semantic models with MetricFlow
- dbt Mesh: Work with multi-project setups, cross-project refs, model governance (contracts, versions, access)
- Platform operations: Troubleshoot job failures, configure the dbt MCP server
- Migration: Move projects from dbt Core to dbt v2
Installation
Claude Code
Add the dbt skills marketplace and install the plugins:
# Add the marketplace
/plugin marketplace add dbt-labs/dbt-agent-skills
# Install the dbt skills (analytics engineering, semantic layer, testing, etc.)
/plugin install dbt@dbt-agent-marketplace
# Install the migration skills (typically a one-off — not needed for every session)
/plugin install dbt-migration@dbt-agent-marketplaceOther AI Clients
Vercel Skills CLI
Use the Vercel Skills CLI to install skills from this repository. Supports 30+ AI agents including Cursor, Cline, GitHub Copilot, and others.
# Preview available skills
npx skills add dbt-labs/dbt-agent-skills --list
# Install all skills
npx skills add dbt-labs/dbt-agent-skills
# Install only the dbt skills (analytics engineering, semantic layer, etc.)
npx skills add dbt-labs/dbt-agent-skills/skills/dbt
# Install only the migration skills
npx skills add dbt-labs/dbt-agent-skills/skills/dbt-migration
# Install a specific skill
npx skills add dbt-labs/dbt-agent-skills --skill using-dbt-for-analytics-engineering
# Install globally (available in all projects, stored in ~/.<agent>/skills/)
npx skills add dbt-labs/dbt-agent-skills --global
…Tessl
Install skills using Tessl, a package manager for agent skills:
# Install all skills
tessl install dbt-labs/dbt-agent-skills
# Install a specific skill
tessl install dbt-labs/dbt-agent-skills --skill using-dbt-for-analytics-engineering
# Install from GitHub directly
tessl install github:dbt-labs/dbt-agent-skillsBrowse the tile on the Tessl registry.
Compatible Agents
These skills work with AI agents that support the Agent Skills format.
Available Skills
dbt (analytics engineering)
dbt-migration (one-off use)
These skills are typically used once during a migration project rather than in every agent session.
Prerequisites
Most skills assume:
- dbt is installed and configured
- A dbt project with dbt_project.yml exists
- Basic familiarity with dbt concepts (models, tests, sources)
Some skills like fetching-dbt-docs and configuring-dbt-mcp-server can be used without an existing project.
Contributing
We welcome contributions! Whether you want to add a new dbt skill, improve existing ones, or fix issues, please see our Contributing Guide.
Format Specification
All skills in this repository follow the Agent Skills specification to ensure compatibility across different agent products.
Resources
- dbt Documentation
- dbt CLI Reference
- Agent Skills Documentation
- Agent Skills Specification
Community
- Issues: Report problems or suggest new skills
- Discussions: Share use cases and patterns
- Pull Requests: Contribute new skills or improvements
- Star this repository if you find it useful!
License
See LICENSE for details.
Skill Evaluation
See evals/README.md for the A/B testing tool to compare skill variations.
Before you install
- Read the whole file first. Skills, commands, and subagents are instructions Claude will follow, so make sure they match what you want.
- Check which tools, scripts, or MCP servers it uses. Local servers and scripts run with your permissions.
- Try it in a test project or a copy of your files before pointing it at real work.
- Pin the version you tested, and review changes before updating.
- Watch for instructions that fetch web content or run shell commands; those are where prompt injection risks start. See our prompt injection guide.
FAQ
What is Adding Dbt Unit Test?
Adding Dbt Unit Test is a skill for Claude Code and Claude Cowork from the dbt-labs/dbt-agent-skills repository on GitHub. Creates unit test YAML definitions that mock upstream model inputs and validate expected outputs. Use when adding unit tests for a dbt…
How do I install Adding Dbt Unit Test in Claude Code?
Download the adding-dbt-unit-test folder from the repository. Save it as ~/.claude/skills/<skill-name>/SKILL.md for all projects, or .claude/skills/<skill-name>/SKILL.md for one project. Claude loads it automatically when a task matches; you can also run it with / and its name.
Can I use Adding Dbt Unit Test in Claude Cowork?
Zip the skill folder so SKILL.md sits at the top level of the folder. Open Customize → Skills, click +, then upload the ZIP. Start a task that matches the description, or call it by name with /.
Is Adding Dbt Unit Test safe to install?
It is a third-party community resource, not reviewed by Anthropic or this site. Read the source file first, check which tools and connectors it uses, and install only from sources you trust.
Similar resources
- dbt Agent Skills — Frontmatter Rules & Error Table The most actionable take on SKILL.md frontmatter: the exact allowed fields, the lowercase-hyphen name rule, and a validation-error → fix… CLAUDE.md Example · dbt-labs/dbt-agent-skills
- Aeo Optimization AI Engine Optimization - semantic triples, page templates, content clusters for AI citations Skill · alinaqi/maggy
- Agent Md Advisor AGENTS.md / CLAUDE.md 最佳实践顾问。用于用户询问 agents markdown、AGENTS.md、CLAUDE.md、Claude Code memory、AI coding agent… Skill · chujianyun/skills
- Architecture Diagram Creator Creates comprehensive HTML architecture diagrams with SVG visualizations showing business context, data flows, processing pipelines, and… Skill · mhattingpete/claude-skills-marketplace
- Session Handoff Prompt Create a concise continuation prompt that a fresh agent session can paste in to resume a long or degraded session. Use when the user asks… Skill · dongshuyan/compass-skills
- Agent Research Aggregator Pre-pipeline aggregator that scans AI agent cache directories (.claude, .cursor, .antigravity, .openclaw) or any user-specified directory for experimentation logs, extracts insights and numeric results, and formats them as PaperOrchestra-ready inputs (idea.md + experimental_log.md). TRIGGER when the user says "aggregate my agent logs for paper writing", "extract experiments from my coding agent… Skill · Ar9av/PaperOrchestra
- Brainstorming Ideas Into Designs Interactive idea refinement using Socratic method to develop fully-formed designs Skill · obra/superpowers-skills
- Higgsfield Use this skill whenever the user asks anything about Higgsfield AI — writing or refining video/image prompts, choosing a model (Kling… Skill · OSideMedia/higgsfield-ai-prompt-skill