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.
67 BLOG POSTS AND VIDEOS
51:58
Build a Data Agent in 60 Minutes
Oct 1, 2026 • Jacob Matson
Jacob Matson walks through a working data chat agent he built: MCP tools, an agentic loop, a tuned system prompt, hard-coded read-only guardrails, and telemetry. He demos it live against a real dataset, walks through the actual codebase, then shows the same backend re-platformed into a Slack bot.
Stream
MotherDuck Features
AI, ML and LLMs
Data Pipelines
49:02
prompt_jev(): SQL-Native Text Classification
Sep 29, 2026 • Hamilton Ulmer, Dumky de Wilde, Jacob Matson
MotherDuck's new prompt_jev() function runs text classification directly from SQL using Jev, a decision-focused model from typesafe.ai. In a live demo, Jacob Matson, Dumky de Wilde, and Hamilton Ulmer showed it filtering, disambiguating, and re-ranking real data without leaving SQL. The number they kept coming back to: 100,000 rows classified at 89% accuracy in 40 seconds, compared to 32 minutes and $37.58 for a comparable LLM call.
Stream
MotherDuck Features
AI, ML and LLMs
Data Pipelines
Introducing prompt_jev(): bringing Jev to Motherduck SQL
Sep 21, 2026 • Hamilton Ulmer, Till Döhmen, Jacob Matson
Classify text in SQL with prompt_jev(), powered by TypeSafe's Jev. 100,000 rows labeled in 40 seconds for $0.50 at frontier-LLM accuracy. Live on paid plans.
47:43
Data takes Flight: Transforming Data with Spark and MotherDuck via Iceberg
Sep 10, 2026 • Colin Rogers, Jacob Matson
See a live cross-engine pipeline: Spark transcribes audio and writes to Iceberg, then MotherDuck attaches that catalog directly as a queryable database.
Stream
Data Pipelines
dbt
Ecosystem
60:29
Do AI Agents Need a Semantic Layer?
Aug 26, 2026 • Alex Monahan, Jacob Matson
Do AI agents need a semantic layer? Evals comparing plain-text context with a Malloy semantic layer show where each wins, and what it costs.
Stream
AI, ML and LLMs
BI & Visualization
SQL
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?
63:17
Beyond Copilots: We're Building a Data Stack Live with AI Agents
Aug 18, 2026 • Jacob Matson
Agentic data engineering in practice: AI agents build dlt ingestion into MotherDuck and a governed Lightdash semantic layer, live in an hour.
Stream
AI, ML and LLMs
Data Pipelines
Ecosystem
52:23
Trust the agents you build on your data
Aug 12, 2026 • Jacob Matson
Learn how to evaluate AI agents that query your data: run text-to-SQL evals with Braintrust and MotherDuck, read traces, and fix failures with context.
Webinar
AI, ML and LLMs
SQL
Ecosystem
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
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.
1:00:37
BI Is Having a Midlife Crisis
Jul 28, 2026 • Jacob Matson, Ryan Dolley
Jacob Matson and BI analyst Ryan Dolley on whether AI can replace your BI tool, what it actually solves, and what still needs governance.
Interview
BI & Visualization
AI, ML and LLMs
41:19
Streaming Made Easy: Practical Postgres CDC with Streamkap + MotherDuck
Jul 14, 2026 • Jacob Matson, Paul Dudley
Learn when Postgres CDC is worth it, what breaks it (WAL logs, replication slots, schema changes), and see a live Postgres-to-MotherDuck pipeline.
Webinar
Data Pipelines
Ecosystem
AI, ML and LLMs
What makes a great Dive? What DiveMaxxing taught us
Jun 24, 2026 • Jerel Navarrete, Jacob Matson
The DiveMaxxing winners, and what 48 community Dives taught us about what separates a great data visualization from one that just looks polished.
46:45
What Makes a Great Data Viz? DiveMaxxing Winners Revealed
Jun 24, 2026 • Hamilton Ulmer, Brittany Rosenau, Zack Mazzoncini, Jacob Matson
What makes a great data visualization in the AI era? Three viz experts judge the DiveMaxxing winners and break down what separates great from busy.
Webinar
BI & Visualization
AI, ML and LLMs
36:45
From Source to Dashboard: Real Pipelines with Flights
Jun 23, 2026 • Jacob Matson
Watch an AI agent build a data pipeline end to end in MotherDuck Flights: ingest, transform, and schedule it, then wire it into a live Dive dashboard.
Webinar
AI, ML and LLMs
Data Pipelines
MotherDuck Features
BI & Visualization
The Surprising Truth About AI-Native Semantic Layers
Jun 8, 2026 • Jacob Matson
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.
1:00:00
How Top E-Commerce Data Teams Drive Revenue with LLMs
May 28, 2026 • Jacob Matson, Daniel Pham
See how e-commerce data teams use LLMs and MotherDuck to go from a plain-language business question to a published, interactive analysis in minutes.
Webinar
AI, ML and LLMs
BI & Visualization
47:05
Data Engineering Is AI Engineering
May 26, 2026 • Jacob Matson
Jacob Matson refactors a real NBA app with AI agent teams, revealing how data engineering patterns like DAGs and wave planning map directly to agent orchestration.
Webinar
AI, ML and LLMs
Data Pipelines
42:00
Agentic Data Engineering: Building Pipelines End-to-End with AI
May 19, 2026 • Jacob Matson, Hugo Lu
Watch an AI agent build a full data pipeline from scratch: ingestion with DLT, orchestration in Orchestra, staging and snapshots in MotherDuck, and a Dive for visual output.
Webinar
AI, ML and LLMs
Data Pipelines
MotherDuck Features
Vibe Coding has come for BI
Apr 30, 2026 • Jacob Matson
The agent writes the SQL and the data viz now. Here's what's still your job — and how to implement data-layer changes that took a very hard natural language to SQL benchmark from 30% to 93% accuracy with Gemini Flash.
46:11
A Practical Guide to Context Management for Data Agents
Apr 23, 2026 • Jacob Matson, Peter Chapman
Learn to write effective context for data agents. Covers benchmarks comparing English, SQL, and semantic model formats plus scaling strategies.
Webinar
AI, ML and LLMs
58:00
What's New in DuckDB 1.5!
Apr 7, 2026 • Alex Monahan, Jacob Matson
Alex Monahan and Jacob Matson walk through DuckDB 1.5's biggest features including the VARIANT type, redesigned CLI, built-in GEOMETRY, and faster joins.
Webinar
38:23
Agents That Build Tables, Not Just Query Them
Mar 17, 2026 • Jerel Navarrete, Jacob Matson
See how MotherDuck's new query_rw MCP tool lets AI agents write back to your data warehouse, creating tables, storing embeddings, and saving views.
Stream
AI, ML and LLMs
MotherDuck Features
SQL
1:00:01
Text-to-SQL, Data Modeling for LLMs, MCP, and Dives with Jacob Matson
Mar 12, 2026 • Jacob Matson, Ryan Dolley
Jacob Matson covers text-to-SQL accuracy, why data models matter more than LLM choice, the MotherDuck MCP workflow, and Dives on Super Data Brothers.
Interview
AI, ML and LLMs
SQL
MotherDuck Features
1:00:14
Building an Analytics Chatbot for your SaaS app in 1 day
Mar 11, 2026 • Ryan Boyd, Jerel Navarrete, Jacob Matson
Learn how to build a conversational AI chatbot for your SaaS product using the MotherDuck MCP server, with scoped data access and streaming responses.
Webinar
AI, ML and LLMs
Tutorial
MotherDuck Features
How I dive - Claude.ai Edition
Feb 25, 2026 • Jacob Matson
Explore first, find the story, iterate on the artifact, test in MotherDuck. The workflow I keep coming back to after weeks of building.
1:00:10
Shareable visualizations built by your favorite agent
Feb 25, 2026 • Jacob Matson, Garrett O'Brien
You know the pattern: someone asks a question, you write a query, share the results — and a week later, the same question comes back. Watch this webinar to see how MotherDuck is rethinking how questions become answers, with AI agents that build and share interactive data visualizations straight from live queries.
Webinar
AI ML and LLMs
MotherDuck Features
Does "AI-Ready Data" simply mean "Good Data Modeling"?
Feb 6, 2026 • Jacob Matson
I ran 500 text-to-SQL questions against three frontier LLMs with zero context beyond the schema. 95% accuracy. No semantic layer required.
Preparing Your Data Warehouse for AI: Let Your Agents Cook
Jan 27, 2026 • Jerel Navarrete, Jacob Matson
Jacob and Jerel from MotherDuck showcase practical ways to optimize your data warehouse for AI-powered SQL generation. Through rigorous testing with the Bird benchmark, they demonstrate that text-to-SQL accuracy can jump from 30% to 74% by enriching your database with the right metadata.
AI, ML and LLMs
SQL
MotherDuck Features
Stream
Tutorial
SQL Golf: Lessons from Quackmas 2025
Jan 23, 2026 • Jacob Matson
From #N column references to boolean math, explore the extreme techniques used to solve the Quackmas 2025 SQL Golf challenge.
The MCP Sessions - Vol 2: Supply Chain Analytics
Jan 21, 2026 • Jacob Matson, Alex Monahan
Jacob and Alex from MotherDuck query data using the MotherDuck MCP. Watch as they analyze 180,000 rows of shipment data through conversational AI, uncovering late delivery patterns, profitability insights, and operational trends with no SQL required!
Stream
AI, ML and LLMs
MotherDuck Features
SQL
BI & Visualization
Tutorial
The MCP Sessions Vol. 1: Sports Analytics
Jan 13, 2026 • Jacob Matson, Logan Toskey
Watch us dive into NFL playoff odds and PGA Tour stats using using MotherDuck's MCP server with Claude. See how to analyze data, build visualizations, and iterate on insights in real-time using natural language queries and DuckDB.
AI, ML and LLMs
SQL
MotherDuck Features
Tutorial
BI & Visualization
Ecosystem
Building a Serverless Lakehouse with DuckLake
Dec 26, 2025 • Jacob Matson
In this hands-on workshop, Jacob Matson walks through building a serverless lakehouse from scratch using DuckLake.
Webinar
Tutorial
What If We Don't Need the Semantic Layer?
Dec 23, 2025 • Jacob Matson
What if AI could discover your business logic by mining query history instead of requiring manual metric definitions? Explore how LLMs are replacing static semantic layers with systems that learn from actual usage.
MotherDuck Integrates with PlanetScale Postgres
Dec 16, 2025 • Garrett O'Brien, Jacob Matson
Run analytics 200x faster on PlanetScale Postgres with MotherDuck integration. Keep millisecond transactions while pushing analytical queries to serverless compute.
