skills.rest
clawdata
clawdataOFFICIAL
Explore all skills by this author →
GitHub

dbt-model-gen

Generate dbt models across bronze, silver, gold, and semantic layers from source definitions.

24|11|Updated Feb 19, 2026
Search Tags:#dbt#templating#data-pipelines#model-generation#schema-management#medallion-architecture
One-click install
npx skills add https://github.com/clawdata/clawdata --skill dbt-model-gen
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: dbt-model-gen
Source: https://github.com/clawdata/clawdata/tree/main/skills/dbt-model-gen
Command: npx skills add https://github.com/clawdata/clawdata --skill dbt-model-gen

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

dbt-model-gen generates dbt models across bronze, silver, gold, and semantic layers from source definitions using project templates.

Core Features & Use Cases

  • Render bronze, silver, gold, and semantic layers from a single source definition.
  • Apply pre-defined templates (bronze_model.sql.j2, silver_scd_type1.sql.j2, etc.) to generate dbt artifacts.
  • Standardize dbt project scaffolding and accelerate data platform delivery with consistent naming and schema.yml generation.

Quick Start

Install dependencies, point to your source.yml in templates/dbt/source.yml.j2, and run the generator to produce the dbt models across layers.

Frequently Asked Questions about dbt-model-gen

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I auto-generate dbt models across medallion architecture layers?▼

Auto-generate dbt models across medallion layers by reading source definitions and rendering jinja templates from templates/dbt/ to produce standardized bronze, silver, gold, and semantic model files plus a schema.yml.

What is the best way to standardize dbt project scaffolding for data pipelines?▼

Standardize dbt project scaffolding by applying pre-defined jinja templates like bronze_model.sql.j2 and silver_scd_type1.sql.j2 to generate consistent naming and repeatable dbt artifacts across data pipeline layers.

Can I generate a schema.yml automatically from dbt source definitions?▼

Yes, you can generate a schema.yml automatically from dbt source definitions by pointing to your source.yml template and running the generator to write model files alongside the schema configuration.

Does dbt model generation work with templating for semantic layer models?▼

Yes, dbt model generation works with jinja templating to render semantic layer models, applying project templates alongside bronze, silver, and gold layers from a single source definition.

How do I set up dbt model generation for a medallion architecture data platform?▼

Set up dbt model generation by installing dependencies, pointing to your source.yml in templates/dbt/source.yml.j2, and running the generator to produce dbt models across all medallion layers for your data platform.

Related Skills

Explore More Data & Analytics Skills→
sfc-gh-dflipposfc-gh-dflippo
34

dbt-modeling

Create dbt models with CTE patterns and ref/source macros.

Community
Basic
sfc-gh-dflipposfc-gh-dflippo
34

dbt-testing

Implement dbt data quality tests with dbt_constraints for database-level constraints.

Community
Intermediate
shaprisshapris

answering-natural-language-questions-with-dbt

Generates and executes SQL to answer natural-language business questions using dbt semantic layer or compiled SQL.

Community
Advanced
dylpickledevdylpickledev
4

dbt-model-scaffolder

Generate dbt model SQL scaffolds and schema.yml files with tests.

Community
Advanced