MOTHERDUCK BLOG

DuckDB, MotherDuck, Data Engineering and Data Analytics

Search and filter

Topic

2026/07/10 - Alex Monahan

DuckLake Architecture Deep Dive

DuckLake is a next generation data lakehouse and open table format. It is significantly simpler and faster than Apache Iceberg or Delta Lake because it uses a SQL database for storing the catalog and metadata. This post covers an architecture deep dive with a detailed Q&A section. DuckLake consists of 3 components: storage, catalog, and compute. Each can be scaled independently, hosted locally with ease, and deployed to the cloud for production. MotherDuck offers managed DuckLake lakehouses for additional simplicity and performance.

2026/07/07 - Mehdi Ouazza

How to build robust data pipelines with AI

AI pipelines run green and still return wrong numbers. Four habits to turn a one-shot prompt into a data pipeline you can actually trust.

2026/06/29 - Mehdi Ouazza

What if a full data platform was one prompt away?

We launched Flights, an AI-native Python runtime in MotherDuck. Here's how I built a full end-to-end data pipeline (two scheduled Flights and a Dive dashboard) from a single prompt, using an AI coding agent and the MotherDuck MCP.

2026/06/29 - Mehdi Ouazza

What if a full data platform was one prompt away?

2026/06/24 - Jerel Navarrete, Jacob Matson

What makes a great Dive? What DiveMaxxing taught us

The DiveMaxxing winners, and what 48 community Dives taught us about what separates a great data visualization from one that just looks polished.

2026/06/18 - Alex Monahan

Flight Plans: Templates for AI-Native Data Pipelines

Build full data pipelines by prompting your AI agent, no Python required. MotherDuck Flights are perfect for data ingestion, transformation, and activation. Flight Plan templates show you and your agent how to ingest from Postgres, sync Google Sheets, and send Slack alerts.

2026/06/16 - Carlin Eng

Replacing Our BI Tool with Dives

How MotherDuck replaced its BI tool in under a month using Claude Code agents: a migration that once would have taken 3 people six months and $500K.

2026/06/12 - Simon Späti

DuckDB Ecosystem Newsletter : June 2026

The June 2026 DuckDB Ecosystem Newsletter: a local-first ETL/ELT studio, the Quack client-server protocol and its OAuth layer, DuckLake inlining, DuckDB internals, MotherDuck Flights for agent-native ingest, plus a community spotlight on Ryan Dolley.

2026/06/10 - Miguel Miranda, Doo Shim

Introducing Flights: Agent-Native Ingest in MotherDuck

Build, deploy, and schedule Python data pipelines from a prompt, a SQL function, or the MotherDuck UI.

2026/06/08 - Jacob Matson

The Surprising Truth About AI-Native Semantic Layers

Benchmark-maxxing DABstep to 100% and learning that an AI-native semantic layer isn't a description of your data — it's coupled to the model that reads it.

2026/06/05 - Simon Späti

Vibe Coding Is Dangerous, Agentic Engineering Isn't ft. Wes McKinney

Wes McKinney, creator of pandas and co-creator of Apache Arrow, shares how he works with AI coding agents: spec-driven workflows with superpowers, continuous AI code review with Roborev, token economics, and why vibe coding is dangerous but agentic engineering isn't.