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 remote MCP Server](/content/docs/getting-started/mcp-getting-started/index.html)
\
Create Visualizations with Dives\
Generate interactive, shareable dashboards from natural language prompts](/content/docs/key-tasks/ai-and-motherduck/dives/index.html)
Try MotherDuck for free
Sign up and start querying in minutes. No credit card required.
Connect to MotherDuck
Connect to MotherDuck using official drivers and APIs for various programming languages.
\
Python](/content/docs/getting-started/interfaces/client-apis/python/installation-authentication/index.html)
MotherDuck UI
\
Node.js](https://duckdb.org/docs/stable/clients/node_neo/overview.html)
\
WebAssembly](/content/docs/sql-reference/wasm-client/index.html)
\
Golang](/content/docs/integrations/language-apis-and-drivers/go-driver/index.html)
Load data to MotherDuck
Load your data from other databases and object storage
\
S3](/content/docs/integrations/cloud-storage/amazon-s3/index.html)
\
PostgreSQL](/content/docs/key-tasks/loading-data-into-motherduck/loading-data-from-postgres/index.html)
\
BigQuery](/content/docs/integrations/databases/bigquery/index.html)
Integrate with your data stack
Connect with a lot of common tools from the modern data stack.
\
dbt](/content/docs/integrations/transformation/dbt/index.html)
\
Fivetran](https://fivetran.com/docs/destinations/motherduck#motherduck)
\
Tableau](/content/docs/integrations/bi-tools/tableau/index.html)
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