MotherDuck documentation

MotherDuck is the serverless cloud data warehouse built on DuckDB. Its hypertenancy architecture gives every user or AI agent an isolated compute instance, so you get sub-second analytics with no infrastructure to manage, no resource contention, and lower costs. Build a modern data warehouse for internal business intelligence, power customer-facing analytics in your application, or build agent-driven analytics tools. Develop and iterate locally, then 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 remote MCP Server

Create Visualizations with Dives

Generate interactive, shareable dashboards from natural language prompts

Try MotherDuck for free

Sign up and start querying in minutes. No credit card required.

Get Started Free

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