dbt-model-writer

This Skill automates dbt model creation by generating staging, intermediate, and mart models with built-in config blocks, materializations, ref() and source() references, Jinja templating, and inline documentation—eliminating manual setup and enforcing best practices across your transformation layer.

Yes, this Skill converts raw SQL into dbt-compliant models by adding proper config blocks, CTE structure, source and ref() references, Jinja templating, and documentation scaffolding so your existing queries follow dbt standards without manual refactoring.

This Skill enforces dbt naming conventions and structure: staging models (stg_*.sql) with source() references, intermediate models (int_*.sql) with ref() logic, and mart models (fct_*/dim_*.sql) with complete documentation, config blocks, and materialization strategies for consistent lineage.

This Skill generates schema documentation alongside model creation by scaffolding test definitions and inline documentation blocks, ensuring your dbt project maintains comprehensive, maintainable documentation without manual effort.

Yes, this Skill supports incremental materialization strategies, allowing you to configure incremental logic, unique keys, and merge behavior directly within generated model config blocks for efficient data refresh patterns.

Yes, this Skill handles model editing by updating existing models while preserving structure, adding missing documentation, enforcing ref() and source() best practices, and refining Jinja logic without overwriting custom logic.