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.
45 BLOG POSTS AND VIDEOS
2026/04/30 - Jacob Matson
Vibe Coding has come for BI
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.
7:14
2026-04-23
A Practical Guide to Context Management for Data Agents
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
2026-04-07
What's New in DuckDB 1.5!
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
2026-03-17
Agents That Build Tables, Not Just Query Them
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
2026/02/25 - Jacob Matson
How I dive - Claude.ai Edition
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
2026-02-25
Shareable visualizations built by your favorite agent
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
2026/02/06 - Jacob Matson
Does "AI-Ready Data" simply mean "Good Data Modeling"?
I ran 500 text-to-SQL questions against three frontier LLMs with zero context beyond the schema. 95% accuracy. No semantic layer required.
2026-01-27
Preparing Your Data Warehouse for AI: Let Your Agents Cook
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
2026/01/23 - Jacob Matson
SQL Golf: Lessons from Quackmas 2025
From #N column references to boolean math, explore the extreme techniques used to solve the Quackmas 2025 SQL Golf challenge.
2026-01-21
The MCP Sessions - Vol 2: Supply Chain Analytics
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
2026-01-13
The MCP Sessions Vol. 1: Sports Analytics
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
2025-12-26
Building a Serverless Lakehouse with DuckLake
In this hands-on workshop, Jacob Matson walks through building a serverless lakehouse from scratch using DuckLake.
Webinar
Tutorial
2025/12/23 - Jacob Matson
What If We Don't Need the Semantic Layer?
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.
2025/12/16 - Garrett O'Brien, Jacob Matson
MotherDuck Integrates with PlanetScale Postgres
Run analytics 200x faster on PlanetScale Postgres with MotherDuck integration. Keep millisecond transactions while pushing analytical queries to serverless compute.
2025/12/12 - Jacob Matson
Calling All SQL Sleuths: The Christmas Heist Awaits
Christmas presents have vanished! Use your SQL skills to solve the mystery on DBQuacks and win prizes. 15 challenges. One leaderboard.
2025-11-20
Data-based: Going Beyond the Dataframe
Learn how to turbocharge your Python data work using DuckDB and MotherDuck with Pandas. We walk through performance comparisons, exploratory data analysis on bigger datasets, and an end-to-end ML feature engineering pipeline.
Webinar
Python
AI, ML and LLMs
2025-11-14
Empowering Data Teams: Smarter AI Workflows with Hex & MotherDuck
AI isn't here to replace data work, it's here to make it better. Watch this webinar to see how Hex and MotherDuck build AI workflows that prioritize context, iteration, and real-world impact.
Webinar
AI, ML and LLMs
2025-10-29
Duck Flavored BI: Building an Efficient Data Stack
Temptation to over-engineer your data stack is everywhere. Watch MotherDuck and Tasman Analytics for the antidote: a practical discussion of why companies try to overbuild and what they can do to resist the temptation.
Webinar
2025-10-14
DuckLake: Making BIG DATA feel small (Coalesce 2025)
MotherDuck’s managed DuckLake data lakehouse blends the cost efficiency, scale, and openness of a lakehouse with the speed of a warehouse for truly joyful dbt pipelines. They will show you how!
Talk
2025-09-25
From Raw Data to Insights with Datacoves & MotherDuck
In this webinar, we show how Datacoves and MotherDuck make it possible to connect directly to S3, build dbt models in DuckLake, and visualize the results without the heavy lift of traditional data stacks.
Webinar
dbt
2025-09-10
From Curiosity to Impact How DoSomething Democratized Data
Hear how DoSomething's data team escaped the enterprise data trap, achieving 20X cost reduction and transforming hours-long queries into seconds with MotherDuck.
YouTube
2025/09/03 - Jelte Fennema-Nio, Jacob Matson
Announcing Pg_duckdb Version 1.0
PostgreSQL gets a DuckDB-flavored power-up for faster analytical queries without ever leaving Postgres.
2025/08/22 - Jacob Matson
Nine Keyboard Shortcuts for SQL Flow State
Tired of clicking? Master 9 essential SQL keyboard shortcuts to achieve a true flow state and make your data analysis faster and more joyful. Learn to run queries, comment, format, and even use AI without leaving your keyboard.
2025/08/04 - Jacob Matson, Alex Monahan
Just Enough SQL to be Dangerous with AI
Learn essential SQL to verify AI-generated queries. Master SELECT, JOIN, and CTEs to safely analyze data with LLMs. Includes DuckDB examples and safety tips
2025-07-26
How to Efficiently Load Data into DuckLake with Estuary
Learn how DuckLake, MotherDuck, and Estuary enable fast, real-time data integration and analytics with modern open table formats, cloud data warehousing, and no-code streaming pipelines.
YouTube
2025/07/25 - Hamilton Ulmer, Jacob Matson
MotherDuck's Latest AI Features: Smarter SQL Error Fixes and Natural Language Editing
Stay in flow with MotherDuck's latest features. Real-time SQL feedback and natural language editing.
2025/06/27 - Jacob Matson
I Made Cursor + AI Write Perfect SQL. Here's the Exact Setup
Stop debugging AI-generated SQL queries. Learn the exact Cursor + MotherDuck setup that makes AI write working SQL on the first try, with step-by-step instructions.
2025-06-26
Getting Started With MotherDuck Hosted DuckLake
Watch this special edition of our Getting Started with MotherDuck webinar where we'll cover how to use DuckLake with MotherDuck.
Webinar
2025/06/16 - Jacob Matson, Aditya Somani
PostgreSQL and Ducks: The Perfect Analytical Pairing
Learn how to integrate PostgreSQL with DuckDB and MotherDuck for faster analytics. Compare DuckDB Postgres Extension, pg_duckdb, and CDC approaches with practical examples and best practices for each method.
2025/05/27 - Jacob Matson
DuckDB Excel Extension: How to Read, Write, and Import XLSX Files
Learn how to use the DuckDB Excel extension to directly read, import, and write XLSX files using the read_xlsx function. Plus, MotherDuck tips.
2025-05-21
Stay in Flow with MotherDuck's Instant SQL
Imagine writing SQL queries that give you instant visual feedback, transforming your entire data exploration experience. That's what Instant SQL enables with MotherDuck.
YouTube
2025/05/06 - Jacob Matson
MotherDuck lands on Tableau Cloud: Live, Fast Analytics Unleashed
Use MotherDuck to power your Tableau Cloud, Server, and Desktop dashboards.
2025-04-22
More Than a Vibe: AI-Driven SQL That Actually Works
Jacob Matson shares insights from AI-powered spatial data analysis, exploring how to "vibe code" with AI-generated SQL using MotherDuck and DuckDB for real-world decision-making scenarios.
Talk
AI, ML and LLMs
2025-04-10
4 Lightning Talks on Practical AI Workflows from Notion, 1Password, MotherDuck & Evidence
Learn how data teams at MotherDuck, Notion, 1Password, and Evidence use AI tools to automate workflows, enrich data, speed up BI development, and enhance documentation.
YouTube
2025/03/07 - Jacob Matson, Andrew Witten
Using MotherDuck at MotherDuck: Loading Data from Postgres with DuckDB
Duckfooding MotherDuck with the postgres scanner
