Dbt Coder
Dbt Coder automatically generates SQL code for your dbt models, accelerating development and ensuring consistent transformations.
Install on your platform
We auto-selected Claude Code based on this skill’s supported platforms.
Run in terminal (recommended)
claude mcp add dbt-coder npx -- -y @trustedskills/dbt-coder
Or manually add to ~/.claude/settings.json
{
"mcpServers": {
"dbt-coder": {
"command": "npx",
"args": [
"-y",
"@trustedskills/dbt-coder"
]
}
}
}Requires Claude Code (claude CLI). Run claude --version to verify your install.
About This Skill
What it does
The dbt-coder skill allows AI agents to generate dbt (data build tool) code based on natural language instructions. It can create models, tests, and seeds, streamlining the data transformation process. This skill aims to accelerate development cycles by automating repetitive coding tasks within a dbt project.
When to use it
- Rapid prototyping: Quickly generate initial drafts of dbt models for experimentation and exploration.
- Automating boilerplate code: Generate standard model structures, reducing manual effort for common data transformations.
- Creating tests: Automatically produce SQL-based tests to ensure data quality within your dbt project.
- Seed generation: Create seed files from provided data or descriptions.
Key capabilities
- Generates dbt models (SQL)
- Creates dbt tests (SQL)
- Produces dbt seeds
- Supports natural language instructions for code creation
Example prompts
- "Create a dbt model named 'active_customers' that selects user_id and last_login from the 'users' table."
- "Generate a test to ensure the 'order_total' column in the 'orders' table is always positive."
- “Create a seed file for states with columns state_code, state_name.”
Tips & gotchas
The quality of generated code depends heavily on the clarity and specificity of your prompts. Providing detailed instructions about desired transformations will yield better results.
Tags
TrustedSkills Verification
Unlike other registries that point to live repositories, TrustedSkills pins every skill to a verified commit hash. This protects you from malicious updates — what you install today is exactly what was reviewed and verified.
Security Audits
| Gen Agent Trust Hub | Pass |
| Socket | Pass |
| Snyk | Pass |
🌐 Community
Passed automated security scans.