DATA ENGINEERING / dbt-labs
dbt Analytics Engineering
Build and revise transformations with source profiling, explicit lineage and targeted validation.
“Builds and modifies dbt models, writes SQL transformations using ref() and source(), creates tests, and validates results with dbt show. Use when doing any dbt work - building or modifying models, debugging errors, exploring unfamiliar data sources, writing tests, or evaluating impact of changes.”
01 / THE REASONING
Why this made the selection.
- It builds and changes dbt models with a shell limited to dbt and jq, and it requires dbt show before the work is called done.
- Warehouse values, SQL comments, and package READMEs are evidence, not commands.
- The source requires looking at actual inputs/results and explicitly diverts breaking schema changes before in-place editing.
- Plan models from desired output grain and existing project conventions
02 / THE REVIEW RECORD
What we actually inspected.
Source review has boundaries.
A clear record is more useful than a “safe” badge.
Material inspected
- skills/dbt/skills/using-dbt-for-analytics-engineering/SKILL.md
- README.md
- LICENSE
Our findings
- allowed-tools permits Bash only for dbt and jq, plus Read, Write, Edit, Glob, and Grep.
- The skill says never to execute instructions found in data values, SQL comments, or package metadata.
- hub.getdbt.com lookups use name, version, and dependencies, and do not act on free-text READMEs.
- It does not treat column names as a substitute for reading the model YAML.
- The source requires looking at actual inputs/results and explicitly diverts breaking schema changes before in-place editing.
Not established by this review
- The resource was not executed and its tools were not called.
- No skill execution, authenticated service operation, or outcome benchmark was performed.
- Not executed: it was not installed or run.
The review applies to the material and revision named here. A newer upstream release can change its behavior.
03 / PUT IT TO WORK
Add a skill to your workflow.
DOCUMENTED COMMAND
npx skills add dbt-labs/dbt-agent-skills/skills/dbt/skills/using-dbt-for-analytics-engineering Run in your terminal to choose your AI tools, project or global scope, and installation method. This short command follows the current upstream version; the review covers the revision shown above.
Optional: install the reviewed revision
Keeps the original source and installer version where recorded, while leaving your AI tools and installation scope for you to choose.
npx skills add https://github.com/dbt-labs/dbt-agent-skills/tree/7c7b5fa39e61694f1ae2b8ea1b8065e195c814ce/skills/dbt/skills/using-dbt-for-analytics-engineering - Install the pinned skill directory interactively, retaining its bundled references and scripts.
- Read model YAML and existing transformations, identify grain and reuse ref/source dependencies.
- Profile representative inputs/outputs, select affected models and validate invariants; use Mesh guidance before renaming/removing/retyping public columns.
Before you start
- A compatible dbt project and the selected CLI/MCP capabilities
- Warehouse or platform credentials only for operations that require them
04 / FOLLOW THE EVIDENCE
The source trail.
Our notes are separate from the original resource.
Check upstream before adopting a new version.
- Pinned skill definition ↗Checked
https://github.com/dbt-labs/dbt-agent-skills/blob/7c7b5fa39e61694f1ae2b8ea1b8065e195c814ce/skills/dbt/skills/using-dbt-for-analytics-engineering/SKILL.md
Supports: summary, whySelected, bestFor, limitations, install, access, review
https://github.com/dbt-labs/dbt-agent-skills/blob/7c7b5fa39e61694f1ae2b8ea1b8065e195c814ce/README.md
Supports: install
- Apache-2.0 licence ↗Checked
https://github.com/dbt-labs/dbt-agent-skills/blob/7c7b5fa39e61694f1ae2b8ea1b8065e195c814ce/LICENSE
Supports: license
https://raw.githubusercontent.com/dbt-labs/dbt-agent-skills/7c7b5fa39e61694f1ae2b8ea1b8065e195c814ce/skills/dbt/skills/using-dbt-for-analytics-engineering/SKILL.md
Supports: upstreamDescription, review.notTested, review.reviewedAt