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.

📄️ Database Concepts

MotherDuck Database Concepts

📄️ Storage Lifecycle and Management

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

📄️ pg_duckdb Extension

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

📄️ Object name resolution

Fully qualfied naming convention

📄️ 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