Concepts

This section contains a collection of high level views of concepts & features.

Architecture and capabilities

MotherDuck's serverless architecture combining cloud scale with DuckDB's efficiency through Dual Execution.

Database Concepts

MotherDuck Database Concepts

Hypertenancy

Learn how MotherDuck's hypertenancy model provides dedicated compute for every user through per-user Ducklings, enabling predictable performance without noisy neighbors.

Database Snapshots

Understand how snapshots work in MotherDuck, including retention, restore, snapshot management, and plan availability

pg_duckdb Extension

Use pg_duckdb to run DuckDB analytics within PostgreSQL and connect to MotherDuck.

Storage Lifecycle and Management

Understand how MotherDuck manages data storage across different lifecycle stages and how this affects your billing and data management strategies.

Data Recovery

Understand MotherDuck's data recovery mechanisms

Object name resolution

Fully qualified naming conventions and database resolution rules in MotherDuck.

DuckDB Extensions in MotherDuck

Supported DuckDB extensions for the MotherDuck cloud service, Web UI, and CLI.

DuckLake

Understanding DuckLake - A high-performance open table format for petabyte-scale analytics