Skip to main content

MOTHERDUCK BLOG

MOTHERDUCK BLOG

DuckDB, MotherDuck, Data Engineering and Data Analytics

Search and filter

Search and filter

Topic

Introducing Flight Explainer: Live charts of your python pipelines

Introducing Flight Explainer: Live charts of your python pipelines

Nov 2, 2026 • Colin Rogers, Hamilton Ulmer

Agents can build a MotherDuck Flight in minutes. But how do you know it does what you asked? Flight Explainer is EXPLAIN ANALYZE for your pipelines: a live chart of every run showing the plan, which branch it took, how far each step got, and what it touched.

Introducing Dive Apps: Superpowers for AI Builders

Introducing Dive Apps: Superpowers for AI Builders

Oct 29, 2026 • Alex Monahan

MotherDuck is launching Dive Apps: fully custom data apps that can write-back anywhere. Build them with your agent and they run on the MotherDuck data warehouse. Use Dive Apps to replace SaaS apps, automate your operations, or bring humans into the loop to steer your agents.

Introducing Dive Apps: Superpowers for AI Builders

Introducing Dive Apps: Superpowers for AI Builders

Oct 29, 2026 • Alex Monahan

MotherDuck is launching Dive Apps: fully custom data apps that can write-back anywhere. Build them with your agent and they run on the MotherDuck data warehouse. Use Dive Apps to replace SaaS apps, automate your operations, or bring humans into the loop to steer your agents.

Bringing the Big Ducks

Bringing the Big Ducks

Oct 28, 2026 • Jordan Tigani

The pursuit of all things duck-related has led us to some interesting places. In this blog, MotherDuck CEO Jordan Tigani explores the bigger, darker corners of benchmarks on top DuckDB 1.5 (and teases what is possible in DuckDB 2.0).

DuckDB Ecosystem Newsletter : October 2026

DuckDB Ecosystem Newsletter : October 2026

Oct 18, 2026 • Simon Späti

The October 2026 DuckDB Ecosystem Newsletter: Jev typed AI answers in DuckDB and MotherDuck SQL, DuckDB 2.0's PEG parser and async S3 reads, DuckLake maintenance, analysis-ready OpenStreetMap, OneLake in the browser, a native Mac app, plus a community spotlight on Mark Litwintschik.

prompt_jev() now works on images

prompt_jev() now works on images

Oct 16, 2026 • MotherDuck team

prompt_jev() now takes images: store them as BLOBs in MotherDuck, ask closed questions in SQL, and get typed answers with a confidence score you can join with the rest of your data.

MotherDuck is coming to Azure

MotherDuck is coming to Azure

Oct 15, 2026 • Jacob Matson

MotherDuck is coming to Azure. Pick your region on the waitlist; regions open in order of demand. Your Copilot agents can connect to MotherDuck today.

A Chief of Staff's Guide to Context Layers

A Chief of Staff's Guide to Context Layers

Oct 15, 2026 • Kaitlyn Henry

Kaitlyn, MotherDuck’s Chief of Staff, on why self-serve analytics with AI agents fragments your metrics, and how non-technical leaders can get everyone on one definition of metrics.

Data Engineering Is the Cache Invalidation Problem ft. Josh Wills

Data Engineering Is the Cache Invalidation Problem ft. Josh Wills

Oct 9, 2026 • Simon Späti

Josh Wills, creator of dbt-duckdb and former head of data engineering at Slack, on why the model barely matters, why agents still write ugly and expensive data pipelines, and why data engineering is still the cache invalidation problem.

Build It Yourself: What You'll Make at the Data Outpost Workshops

Build It Yourself: What You'll Make at the Data Outpost Workshops

Oct 5, 2026 • Alex Monahan

Data Outpost kicks off on November 4, 2026 in San Francisco with 11 hands-on workshops from MotherDuck, Vercel, Sigma, Prefect, Estuary, Airbyte, Reducto, Braintrust, and Together AI. Here's what you'll build in each one: your own agents, the data pipelines they need, and the skills to run them in production.

AI Needs Data, Data Needs AI: What You'll Learn at Data Outpost

AI Needs Data, Data Needs AI: What You'll Learn at Data Outpost

Oct 1, 2026 • Alex Monahan

