MotherDuck

Free plan APIWeb

What MotherDuck is

MotherDuck is a serverless cloud data warehouse built on DuckDB, with web and API access for data teams, app developers, and AI agents. Its Hypertenancy setup gives each user, customer, or agent a separate DuckDB instance called a Duckling. Teams can share databases through read-only objects that let recipients query the data without exporting files or making another copy. The MotherDuck MCP Server gives AI agents ways to inspect catalogs, run SQL, read Guides, create Dives, and manage Flights. Flights are scheduled Python data pipelines that run inside MotherDuck; Dives are interactive visualizations that can be filtered, explored, shared, or embedded in an app. The maker lists integrations including dbt, Airflow, Fivetran, Hex, Tableau, and Omni. MotherDuck also offers team query sharing, SQL notebooks, and AI query assistance. Its free Lite plan includes up to 3 internal active users, 2 service accounts, 10 GB of storage, and 10 hours of Pulse compute per month. Business costs $250 a month per organization plus usage, and includes a 7-day free trial. The company states that it has completed SOC 2 Type II attestation and is GDPR verified by GDPR Local.

Who it suits

MotherDuck suits data teams and app developers who want a cloud data warehouse built on DuckDB, as well as teams sharing queryable data or building scheduled Python pipelines and interactive visualizations. Its MCP Server and isolated Duckling instances also serve AI-agent workflows.

What it does well

Read-only database shares let recipients query data without file exports or duplicate copies.
Ducklings isolate compute for each user, customer, or AI agent.
Flights run scheduled Python data pipelines inside MotherDuck.
Dives can be filtered, shared, or embedded in an app.
Integrations include dbt, Airflow, Fivetran, Hex, Tableau, and Omni.
SOC 2 Type II attestation and GDPR verification are stated.

What to know first

Lite is limited to 3 internal active users and 2 service accounts.
Lite includes 10 GB storage and 10 hours of monthly Pulse compute.
Lite supports Pulse instances only.
Business costs $250 a month per organization, plus usage.

Limits

Lite includes up to 3 internal active users, 2 service accounts, 10 GB free storage, and 10 hours of Pulse compute per month. It supports Pulse instances only. Business is $250 a month per organization plus usage and includes a 7-day free trial.

Plans

Plan	Billed and limits	Price
Lite	Up to 3 internal active users · 2 service accounts · 10 GB free storage · 10 hrs Pulse compute per month · Pulse instances only · Community support	Free
Business	PER ORG / MONTH + USAGE · Up to 10 internal active users · Unlimited service accounts · 5 instance types and read-scaling replicas · 90-day snapshot retention · 99.9% availability SLA · 7-day free trial	$250 a month
Enterprise	Unlimited internal active users and service accounts · Fixed-cost capacity pricing · AWS PrivateLink · IP allowlisting · HIPAA BAA · BYOC available on request	On request

As motherduck.com lists them, read 2 Oct 2026. The maker's own page has the final word.

Getting started

Open https://motherduck.com/.
Choose the free Lite plan or review the Business plan, which includes a 7-day free trial.
Use the web or API platform to access MotherDuck.
Connect tools such as dbt, Airflow, Fivetran, Hex, Tableau, or Omni if they are part of your workflow.

Verdict

Choose MotherDuck if you need a serverless DuckDB warehouse with queryable data sharing, isolated compute, or integrated pipelines and visualizations. The free Lite plan has limits on users, storage, service accounts, and compute; Business starts at $250 a month per organization plus usage.

Questions

Is MotherDuck free?

Yes. Lite costs nothing and includes up to 3 internal active users, 2 service accounts, 10 GB storage, and 10 hours of Pulse compute per month.

How much does Business cost?

Business costs $250 a month per organization, plus usage. A 7-day free trial is included.

What platforms does MotherDuck support?

MotherDuck lists web and API access.

What integrations are listed?

The maker lists dbt, Airflow, Fivetran, Hex, Tableau, and Omni among its integrations.

What access controls are available?

The pricing comparison lists preset and custom role-based access control, table-level security, and SSO via SAML and OIDC.

What support comes with each plan?

Lite includes community support. Business includes support from MotherDuck experts.

Facts from MotherDuck's own pages

Access controls: The pricing comparison lists preset and custom role-based access control, table-level security, and SSO via SAML and OIDC. · motherduck.com, 2 Oct 2026
AI agents: The MotherDuck MCP Server lets AI agents inspect catalogs, run SQL, read Guides, create Dives, and manage Flights. · motherduck.com, 2 Oct 2026
Company origin: MotherDuck’s about page says its team first met in Seattle the week of June 20, 2022. · motherduck.com, 2 Oct 2026
Data sharing: Database sharing uses read-only, zero-copy share objects that consumers can query without exporting files or creating a second copy. · motherduck.com, 2 Oct 2026
Founded: 2022 · motherduck.com, 28 Sept 2026
Headquarters: Seattle, Washington, United States · motherduck.com, 28 Sept 2026
Integrations: The maker lists integrations with tools including dbt, Airflow, Fivetran, Hex, Tableau, and Omni. · motherduck.com, 2 Oct 2026
Isolated compute: Hypertenancy gives each user, customer, or AI agent an isolated DuckDB instance called a Duckling. · motherduck.com, 2 Oct 2026
Notable limit: The Lite plan includes up to 3 internal active users, 2 service accounts, 10 GB storage, and 10 hours of Pulse compute per month. · motherduck.com, 2 Oct 2026
Pipelines: Flights are scheduled Python data pipelines that run inside MotherDuck. · motherduck.com, 2 Oct 2026
Product: MotherDuck is a serverless cloud data warehouse built on DuckDB for data teams, app developers, and AI agents. · motherduck.com, 2 Oct 2026
Security: MotherDuck states that it has completed SOC 2 Type II attestation and is GDPR verified by GDPR Local. · motherduck.com, 2 Oct 2026
Support: Lite includes community support, while Business includes support from MotherDuck experts. · motherduck.com, 2 Oct 2026
Visualizations: Dives are live, interactive visualizations that users can filter, drill down on, share, or embed in an app. · motherduck.com, 2 Oct 2026