DuckDB and analytics skills from MotherDuck.
Official MotherDuck skills spanning connection, SQL, loading, modeling, sharing, Dives, Flights, governance, pricing, and analytics use cases.
Arranged in the author's recommended order. Walk through them in sequence, or open any one on its own.
Connect to MotherDuck from any application.
Discover and explore databases, tables, columns, and data shares in MotherDuck.
Execute DuckDB SQL queries against MotherDuck databases.
DuckDB SQL reference for MotherDuck.
MotherDuck REST API control-plane reference.
Load and ingest data into MotherDuck from local files, object storage (S3, GCS, Azure, R2), HTTPS, dataframes, or external databases.
Design and build database schemas and data models in MotherDuck. Produces a file-based SQL project scaffold with a model manifest.
Create and manage MotherDuck data shares for zero-copy, read-only data distribution.
Create, edit, manage, share, or embed MotherDuck Dives – live React + SQL dashboards, charts, and data apps saved in the workspace.
Create, schedule, run, and debug MotherDuck Flights – Python jobs that run on MotherDuck compute.
Decide when DuckLake is the right MotherDuck storage pattern versus native MotherDuck storage (the default).
Explain MotherDuck security, governance, and access-control patterns.
Explain MotherDuck pricing and ROI tradeoffs.
Design a MotherDuck-backed customer-facing analytics app.
Build a live MotherDuck dashboard as a Dive.
Design an end-to-end MotherDuck data pipeline.
Plan a migration onto MotherDuck.
Roll out self-serve analytics on MotherDuck for internal teams.
Deliver repeatable MotherDuck architectures across multiple clients.