Data Outpost is an AI and data conference in San Francisco. Its main day, November 5, 2026, has 13 talks and panels from teams at Canva, Stripe, DoorDash, Posit, dbt and more. Here's what each session covers, from agents that write back to context layers, SQL harnesses, and AI for regulated data, and what you'll walk away with.

Querying the entire internet with MotherDuck

Querying the entire internet with MotherDuck

Sep 22, 2026 • Dumky de Wilde

Common Crawl publishes petabytes of web crawl data on S3. With DuckDB and MotherDuck you can query the Common Crawl dataset directly, no cluster and no download, and measure how fast the vibe-coded web is growing.

dbt Charts on MotherDuck: Declarative Dashboards

dbt Charts on MotherDuck: Declarative Dashboards

Sep 21, 2026 • Alex Monahan

Define your dashboards in YAML with dbt Charts, then the same dbt build that runs your pipeline deploys them to MotherDuck Dives. Just 2 config changes! Your Dives will refresh live whenever your stakeholders take a look. See how we constructed the dbt package as well.

DuckDB Ecosystem Newsletter : September 2026

DuckDB Ecosystem Newsletter : September 2026

Sep 16, 2026 • Simon Späti

The September 2026 DuckDB Ecosystem Newsletter: DuckLabs joins AWS and MotherDuck acquires Tower, DuckDB v2.0-alpha lands, table functions in pure Java, bulk loads into SQL Server, Zarr stores as SQL tables, an infinite canvas for your data, plus a community spotlight on Vladimir Gribanov.

Why DuckDB 2.0 is faster

Why DuckDB 2.0 is faster

Sep 10, 2026 • Mehdi Ouazza

DuckDB 2.0 alpha vs 1.5.5 on one laptop: recursive CTEs up to 90x, VARIANT 6x faster than JSON text, async I/O 2.4x on S3. What changes, and how to model data to get the speedup.

Agents Don’t Query Like Humans Do

Agents Don’t Query Like Humans Do

Sep 2, 2026 • Alex Monahan

We analyzed a slice of MotherDuck query history and found agents ran 29 times more queries than humans last month, a gap that has roughly doubled every month. The average organization now has twice as many agents as human users. Agents are the dominant consumers of the data platform, and our systems can't afford to stay the same.

Agentic SQL for Free with Qwen3.8 27B and DuckDB

Agentic SQL for Free with Qwen3.8 27B and DuckDB

Aug 28, 2026 • Alex Monahan

If your laptop has 16GB of RAM, your agent can write SQL locally for free with Qwen3.8 27B. On the DABstep SQL benchmark, Qwen beat GPT 5.6 Luna and cost under 50 cents in electricity, over 17x less. Add DuckDB and you have a data analyst that runs on your own machine. This post covers the benchmark results and walks through the setup, including which quantized model to download for your laptop.

DuckDB outgrows its nest

DuckDB outgrows its nest

Aug 26, 2026 • Jordan Tigani

Today Duck Labs, the developers of DuckDB, announced they are being acquired by Amazon. This is big news in the duck-iverse, and many people are wondering what this will mean for everyone’s favorite duck-powered database, MotherDuck.

AI Writes the Semantic Layer

AI Writes the Semantic Layer

Aug 20, 2026 • Jacob Matson, Alex Monahan

We proved that AI agents could build a semantic layer. The more interesting result was that the semantic layer itself became disposable. Q&A pairs are unreasonably effective at capturing business intent and give agents something concrete to iterate with. If code can be regenerated, where should your company accrue knowledge?

Scalable Data Apps with MotherDuck & Replit

Scalable Data Apps with MotherDuck & Replit

Aug 18, 2026 • Alex Monahan

AI agents make building data apps easy, but what about deploying them or making sure they scale? Replit provides a way for just about anyone to build real applications, and MotherDuck is the easiest way to help them scale to larger data sizes. Load data with MotherDuck Flights and you can query millions to billions of rows on the fly!

Vibe Code Data Apps with Vercel V0 & MotherDuck

Vibe Code Data Apps with Vercel V0 & MotherDuck

Aug 13, 2026 • Alex Monahan

Use an agent to build data apps with the combo of Vercel V0 and MotherDuck! V0 makes prototyping and deployment easy, while MotherDuck Flights provide seamless data ingestion and MotherDuck handles up to billions of rows. Your agent can even sign up for MotherDuck for you! See a full example app and the prompt that kickstarted it!

DuckDB Ecosystem Newsletter : August 2026

