MotherDuck

MotherDuck is a serverless cloud data warehouse built on DuckDB. It is designed for data engineering teams, analysts, and software developers building production analytics, internal dashboards, and customer-facing data applications.

The platform uses a hypertenancy architecture where every user, dashboard, and AI agent gets its own isolated DuckDB compute instance called a Duckling. This model prevents resource contention and ensures fast query response times across concurrent workloads.

Key features

• Hypertenancy architecture: Allocates isolated DuckDB compute instances to every user and agent session to prevent query queues.
• Model Context Protocol server: Provides AI assistants with structured read and write access to explore schemas and run queries.
• Flights runtime: Executes Python workloads and data pipelines directly on MotherDuck compute for ELT and AI enrichment.
• Dives visualization: Generates interactive, embeddable visualizations and dashboards without requiring external BI software.
• Guides context layer: Stores query patterns, metric definitions, and schema context to improve agent query accuracy.
• Multi-interface support: Connects via CLI, REST API, ODBC, and standard database drivers for tools like dbt and Hex.