Skip to main content

Ready-to-use MotherDuck starter projects

Self-contained, copy-or-clone examples with setup instructions, dependencies, and working code—perfect for bootstrapping your next MotherDuck project.

Get startedBrowse examples

Quick start

The fastest way to get a starter project is using the get-starter script. It downloads only the project you need.

1

Choose a starter project

Browse the available examples in the sidebar. Each starter is self-contained with its own README, dependencies, and example code.
2

Download the starter

Run the get-starter script with your chosen project name:
curl -fsSL https://raw.githubusercontent.com/motherduckdb/motherduck-examples/main/scripts/get-starter.sh | bash -s <starter-name>
For example, to get the Python ingestion starter:
curl -fsSL https://raw.githubusercontent.com/motherduckdb/motherduck-examples/main/scripts/get-starter.sh | bash -s python-ingestion
3

Set up your MotherDuck credentials

Most starters require a MotherDuck account and access token:
4

Run the example

Follow the README in your downloaded starter project. Most projects use uv for Python dependency management or standard dbt commands.

Explore by category

Choose a category to find examples for your use case.

Data ingestion

Python and dbt patterns for loading data from APIs, S3, and other sources into MotherDuck.

dbt patterns

Advanced dbt workflows including AI functions, dual execution, and MetricFlow semantic layers.

Data replication

Replicate data from PostgreSQL and other databases to MotherDuck using DLT.

Integrations

Connect MotherDuck to Grafana, SQLMesh, and other tools in your data stack.

Featured examples

Popular starter projects to get you building quickly.

Python data ingestion

Load data from APIs into MotherDuck using Python. Includes patterns for small and large datasets with Pandas and PyArrow.

View example

dbt with AI functions

Use MotherDuck’s AI prompt() function in dbt pipelines to transform unstructured text into structured data.

View example

dbt dual execution

Run dbt models across both local DuckDB files and cloud MotherDuck databases in a single workflow.

View example

PostgreSQL replication with DLT

Efficiently replicate PostgreSQL tables to MotherDuck using DLT with parallelization and optimized batch sizes.

View example

Ready to start building?

Choose a starter project and get up and running in minutes. Each example includes everything you need to start building with MotherDuck.

Get started now

Build docs developers (and LLMs) love

Get started for freeTalk to us