Cloud SQL Analytics Powered By DuckDB

Name: MotherDuck App
Brand: MotherDuck

Build Next-Gen Data Warehouses and Apps

Get Started

Features

Cloud database storage

Manage your DuckDB database catalog in the cloud for easy scaling and collaboration.

SQL analytics engine

Efficiently run the same SQL queries on data stored locally, in MotherDuck or in your data lake.

Hybrid query execution

Use idle compute on your laptop in concert with the cloud to increase speed and lower cost.

Notebook-like UI

Use the web to browse the data catalog, write SQL, filter and sort results and share data.

Strong DuckDB ecosystem

Use with 25+ tools in the modern data stack for import, orchestration and business intelligence.

Use CasesUse CasesUse CasesUse CasesUse CasesUse CasesUse CasesUse CasesUse CasesUse CasesUse CasesUse CasesUse CasesUse CasesUse CasesUse CasesUse Cases

Cloud data warehouse for the rest of us

Hardware has advanced a lot in the last 10 years, but we’re still using complicated distributed data processing circa 2005. MotherDuck provides a simplified, performant and efficient data warehouse based on the lightweight DuckDB engine for the 95% of data warehouses that don’t need petabyte scale.

LEARN MORE

Data lake query engine

Do you have all your data in a cloud data lake? Or perhaps just your cold data? MotherDuck uses DuckDB to query your data where it sits as parquet, iceberg, or CSV files. With a notebook-like web UI and vectorized execution, you can run SQL queries on your data sitting in-place.

Serverless backend for Data Apps

Customers of SaaS applications are demanding fast and fresh analytics on their data to make better decisions. Developers often tackle this with analytics queries running on the transactional database (hopefully a replica) which are not designed for the task. MotherDuck uses DuckDB to provide a better solution.

LEARN MORE

Architecture

Managed DuckDB-in-the-cloud

Ecosystem

Modern Duck Stack

FAQS

How much does MotherDuck cost?

We don't yet have billing. We plan to turn it on in early 2024. Read about how we plan on billing here.

Can I use MotherDuck to query my data in S3?

Yes, MotherDuck plays well with AWS S3 as well as other object storage systems that are API-compatible with S3. Head over our documentation to learn how to authenticate and query data in your S3-compatible data lake.

How do I use MotherDuck as an analytical database alongside Postgres as a transactional database?

Postgres, as a row-store, is not designed to handle large-scale aggregations needed for analytics. Many users have migrated to MotherDuck for analytics, either by copying data into parquet files and importing into MotherDuck, using one of our ingestion partners, or using the PostgreSQL support in a local DuckDB instance and copying to MotherDuck. We will be improving our support for this use case.

Can I use something other than SQL to query MotherDuck?

There are multiple clients like Golang or Python supported by DuckDB that work out of the box with MotherDuck. You can also use natural language to query with our experimental AI extension.

I use dbt. Can I use it along with MotherDuck?

The DuckDB dbt adapter works well with MotherDuck for dbt users. Check our documentation for a full guide.

Can I do data visualization with MotherDuck?

MotherDuck supports a wide variety of BI and data visualization tools like Hex, Preset, and many more. Head over to our ecosystem page to know more.