What are MotherDuck Examples?
Each starter project is a complete, working example that demonstrates specific patterns and use cases for working with MotherDuck. Instead of starting from scratch, you can clone a starter project that closely matches your use case and customize it for your needs.All starter projects are self-contained with their own README, dependencies, and setup instructions.
Who are these for?
MotherDuck Examples are designed for:Developers
Building data applications and pipelines with MotherDuck
Data Engineers
Setting up data ingestion, transformation, and replication workflows
Analytics Engineers
Creating dbt projects and semantic layers with MotherDuck
Teams
Standardizing patterns and best practices across projects
What’s available?
MotherDuck Examples are organized by use case:Data Ingestion
Learn different approaches for loading data into MotherDuck:- python-ingestion - Python data ingestion patterns for small and large datasets
- dbt-ingestion-s3 - Ingest data from S3 using dbt (local and cloud)
dbt Patterns
Explore dbt workflows and patterns with MotherDuck:- dbt-ai-prompt - Use AI functions in dbt to transform unstructured text
- dbt-dual-execution - Run dbt models across local and cloud databases
- dbt-metricflow - Build semantic layer with MetricFlow (local and cloud)
- dbt-ducklake - Load TPC-DS data into DuckLake for cloud analytics
- dbt-local-ducklake - Use DuckLake locally with TPC-H benchmark data
Data Replication
Replicate data from external sources:- dlt-db-replication - Replicate PostgreSQL to MotherDuck using DLT
Integrations
Connect MotherDuck with visualization and analytics tools:- motherduck-grafana - Connect Grafana to MotherDuck for visualization
- sqlmesh-demo - Transform stock data with SQLMesh and MotherDuck
- motherduck-ui - Interactive data transformation in MotherDuck UI
- postgres-demo - Bi-directional PostgreSQL integration patterns
Requirements
Most starter projects require:MotherDuck account
Sign up at motherduck.com (free tier available)
MotherDuck token
Get your access token from Settings → Access Tokens
Next steps
Quickstart
Get your first starter project in minutes
Browse examples
Explore all available starter projects