Infrastructure for Answers
The cloud data warehouse built for answers, in SQL or natural language. Fast, serverless analytics powered by DuckDB–from production apps to internal insights.
"DuckDB In Action" Book for Free
Get the complete book for free in your inbox!
Data Warehouse + AI
Hypertenancy Data Warehouse
A cloud analytical database that scales per-user compute nodes independently, serving sub-second latency without resource contention.
MotherDuck MCP Server
Turn natural language questions into accurate, traceable SQL queries with fully sandboxed compute.
Who is it for?
Cloud analytics and data warehouse solutions for every team
Who is it for?
Cloud analytics and data warehouse solutions for every team
Use Cases
Data Warehousing
Is your data all over the place? Modern cloud data warehouse tools bring it together for business intelligence and SQL analytics. Build data pipelines, share data, and collaborate with your team.
Customer-facing Analytics
Unlike traditional BI, customer-facing analytics is built directly into your product for end users. This embedded analytics solution delivers real-time, low-latency insights at scale — think milliseconds, not minutes — powered by a columnar database that handles thousands to millions of concurrent queries. MotherDuck's architecture, from Hypertenancy to Wasm support, is designed for Customer-Facing Analytics that drives user engagement directly in your app.
How We Scale
Duckling Sizes
MotherDuck’s per-user tenancy model gives each user an isolated
A Duckling is a dedicated DuckDB instance for each user, ensuring optimal performance and scalability in data analytics.
Pulse
Our smallest instance, perfect for ad-hoc analytics tasks
Standard
Built to handle common data warehouse workloads, including loads and transforms
Jumbo
For larger data warehouse workloads with many transformations or complex aggregations
Mega
An extremely large instance for when you need complex transformations done quickly
Giga
Largest instances enable the toughest transformations to run faster
Hypertenancy and vertical scaling
MotherDuck's cloud data warehouse employs a Hypertenancy and vertical scaling strategy. Users connect to their own MotherDuck Ducklings (DuckDB instances), which are sized (pulse, standard, jumbo, mega, giga) to meet their specific needs. There is also the option for additional Ducklings, through read scaling (explained below), to ensure flexible resource allocation. Ultimately, each Duckling establishes a connection with the central data warehouse storage.
Read Scaling
MotherDuck's read scaling capabilities allow users to connect via a BI Tool to dedicated Ducklings that function as read replicas. These read replicas can be provisioned in various sizes (pulse, standard, jumbo, mega or giga) to accommodate different needs. Ultimately, these read replicas connect to the Data Warehouse storage, enabling efficient handling of read operations.
Ecosystem
Modern Duck Stack
CLOUD DATA WAREHOUSE
Sources
Business Intelligence
Ingestion
Data Science & AI
Reverse ETL
Transformation
Dev Tools
Join the flock
SUBSCRIBE
Subscribe to our newsletter
