38 BLOG POSTS AND VIDEOS
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
Breaking the Excel-SQL Barrier: Leveraging DuckDB's Excel Extension
Now in MotherDuck & DuckDB, its never been easier to join in your data from spreadsheet sources.
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
24:42
2025-01-17
Using SQL in Your Data Lake with DuckDB, Iceberg, dbt, and MotherDuck
In this talk at our MotherDuck Seattle meetup, Jacob, developer advocate at MotherDuck, talked about why we should use more SQL and go hands-on with some practical examples of how to read from Iceberg using dbt, DuckDB, and MotherDuck.
dbt
Meetup
SQL
2025/01/16 - Jacob Matson
Local dev and cloud prod for faster dbt development
Spark the Joy of beautiful local development workflows with MotherDuck & dbt
2024/12/19 - Jacob Matson, Aditya Somani
Window Functions in Motherduck: An Analytical Approach
Supercharge your window functions with MotherDuck SQL
33:49
2024-11-08
A duck in the hand is worth two in the cloud
What if I told you that you could complete a JSON parse and extract task on your laptop before a distributed compute cluster even finishes booting up?
YouTube
BI & Visualization
AI, ML and LLMs
SQL
Python
Talk
2024/11/01 - Jacob Matson
The Data Warehouse powered by DuckDB SQL
Learn how DuckDB and MotherDuck transform data into business insights. DuckDB’s fast SQL processing meets MotherDuck’s cloud integration, creating a flexible, powerful data warehouse solution to solve complex business challenges and drive impact.
