--- title: "Jacob Matson - MotherDuck Blog" description: "Jacob joined MotherDuck after a career as a startup operator in finance and data roles." canonical: "https://motherduck.com/authors/jacob-matson/" --- # Jacob Matson Jacob Matson's photo Dev Advocate at MotherDuck Jacob joined MotherDuck after a career as a startup operator in finance and data roles. ## 59 BLOG POSTS AND VIDEOS [2026/08/20 - Jacob Matson, Alex Monahan](/blog/AI-writes-the-semantic-layer/) ### [AI Writes the Semantic Layer](/blog/AI-writes-the-semantic-layer) 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? [2026/08/01 - Alex Monahan, Jacob Matson](/blog/openai-just-made-analytics-10x-cheaper/) ### [OpenAI Just Made Analytics 10x Cheaper](/blog/openai-just-made-analytics-10x-cheaper) 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. [2026/07/29 - Garrett O'Brien, Hamilton Ulmer, Till Döhmen, Jacob Matson](/blog/context-belongs-in-the-warehouse/) ### [Context belongs in the warehouse](/blog/context-belongs-in-the-warehouse) 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](/videos/bi-midlife-crisis-ai/)[2026-07-28](/videos/bi-midlife-crisis-ai/) ### [BI Is Having a Midlife Crisis](/videos/bi-midlife-crisis-ai/) 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](/videos/postgres-cdc-streamkap-motherduck/)[2026-07-14](/videos/postgres-cdc-streamkap-motherduck/) ### [Streaming Made Easy: Practical Postgres CDC with Streamkap + MotherDuck](/videos/postgres-cdc-streamkap-motherduck/) 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 [2026/06/24 - Jerel Navarrete, Jacob Matson](/blog/what-makes-a-great-dive-divemaxxing/) ### [What makes a great Dive? What DiveMaxxing taught us](/blog/what-makes-a-great-dive-divemaxxing) 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](/videos/what-makes-great-data-visualization/)[2026-06-24](/videos/what-makes-great-data-visualization/) ### [What Makes a Great Data Viz? DiveMaxxing Winners Revealed](/videos/what-makes-great-data-visualization/) 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](/videos/build-data-pipeline-ai-agent-flights/)[2026-06-23](/videos/build-data-pipeline-ai-agent-flights/) ### [From Source to Dashboard: Real Pipelines with Flights](/videos/build-data-pipeline-ai-agent-flights/) 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 [2026/06/08 - Jacob Matson](/blog/oops-maybe-we-do-need-semantic-layers/) ### [The Surprising Truth About AI-Native Semantic Layers](/blog/oops-maybe-we-do-need-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. [1:00:00](/videos/ecommerce-data-teams-llms-revenue/)[2026-05-28](/videos/ecommerce-data-teams-llms-revenue/) ### [How Top E-Commerce Data Teams Drive Revenue with LLMs](/videos/ecommerce-data-teams-llms-revenue/) 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](/videos/data-engineering-ai-engineering/)[2026-05-26](/videos/data-engineering-ai-engineering/) ### [Data Engineering Is AI Engineering](/videos/data-engineering-ai-engineering/) 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](/videos/agentic-data-engineering-pipelines-ai/)[2026-05-19](/videos/agentic-data-engineering-pipelines-ai/) ### [Agentic Data Engineering: Building Pipelines End-to-End with AI](/videos/agentic-data-engineering-pipelines-ai/) 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 [2026/04/30 - Jacob Matson](/blog/vibe-coding-comes-for-bi/) ### [Vibe Coding has come for BI](/blog/vibe-coding-comes-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](/videos/context-management-data-agents/)[2026-04-23](/videos/context-management-data-agents/) ### [A Practical Guide to Context Management for Data Agents](/videos/context-management-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](/videos/whats-new-duckdb-15/)[2026-04-07](/videos/whats-new-duckdb-15/) ### [What's New in DuckDB 1.5!](/videos/whats-new-duckdb-15/) 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](/videos/motherduck-mcp-write-agent-sql/)[2026-03-17](/videos/motherduck-mcp-write-agent-sql/) ### [Agents That Build Tables, Not Just Query Them](/videos/motherduck-mcp-write-agent-sql/) 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](/videos/text-to-sql-data-modeling-llms-mcp-dives/)[2026-03-12](/videos/text-to-sql-data-modeling-llms-mcp-dives/) ### [Text-to-SQL, Data Modeling for LLMs, MCP, and Dives with Jacob Matson](/videos/text-to-sql-data-modeling-llms-mcp-dives/) 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](/videos/building-ai-chatbot-saas-mcp/)[2026-03-11](/videos/building-ai-chatbot-saas-mcp/) ### [Building an Analytics Chatbot for your SaaS app in 1 day](/videos/building-ai-chatbot-saas-mcp/) 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 [2026/02/25 - Jacob Matson](/blog/how-i-dive-claude-ai/) ### [How I dive - Claude.ai Edition](/blog/how-i-dive-claude-ai) 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](/videos/ai-agent-shareable-visualizations/)[2026-02-25](/videos/ai-agent-shareable-visualizations/) ### [Shareable visualizations built by your favorite agent](/videos/ai-agent-shareable-visualizations/) 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](/blog/bird-bench-and-data-models/) ### [Does "AI-Ready Data" simply mean "Good Data Modeling"?](/blog/bird-bench-and-data-models) 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](/videos/preparing-data-warehouse-for-ai/) ### [Preparing Your Data Warehouse for AI: Let Your Agents Cook](/videos/preparing-data-warehouse-for-ai/) 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](/blog/its-a-sql-golf-quackmas/) ### [SQL Golf: Lessons from Quackmas 2025](/blog/its-a-sql-golf-quackmas) From #N column references to boolean math, explore the extreme techniques used to solve the Quackmas 2025 SQL Golf challenge. [2026-01-21](/videos/mcp-sessions-supply-chain-analytics/) ### [The MCP Sessions - Vol 2: Supply Chain Analytics](/videos/mcp-sessions-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](/videos/mcp-sports-analytics-claude-motherduck/) ### [The MCP Sessions Vol. 1: Sports Analytics](/videos/mcp-sports-analytics-claude-motherduck/) 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](/videos/building-serverless-lakehouse-with-ducklake/) ### [Building a Serverless Lakehouse with DuckLake](/videos/building-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](/blog/who-needs-a-semantic-layer-anyway/) ### [What If We Don't Need the Semantic Layer?](/blog/who-needs-a-semantic-layer-anyway) 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](/blog/motherduck-planetscale-integration/) ### [MotherDuck Integrates with PlanetScale Postgres](/blog/motherduck-planetscale-integration) 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](/blog/quackmas2025/) ### [Calling All SQL Sleuths: The Christmas Heist Awaits](/blog/quackmas2025) Christmas presents have vanished! Use your SQL skills to solve the mystery on DBQuacks and win prizes. 15 challenges. One leaderboard. [2025-11-20](/videos/going-beyond-the-dataframe/) ### [Data-based: Going Beyond the Dataframe](/videos/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](/videos/smarter-ai-workflows-with-hex-motherduck/) ### [Empowering Data Teams: Smarter AI Workflows with Hex & MotherDuck](/videos/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](/webinar/building-an-efficient-data-stack/) ### [Duck Flavored BI: Building an Efficient Data Stack](//webinar/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](/videos/ducklake-big-data-small-coalesce-2025/) ### [DuckLake: Making BIG DATA feel small (Coalesce 2025)](/videos/ducklake-big-data-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](/webinar/from-raw-data-to-insights/) ### [From Raw Data to Insights with Datacoves & MotherDuck](//webinar/from-raw-data-to-insights) 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](/videos/from-curiosity-to-impact-how-dosomething-democratized-data/) ### [From Curiosity to Impact How DoSomething Democratized Data](/videos/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](/blog/pg-duckdb-release/) ### [Announcing Pg_duckdb Version 1.0](/blog/pg-duckdb-release) PostgreSQL gets a DuckDB-flavored power-up for faster analytical queries without ever leaving Postgres. ## SUBSCRIBE ### Subscribe to MotherDuck Blog Also subscribe to other MotherDuck updates Submit