MotherDuck Documentation

MotherDuck is a serverless cloud data warehouse built on DuckDB. It's designed for fast, interactive SQL analytics without the infrastructure overhead. Build a modern data warehouse for BI, or power customer-facing analytics in your app. Develop and iterate locally, share and scale in the cloud when you need it.

Choose your path

MotherDuck Tutorial

Build an end-to-end workflow: load data, transform it, and share results

Data Warehousing Overview

Build a modern warehouse with ingestion and transformation

Customer-Facing Analytics Overview

Build analytics apps with the MotherDuck Wasm client

Talk to Your Data with AI

Analyze your data with natural language using the MCP Server

Connect to MotherDuck

Connect to MotherDuck using official drivers and APIs for various programming languages.

Python

MotherDuck UI

Node.js

WebAssembly

Golang

View all clients and drivers →

Load data to MotherDuck

Load your data from other databases and object storage

S3

PostgreSQL

BigQuery

View supported ingestion tools →

Integrate with your data stack

Connect with a lot of common tools from the modern data stack.

dbt

Fivetran

Tableau

View all integrations →

Common tasks

Some common tasks and use cases to get you started.

Connect to Power BI

Use the DuckDB Power Query connector for Power BI

Authenticate

Log in or use access tokens for CLI and drivers

Query from DuckDB CLI

Install the DuckDB CLI and connect directly to MotherDuck

Use SQLAlchemy

Connect to MotherDuck with Python & SQLAlchemy

Connect to DuckLake

Use DuckLake to build a data lake on top of your own files