DuckDB Ecosystem Newsletter : August 2026

Aug 13, 2026 • Simon Späti

The August 2026 DuckDB Ecosystem Newsletter: giving every agent its own embedded DuckDB, the ADBC extension reaching 30+ external databases, async I/O landing in v2.0, ISO GQL graph queries, Perspective 5.0 pushdown, plus a community spotlight on Kyle Cheung.

Agents can sign up for MotherDuck

Agents can sign up for MotherDuck

Aug 10, 2026 • Adithya Krishnan, Sheila Sitaram, Garrett O'Brien

AI agents can now sign up for MotherDuck with a single API call - no forms, no credentials, no human in the loop (unless you want to be, of course). Experiment faster, share data, or just give your agents a ducking fast set of tools for analytics.

OpenAI Just Made Analytics 10x Cheaper

OpenAI Just Made Analytics 10x Cheaper

Aug 1, 2026 • Alex Monahan, Jacob Matson

Since OpenAI slashed the price of GPT 5.6 Luna by 80% this week, low latency AI-powered answers are finally feasible for less than half a penny per answer, AI and DB costs included. For data questions, GPT 5.6 Luna is intelligence too cheap to meter. Well documented context, rigorous evals, and a fast analytical engine are now the determining factors.

Context belongs in the warehouse

Context belongs in the warehouse

Jul 29, 2026 • Garrett O'Brien, Hamilton Ulmer, Till Döhmen, Jacob Matson

Introducing Guides, MotherDuck's context layer for AI agents. More accurate queries, lower token spend, and distributed context for your entire organization.

Announcing the Data Outpost Conference

Announcing the Data Outpost Conference

Jul 20, 2026 • Ryan Boyd

Data Outpost is a new conference for data and AI builders, coming to San Francisco November 4-5, 2026. The next evolution of Small Data SF: two days of workshops, talks, and real time with the people building the data layer AI depends on.

Developer Dad Does Disney: Vacationing in the Personal Software Era

Developer Dad Does Disney: Vacationing in the Personal Software Era

Jul 16, 2026 • Alex Monahan

Waiting in line is no fun! While standing in line at Disney World, a developer dad built a custom data app to pick the perfect next ride. It combines live APIs, historical wait times, and weather data into personal software with MotherDuck's MCP, Dives, and Flights.

DuckDB Ecosystem Newsletter : July 2026

DuckDB Ecosystem Newsletter : July 2026

Jul 15, 2026 • Simon Späti

July's DuckDB Ecosystem Newsletter: a portable R2 + DuckLake analytics stack, why PostHog rebuilt on DuckDB over ClickHouse, DuckCon #7 and the 1.5.4 / 1.4.5 releases, a SedonaDB WASM build for spatial SQL in the browser, and more.

Self-hosting DuckDB: the road to production

Self-hosting DuckDB: the road to production

Jul 14, 2026 • Mehdi Ouazza

A practical map of self-hosting DuckDB, from a laptop to a full data platform: the architectures people actually build at each stage, benchmarks that show the trade-offs, and the boxes you end up maintaining, so you can make an honest build-versus-buy call.

DuckLake Architecture Deep Dive

DuckLake Architecture Deep Dive

Jul 10, 2026 • Alex Monahan

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.

What if a full data platform was one prompt away?

What if a full data platform was one prompt away?

Jun 29, 2026 • Mehdi Ouazza

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.

Flight Plans: Templates for AI-Native Data Pipelines

Flight Plans: Templates for AI-Native Data Pipelines

Jun 18, 2026 • Alex Monahan

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.

Replacing Our BI Tool with Dives

Replacing Our BI Tool with Dives

Jun 16, 2026 • Carlin Eng

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.

DuckDB Ecosystem Newsletter : June 2026

DuckDB Ecosystem Newsletter : June 2026

Jun 12, 2026 • Simon Späti

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.

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

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

Jun 5, 2026 • Simon Späti

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.

Your Obsidian Vault Can Now Run SQL (and Your Agent Can Read It)

Your Obsidian Vault Can Now Run SQL (and Your Agent Can Read It)

Jun 4, 2026 • Mehdi Ouazza

Run DuckDB SQL inside your Obsidian notes and freeze the results as plain markdown tables, local files or MotherDuck cloud data alike. Your vault becomes a local knowledge base your AI agent can read without ever querying the warehouse