dbt-model-writer

What problem does it solve?

This Skill automates the creation and refinement of dbt models, ensuring best practices, consistent structure, and maintainable transformations. It helps analytics engineers quickly generate staging, intermediate, and mart models with proper config blocks, documentation, and references.

Core Features & Use Cases

• Model Creation: Generate new models with proper config blocks, materializations, and documentation.
• Model Types: Staging (stg_.sql), Intermediate (int_.sql), and Mart (fct_/dim_.sql) patterns with ref() and source() usage.
• Incremental & Docs: Supports incremental strategies, tests scaffolding, and schema documentation.

Quick Start

Use this Skill to generate a new dbt model file, for example stg_orders.sql, with a view configuration and a basic ref() to a source table, so you can start building the lineage.