Standardizes dbt project architecture and SQL transformation patterns for scalable analytics engineering.
dbt-coder is a specialized skill designed to streamline data transformation workflows within Claude. It provides standardized patterns for dbt (data build tool) development, covering everything from project structure and staging models to complex incremental strategies and SCD Type 2 snapshots. Whether you are building a new data mart or refactoring legacy SQL, this skill ensures consistency through pre-defined macros, testing frameworks, and best practices for model organization across Staging, Intermediate, and Mart layers.
Key Features
01Standardized dbt_project.yml and source freshness configurations
02Reusable Jinja macro implementations for DRY SQL development
03Multi-layer model organization (Staging, Intermediate, Marts)
04Advanced materialization strategies including Incremental and Snapshots
0518 GitHub stars
06Automated testing patterns for data quality and integrity
Use Cases
01Implementing historical tracking and SCD Type 2 logic using dbt snapshots
02Converting raw SQL queries into modular, tested dbt models across transformation layers
03Initializing a new dbt project with best-practice folder structures and configurations
