Softwr
MotherDuck logo

MotherDuck

Serverless analytics data warehouse built on DuckDB

As of 30 August 2026, MotherDuck has a free plan and paid plans start at $250/month. MotherDuck is a serverless cloud data warehouse built on DuckDB for fast, low-cost analytics. Softwr lists it under Databases. MotherDuck is launched in 2022, available on Web, API.

Overview

What MotherDuck does

MotherDuck is a serverless analytics data warehouse built on top of DuckDB, letting teams query gigabytes to terabytes of data with sub-second performance. It spins up isolated DuckDB instances per user or agent, can query cloud storage (S3, GCS, Azure) without ingestion, and offers AI-native features via an MCP server for use with Claude and other agents. It was founded in 2022 by Jordan Tigani, a founding engineer of Google BigQuery, and is based in Seattle, Washington.

What people use it for

  • Ad-hoc analytics on gigabyte-to-terabyte datasets
  • Querying data lake files in S3/GCS/Azure without ingestion
  • AI agent data analysis via MCP
  • Scheduled data pipeline transformations

The honest half

Where it falls short

Concrete and checkable, so you can decide whether any of them matter to you. This is the half of a review a vendor will not write about MotherDuck.

  • The free Lite plan caps compute at 10 hours per month, which limits it to light or hobbyist workloads.
  • Business plan usage charges on top of the $250/month base can make costs less predictable than flat-rate competitors.
  • There are no academic or non-profit discounts, unlike some competing data platforms.
  • Annual billing requires going through a sales conversation rather than a self-serve toggle.

Cross-shopped

What people choose instead of MotherDuck

Each pairing was judged by two reviewers asking whether a buyer would genuinely weigh the two against each other. The ones that failed were deleted rather than published.

  • MotherDuck logo
    MotherDuck
    vs
    TimescaleDB logo
    TimescaleDB

    TimescaleDB: Both are cloud database platforms for analytics, though Timescale focuses on time-series Postgres rather than serverless DuckDB.

  • MotherDuck logo
    MotherDuck
    vs
    Turso logo
    Turso

    Turso: Both offer serverless, developer-friendly managed databases, though Turso targets transactional edge SQLite rather than analytics.

Pricing

What MotherDuck costs

Taken from the vendor's own pricing page. Prices move, so check before you buy.

Lite

Free

  • Up to 3 internal active users
  • 2 service accounts
  • 10GB free storage
  • 10 hours Pulse compute/month
  • Community support

Business

$250 /mo

  • Up to 10 internal active users
  • Unlimited service accounts
  • 5 instance types with read-scaling replicas
  • 90-day snapshot retention
  • 99.9% availability SLA

Enterprise

On request

  • Unlimited internal users and service accounts
  • Fixed-cost capacity pricing
  • AWS PrivateLink, IP allowlisting
  • HIPAA BAA available

Capabilities

Features

  • Serverless DuckDB instances

    Isolated 'Ducklings' spin up in around 100ms per user or agent.

  • Cloud storage querying

    Query data directly in S3, GCS, or Azure without a separate ingestion step.

  • MCP server

    AI-native integration lets agents like Claude query and analyze data directly.

  • Dives

    Interactive data visualizations for exploring query results.

  • Flights

    Agent-native, scheduled data pipelines for recurring transformations.

  • Read-scaling replicas

    Multiple instance types with read replicas for concurrent workloads on paid plans.

Answered, with sources

Questions people ask

Each answer names the page it came from, so you can check it rather than take our word for it.

What does MotherDuck cost?

The Lite plan is free (up to 3 users, 10GB storage, 10 hours of Pulse compute/month). Business is $250/organization/month plus usage, with Enterprise available at custom fixed-cost pricing.

Source
Is there a free plan and what are its limits?

Yes, the Lite plan is free for up to 3 internal active users and 2 service accounts, with 10GB of storage and 10 hours of Pulse compute per month.

Source
How is usage metered?

Compute instances (Pulse, Standard, Jumbo, Mega, Giga) are billed per second at hourly rates from $0.60 to $24.00/hour, storage is $0.04/GB-month, and AI Functions cost $1.00 per AI Unit.

Source

Behind it

Who makes MotherDuck

Company
MotherDuck
Based in
Seattle, Washington
Founders
Jordan Tigani

Timeline

MotherDuck over time

  1. Founded2022-01-01T00:00:00.000Z

    MotherDuck founded by Jordan Tigani, former Google BigQuery founding engineer

    Source
Share

Keep looking

Where to go from MotherDuck

Best Databases software for

Compare MotherDuck with

Other Databases software

  • Time-series database built on PostgreSQL for real-time analytics

    Free plan12 researched notes
  • SQLite-lineage database platform for running very large numbers of small per-tenant databases, with an MIT-licensed engine.

    Free, then $4.99/mo14 researched notes
  • Multi-model database combining documents, graphs, vectors and time-series

    Free plan9 researched notes
  • Google Cloud's serverless analytical warehouse, billed either by bytes scanned per query or by reserved compute slots.

    Free plan13 researched notes
  • Fast, scalable cloud data warehouse from AWS

    Free plan12 researched notes
  • Sub-second analytics at cloud data warehouse scale

    From $1.84/hour14 researched notes
  • Fast open-source column-oriented database for real-time analytics

    Free plan12 researched notes
  • MIT-licensed analytical SQL database that runs inside your process, with no server, no dependencies and one writer at a time.

    Free plan14 researched notes
  • The heart of the Elastic Stack for search and analytics

    Free, then $16.4/mo11 researched notes
  • The MySQL-compatible serverless database

    Free, then $15/mo12 researched notes
  • Real-time analytics database for sub-second OLAP queries

    Free plan10 researched notes
  • Open-source search and analytics suite forked from Elasticsearch

    Open source9 researched notes
  • High-performance vector database for similarity search and embedding-based retrieval

    Free plan13 researched notes
  • The real-time distributed SQL database for data-intensive applications

    Free, then $0.99/mo14 researched notes
  • Apache 2.0 distributed SQL database with MySQL wire compatibility and a separate columnar replica for analytical queries.

    Free plan12 researched notes
  • Managed ClickHouse with a workflow that turns SQL queries into hosted HTTP APIs

    Free, then $25/mo12 researched notes
  • Open-source typo-tolerant search engine as an Algolia alternative

    Open source9 researched notes
  • Real-time distributed OLAP datastore for analytics

    Free plan11 researched notes

Softwr does not host reviews and shows no star rating for MotherDuck, because a rating we did not collect is not ours to publish. What is here is the pricing and platform detail from the vendor’s own pages, limitations we could state concretely, and alternatives a reviewer confirmed people weigh against it. Tell us if any of it is wrong.

More on MotherDuck

Best Databases software alternatives

Industrial process historian with published per-tag pricing and no client licence fees

Per tag band per year

NetApp-owned managed service for Cassandra, Kafka, OpenSearch, PostgreSQL and Cadence with a bring-your-own-cloud model

quote

Erlang MQTT broker for large IoT fleets, relicensed to BSL with production free use limited to one node

Per month by connection and session volume

Attribute-based access control and masking applied inside Snowflake, Databricks and BigQuery

quote

MPP analytical database with a MySQL wire protocol and sub-second aggregation on wide tables

Open source, no licence fee

Streaming database that maintains incremental materialised views in SQL instead of Flink jobs

Per RisingWave Unit hour

Centralised data access governance from the creators of Apache Ranger, now rebranding as Trust3 AI

quote

The Meta-lineage distributed SQL query engine, distinct from the Trino fork

Open source, no licence fee

Compare MotherDuck with alternatives