MotherDuck
MotherDuck is a serverless cloud data warehouse built on DuckDB for data teams, app developers, and AI agents.
What MotherDuck is
MotherDuck is a serverless cloud data warehouse built on DuckDB for data teams, app developers, and AI agents. Its hypertenancy model gives each user, customer, or agent a separate DuckDB instance, called a Duckling. Teams can share databases through read-only, zero-copy objects that recipients can query without exporting or duplicating files. MotherDuck also provides an MCP Server for AI agents to inspect catalogs, run SQL, read Guides, create Dives, and manage Flights. Flights are scheduled Python pipelines, while Dives are interactive visualizations that can be filtered, explored, shared, or embedded in apps. Listed integrations include dbt, Airflow, Fivetran, Hex, Tableau, and Omni. It offers web and API access, SQL notebooks, team query sharing, and AI query assistance. Lite is free and includes up to 3 internal active users, 2 service accounts, 10 GB storage, and 10 hours of Pulse compute monthly. Business is $250 a month, billed per organization plus usage, with a 7-day free trial. MotherDuck states that it has SOC 2 Type II attestation and GDPR verification by GDPR Local.
Good
- Read-only sharing avoids file exports and duplicate copies.
- Scheduled Python data pipelines run inside MotherDuck.
- Dives can be shared or embedded in apps.
- Free Lite plan includes 10 GB storage.
- Offers web and API access.
Watch out
- Lite limits internal active users to 3.
- Lite includes 10 hours of Pulse compute monthly.
- Business costs $250 a month plus usage.
- Business trial lasts 7 days.
Who it suits
MotherDuck suits data teams, app developers, and AI agent workflows that need a cloud data warehouse built on DuckDB. Its free Lite plan may suit smaller teams within the listed user, storage, and compute limits.
Verdict
MotherDuck combines DuckDB-based warehousing with sharing, pipelines, visualizations, and AI agent access. The free Lite plan has defined user, storage, and compute limits; Business is $250 a month plus usage.
Plans and prices
From MotherDuck's own pricing page, checked 2 Oct 2026.
| Plan | Price | What it gives you |
|---|---|---|
| Lite | Free | Up to 3 internal active users · 2 service accounts · 10 GB free storage · 10 hrs Pulse compute per month · Pulse instances only · Community support |
| Business | $250 a month | 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 · PER ORG / MONTH + USAGE |
| Enterprise | Priced on request | Unlimited internal active users and service accounts · Fixed-cost capacity pricing · AWS PrivateLink · IP allowlisting · HIPAA BAA · BYOC available on request |
The facts
Each one read from MotherDuck's own pages, with the date it was checked.
What it does
- Access controls
- The pricing comparison lists preset and custom role-based access control, table-level security, and SSO via SAML and OIDC.checked 2 Oct 2026
- AI agents
- The MotherDuck MCP Server lets AI agents inspect catalogs, run SQL, read Guides, create Dives, and manage Flights.checked 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.checked 2 Oct 2026
- Integrations
- The maker lists integrations with tools including dbt, Airflow, Fivetran, Hex, Tableau, and Omni.checked 2 Oct 2026
- Isolated compute
- Hypertenancy gives each user, customer, or AI agent an isolated DuckDB instance called a Duckling.checked 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.checked 2 Oct 2026
- Pipelines
- Flights are scheduled Python data pipelines that run inside MotherDuck.checked 2 Oct 2026
- Product
- MotherDuck is a serverless cloud data warehouse built on DuckDB for data teams, app developers, and AI agents.checked 2 Oct 2026
- Security
- MotherDuck states that it has completed SOC 2 Type II attestation and is GDPR verified by GDPR Local.checked 2 Oct 2026
- Support
- Lite includes community support, while Business includes support from MotherDuck experts.checked 2 Oct 2026
- Visualizations
- Dives are live, interactive visualizations that users can filter, drill down on, share, or embed in an app.checked 2 Oct 2026
The company
- Company origin
- MotherDuck’s about page says its team first met in Seattle the week of June 20, 2022.checked 2 Oct 2026
- Founded
- 2022checked 28 Sep 2026
- Headquarters
- Seattle, Washington, United Stateschecked 28 Sep 2026
Alternatives to MotherDuck
- 1
Outerbase Studio
Free planOpen sourceAndroidiOSWebAPI8.5From $9 a month - 2
DBeaver
Free planOpen sourceWebAPIExtensionLinux8.2From $113 a year - 3
Beekeeper Studio
Free planOpen sourceAPIExtensionLinuxmacOS8.0From $18 a month - 4
Mode
Free planWebAPILinuxmacOS7.5Free plan - 5
CloudBeaver
Free planWebLinuxmacOSSelf-hosted7.1From $1,025 a year - 6
Hex
Free planWebAPI7.0From $36 a month