Dbt
A comprehensive skill catalog for AI agents
npx -y skills add G1Joshi/Agent-Skills --skill dbtAssembled from the repository path, not quoted from the project. Check it against their README if it does not work.
One thing to look at
- 10 stars10 stars. Stars are a popularity signal and not a quality one, but at this level it is likely that nobody has read this closely except its author, and you would be relying on your own review.
What its author says it does
Copied from the file, not written here
dbt data transformation with SQL. Use for data pipelines.
SKILL.md
1.0 KB, as published. Nobody here has run it
dbt (Data Build Tool)
dbt manages data transformation in the warehouse using SQL. v2.0 introduces the Fusion Engine (Rust) for performance.
When to Use
- Data Modeling: Converting raw tables into "Gold" tables.
- Testing:
not_null,uniquetests defined in YAML. - Documentation: Auto-generating data dictionaries.
Core Concepts
Models (.sql)
Select statements that dbt compiles into CREATE VIEW/TABLE.
Refs ({{ ref('users') }})
Dependency management. dbt builds the DAG automatically.
Semantic Layer
Defining metrics ("Revenue") in code so all BI tools use the same definition.
Best Practices (2025)
Do:
- Use Git: Treat data models like software code.
- Use Incremental Models: Only process new data to save cost.
- Use dbt Mesh: For cross-project dependencies in large orgs.
Don't:
- Don't put logic in BI tools: Put it in dbt.