MOTHERDUCK BLOG

MOTHERDUCK BLOG

DuckDB, MotherDuck, Data Engineering and Data Analytics

Search and filter

Search and filter

Topic

Internal vs. External Storage: What's the Limit of External Tables?

2026/04/24 - Simon Späti

Internal vs. External Storage: What's the Limit of External Tables?

25 years of external tables, from Oracle 9i to DuckLake. When to use internal storage vs. external tables, why they keep getting re-added to every major data warehouse, and a benchmark showing the speed tax for cold data.

MotherDuck on Cloudflare Workers

2026/04/21 - Dumky de Wilde

MotherDuck on Cloudflare Workers

Build a real-time voting app on Cloudflare Workers that queries MotherDuck through the Postgres endpoint, using Durable Objects for live state and the pg package for analytical workloads.

MotherDuck Skills: Teaching Your AI Agents to Do Analytics

2026/04/20 - Mehdi Ouazza, Samantha Lohier, Leonardo Vida

MotherDuck Skills: Teaching Your AI Agents to Do Analytics

MotherDuck Agent Skills is an open-source catalog that teaches AI coding agents how to work with MotherDuck: exploring schemas, writing DuckDB SQL, using the REST API, and building Dives. If MCP gives agents hands, skills give them a playbook.

MotherDuck Skills: Teaching Your AI Agents to Do Analytics

2026/04/20 - Mehdi Ouazza, Samantha Lohier, Leonardo Vida

MotherDuck Skills: Teaching Your AI Agents to Do Analytics

MotherDuck Agent Skills is an open-source catalog that teaches AI coding agents how to work with MotherDuck: exploring schemas, writing DuckDB SQL, using the REST API, and building Dives. If MCP gives agents hands, skills give them a playbook.

DuckDB Ecosystem Newsletter : April 2026

2026/04/17 - Simon Späti

DuckDB Ecosystem Newsletter : April 2026

DuckLake 1.0 ships, Lance adds vector search, Rust-native extension

Announcing DuckLake 1.0 on MotherDuck

2026/04/16 - Alex Monahan

Announcing DuckLake 1.0 on MotherDuck

MotherDuck now supports DuckLake 1.0, the open table lakehouse format designed for simplicity and low latency. Learn what's new in the 1.0 release, including data inlining, clustering, bucket partitioning, geometry and variant types, plus multi-engine support. Learn how DuckLake compares with Apache Iceberg and Delta Lake.

Water Town: The Agent Swarm Data Stack

2026/04/15 - Jordan Tigani

Water Town: The Agent Swarm Data Stack

In a fully agentic world, will we still need analytics at all? A particularly unhinged example might offer some clues.

Your AI dashboard looks cool. Nobody learns anything from it

2026/04/10 - Mehdi Ouazza

Your AI dashboard looks cool. Nobody learns anything from it

Five fundamental data visualization principles that transform AI-generated dashboards from pretty charts into actionable insights. Learn chart selection, design, narrative, and interactivity.

Building a Text-to-SQL Agent with DuckDB, MotherDuck and LangChain

2026/04/08 - Aditya Somani

Building a Text-to-SQL Agent with DuckDB, MotherDuck and LangChain

Learn how to build a text-to-SQL LLM and LangChain SQL agent with DuckDB and MotherDuck, including schema inspection, query checking, and self-correction.

Consulting the Oracle: Claude on the Future of Data

2026/04/03 - Jordan Tigani

Consulting the Oracle: Claude on the Future of Data

What does AI think its own impact will be on the data and analytics industry? I asked Claude to share its predictions on the Modern Data Stack, data jobs, and the future of analytics.

Embedded Dives: Interactive Data Apps for Customer-Facing Analytics

2026/04/02 - Garrett O'Brien, Hamilton Ulmer

Embedded Dives: Interactive Data Apps for Customer-Facing Analytics

Real-time, interactive data apps – now embedded anywhere in your application. Created by your favorite agents and powered by dual execution.

MotherDuck Now Speaks Postgres

2026/03/31 - Louisa Huang, Jelte Fennema-Nio, Garrett O'Brien

MotherDuck Now Speaks Postgres

MotherDuck's Postgres endpoint lets you query your data warehouse using any PostgreSQL-compatible client, driver, or BI tool — no new dependencies needed.

Specs Over Vibes: Consistent AI Results ft. Mark Freeman

2026/03/27 - Simon Späti

Specs Over Vibes: Consistent AI Results ft. Mark Freeman

Mark Freeman, Head of DevRel at Gable, shares his Spec-Driven Development workflow for producing high-quality, reproducible AI outcomes using Claude Code, ExcaliDraw diagrams, JSON schemas, and agent teams with tmux.

The Dive Gallery Is Live: Share Your Interactive Data Apps With the World

2026/03/25 - Ryan Boyd, Mehdi Ouazza

The Dive Gallery Is Live: Share Your Interactive Data Apps With the World

Share interactive, AI-built data apps with anyone through a unique link — queries run live on MotherDuck compute.

Don't Fear the Agents - AI on the Data Lakehouse

2026/03/24 - Alex Monahan

Don't Fear the Agents - AI on the Data Lakehouse

Learn how MotherDuck's Hosted DuckLake combines lakehouse scale (borrowing the best ideas from Apache Iceberg and Delta Lake) with low latency and agent sandbox isolation, making it the simplest data lakehouse for AI-powered agentic workflows.

Future Casting the Modern Data Stack

2026/03/23 - Jordan Tigani

Future Casting the Modern Data Stack

If the Modern Data Stack isn't yet dead, it's at least incredibly sleepy. AI is bringing the "long run" closer than ever — here's what might come next for ETL, BI, data warehouses, and the role of data engineers.

Claudeception: Inside the Mind of an Analytics Agent

2026/03/19 - Garrett O'Brien

Claudeception: Inside the Mind of an Analytics Agent

More tool calls, more schema exploration, more verification — does it help, or hurt? We dug into the chain-of-thought traces behind one of the hardest text-to-SQL benchmarks to understand how analytics agents actually think.

DuckDB Ecosystem Newsletter – March 2026

2026/03/13 - Simon Späti

DuckDB Ecosystem Newsletter – March 2026

SQL Transpilers, VS Code Extensions, Dives and more