Concepts

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

Architecture and capabilities

MotherDuck is a serverless cloud analytics service with a unique architecture that combines the power and scale of the cloud with the efficiency and convenience of DuckDB.

Data Recovery

Understand MotherDuck's data recovery mechanisms

Database Snapshots

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

pg_duckdb Extension

pgduckdb is an Open-source Postgres extension that embeds DuckDB's columnar-vectorized analytics engine and features into Postgres.

Storage Lifecycle and Management

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

DuckDB Extensions in MotherDuck

MotherDuck supports a wide array of DuckDB extensions to enhance your analytics workflows. Support varies depending on whether you are using the DuckDB CLI, the MotherDuck cloud service (server-side), or the MotherDuck Web UI.

DuckLake

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