Pricing model
MotherDuck pricing model
MotherDuck is a serverless cloud data warehouse. We believe in providing our users with simple pricing.
MotherDuck offers two self-serve plans: Lite and Business.
MotherDuck is available on AWS in four regions: US East (N. Virginia) - us-east-1, US West (Oregon) - us-west-2, Europe (Frankfurt) - eu-central-1, and Europe (Dublin) - eu-west-1. Each MotherDuck Organization is scoped to a single cloud region that must be chosen at Org creation when signing up.
Plan comparison
| Feature | Lite | Business | Enterprise |
|---|---|---|---|
| Best for | Individual users, small projects | Teams and organizations | Bespoke deployments: Contact us |
| Platform fee | $0/month | $250/month | Custom |
| Compute included | Includes 10 Compute Unit (CU) hours / month + Pay-as-you-go for additional usage | Pay-as-you-go for additional usage | Custom |
| Duckling sizes | Pulse only | Pulse, Standard, Jumbo, Mega, Giga | Pulse, Standard, Jumbo, Mega, Giga |
| Read Scaling | - | Yes | Yes |
| Storage included | Includes 10 GB / month + Pay-as-you-go for additional usage | Pay-as-you-go for additional usage | Custom |
| Users | 3 active users / 2 service accounts | 10 active users / unlimited service accounts | Custom |
| SLA | - | 99.9% Availability | 99.9% Availability |
| Backup | 1 day (paid feature) | - Point-in-time Restore - up to 90 day backups | Custom |
| Observability | - | Query history | Query history |
Users are defined as human users with a login through email + password, Google, GitHub, or SSO, while Service Accounts are defined as non-human accounts designed for programmatic access and automation workflows (for example, backend services, integrations, or customer-facing analytics).
Compute pricing
A Duckling in MotherDuck is a compute instance. There are 5 Duckling sizes available on the Business plan: Pulse, Standard, Jumbo, Mega, and Giga.
MotherDuck meters compute per-second. While Standard, Jumbo, Mega, and Giga Ducklings are billed for wall clock time, Pulse Ducklings are metered on a per-query basis to support variable, ad-hoc queries. As a result, they are on-demand and auto-scaling.
Non-Pulse Ducklings have a cooldown period, which is the amount of time the Duckling will remain active after completing the last query. This keeps the Duckling warm for follow-up queries that may benefit from MotherDuck's intelligent storage and caching.
The cooldown period is configurable for Standard, Jumbo, Mega, and Giga Ducklings, with a 1-minute minimum.
Pulse Ducklings are metered on a per-query basis, with a minimum of 1 Compute Unit (CU) second instead of wall-clock time: They do not have a configurable cooldown. A Compute Unit (CU) is defined as the amount of CPU and memory usage over time.
If you want to group query history by integration, pipeline, or tenant, set custom_user_agent when connecting to MotherDuck and query MD_INFORMATION_SCHEMA.QUERY_HISTORY. See Tag workloads with custom user agents for an example pattern. Some teams use that breakdown in internal allocation, but MotherDuck billing still follows the pricing model on this page.
The SHUTDOWN and SHUTDOWN TERMINATE commands can be used to shut down a Duckling without waiting for the cooldown period. SHUTDOWN waits for running queries to complete, and SHUTDOWN TERMINATE force-terminates immediately.
Duckling sizes
| Duckling | Billing | Default Cooldown | Configurable Cooldown Period | Details |
|---|---|---|---|---|
| Pulse | Per Compute Unit (CU) (resources consumed), not wall-clock time | N/A | N/A | Small, variable queries, read-heavy workloads, and frontend scenarios. For compute-heavy queries, consider Standard instead. Billing example: 2 queries x 10s = 20 CU seconds. |
| Standard | Per second | 1 minute | 1 min to 24 hours | General purpose data warehouse workloads. Billing example: 5 queries × 30s + 100ms startup + 60s cooldown = 210 seconds. |
| Jumbo | Per second | 1 minute | 1 min to 24 hours | Large-scale data warehouse workloads. Billing example: 2 queries × 8min + 100ms startup + 60s cooldown = 17 minutes. |
| Mega | Per second | 5 minutes | 1 min to 24 hours | Demanding jobs and large-scale workloads. Billing example: 2 queries × 8min + few min startup + 5min cooldown = ~21 minutes. |
| Giga | Per second | 10 minutes | 1 min to 24 hours | Batch jobs and overnight or weekend processing. Billing example: 2 queries × 5min + few min startup + 10min cooldown = ~20 minutes. |
Changing your Duckling size to Pulse, Standard, or Jumbo through the UI or REST API may take up to 2 minutes. Switching to a Mega takes up to 5 minutes, while switching to a Giga takes up to 10 minutes.
Compute
Business Plan
| AWS Region | Pulse | Standard | Jumbo | Mega | Giga |
|---|---|---|---|---|---|
US East (N. Virginia) - us-east-1 | $0.60 per hour | $2.40 per hour | $4.80 per hour | $12.00 per hour | $36.00 per hour |
US West (Oregon) - us-west-2 | $0.60 per hour | $2.40 per hour | $4.80 per hour | $12.00 per hour | $36.00 per hour |
Europe (Frankfurt) - eu-central-1 | $0.73 per hour | $2.93 per hour | $5.86 per hour | $14.65 per hour | $43.95 per hour |
Europe (Dublin) - eu-west-1 | $0.65 per hour | $2.85 per hour | $5.78 per hour | $14.57 per hour | $43.87 per hour |
Lite Plan
| AWS Region | Pulse |
|---|---|
US East (N. Virginia) - us-east-1 | $0.60 per hour |
US West (Oregon) - us-west-2 | $0.60 per hour |
Europe (Frankfurt) - eu-central-1 | $0.73 per hour |
Europe (Dublin) - eu-west-1 | $0.65 per hour |
Lite plan includes 10 CU hours on Pulse per month. Additional usage is billed at the rates above.
Storage pricing
Under the hood, MotherDuck uses DuckDB's compression algorithms to reduce the storage footprint and optimize performance. MotherDuck charges for data stored in its managed storage system based on your average storage usage over the billing period. Your monthly bill is calculated as the average of your daily storage (in GB) multiplied by the per-GB rate.
For example, if your MotherDuck Organization is in us-east-1 and your average storage over December is 650 GB, the final bill will be computed as follows:
- 650 GB × $0.04/GB = $26.00
What counts towards my storage bill?
- Standard databases: MotherDuck provides point-in-time restore by retaining historical data as
historical_bytesfor organizations on paid plans. - Transient databases: Databases can be set as
TRANSIENTat database creation. Transient databases are billed for active data stored and a 1-day failsafe minimum. Data is not retained as failsafe bytes beyond this minimum, which is ideal for temporary or reproducible datasets like intermediate job outputs. - NOTE: By default, for both Standard and Transient databases, new databases retain 1 day of historical data on Lite (paid) and 7 days of historical data on Business - Business plan users are able to configure their
historical_bytesretention window from 0 to 90 days. Users are billed for active data plus historical, retained, and failsafe bytes. Refer to the Storage Lifecycle for more details.
What does not count towards my storage bill?
- Shares do not incur additional data storage as they are a zero-copy operation.
- Using the CREATE DATABASE X FROM DATABASE Y command is also a zero-copy operation. Only incremental changes made to the new database are added to storage as
active_bytes, while active Shares that point to a deleted databases will retainretained_for_clone_bytes. - Any data managed by you in your own object storage bucket, for example S3, Blob, or GCS, that you can use to process data.
- Data on your laptop accessed through the
duckdb -ui, even when signed into MotherDuck.
What changes can I make to optimize my storage bill?
The right approach to optimize storage usage in MotherDuck varies by use case and implementation. Please reach out to us at support@motherduck.com for additional guidance on how to optimize your storage effectively for your needs.
Storage rates
| AWS Region | Cost per GB/month |
|---|---|
US East (N. Virginia) - us-east-1 | $0.04 / GB |
US West (Oregon) - us-west-2 | $0.04 / GB |
Europe (Frankfurt) - eu-central-1 | $0.043 / GB |
Europe (Dublin) - eu-west-1 | $0.04 / GB |
Storage is billed based on your average usage over the billing period.
Lite plan includes 10 GB of free storage. Additional storage is billed at the rates above.
AI function pricing
MotherDuck enhances your analytical capabilities with integrated AI functions. These functions leverage powerful large language models (LLMs), fine-tuned to assist with SQL tasks and unlock new OLAP use cases.
AI functions are categorized and priced as follows:
- SQL Assistant Functions: metered per call, with some free features.
- Advanced AI Functions: metered per token consumed for both input and output, priced in AI Units (1 AI Unit = $1.00).
SQL assistant functions
These features, including FixIt and Text-to-SQL, help you write, understand, and correct SQL queries.
SQL Assistant features are included with both Lite and Business plans.
| SQL Assistant Functions | Price | Unit |
|---|---|---|
| FixIt | FREE | per call |
| SQL Assistant (Text-to-SQL, Explain SQL, etc.) | 1 AI Unit | for 60 calls |
Advanced AI functions
These functions provide access to powerful generative AI models for tasks like embedding generation and complex prompting. They are metered based on token usage, with costs calculated in AI Units (1 AI Unit = $1.00).
For Lite and Business plans, there is a default soft limit on Advanced AI Function consumption of 10 AI Units per day to help control costs. This limit can be increased or removed by contacting support@motherduck.com.
Embedding Models
| Embedding Model Name | Price | Tokens per AI Unit |
|---|---|---|
| OpenAI text-embedding-3-small | 1 AI Unit | 15,000,000 tokens |
| OpenAI text-embedding-3-large | 1 AI Unit | 3,000,000 tokens |
Generative Prompt Models
| Provider | Model Name | Price | Input Tokens (per AI Unit) | Output Tokens (per AI Unit) | Blended Tokens (per AI Unit) |
|---|---|---|---|---|---|
| OpenAI | GPT-5 | 1 AI Unit | 240,000 | 30,000 | 100,000 |
| OpenAI | GPT-5-mini | 1 AI Unit | 1,200,000 | 150,000 | 500,000 |
| OpenAI | GPT-5-nano | 1 AI Unit | 6,000,000 | 750,000 | 2,500,000 |
| OpenAI | GPT-4.1 | 1 AI Unit | 150,000 | 37,500 | 93,750 |
| OpenAI | GPT-4.1-mini | 1 AI Unit | 750,000 | 187,500 | 468,750 |
| OpenAI | GPT-4.1-nano | 1 AI Unit | 3,000,000 | 750,000 | 1,875,000 |
| OpenAI | GPT-4o | 1 AI Unit | 120,000 | 30,000 | 75,000 |
| OpenAI | GPT-4o-mini | 1 AI Unit | 2,000,000 | 500,000 | 1,250,000 |
Incentive programs:
Free trial
New users who sign up for MotherDuck and create an organization automatically get access to a 7-day Free Trial without entering a credit card. Learn how to manage your plan after the trial has ended.
At any point during your Free Trial, you may choose to set up billing and select a plan. At the end of your trial, you can continue with the Lite plan (no credit card required) or upgrade to Business for additional features. Learn more about managing your bill.