motherduck-model-data

What problem does it solve?

It helps you design and restructure analytical schemas in MotherDuck without ending up with one-off, hard-to-review SQL scattered across chat.

Core Features & Use Cases

• File-based modeling scaffold: Generates a lightweight project structure (raw, staging, analytics) instead of only producing SQL to run immediately.
• Explicit model DAG via manifest: Produces a model_manifest.yml capturing dependencies, materialization strategy, and model metadata for reproducible rebuilds.
• Analytics-first schema decisions: Guides denormalized, read-optimized modeling patterns with explicit types, nullability, and fully qualified names.

Quick Start

Use motherduck-model-data to create a new analytics-ready data model for “orders and customers” with raw, staging, and analytics layers, including a model_manifest.yml that defines the dependencies.