MOTHERDUCK BLOG
DuckDB, MotherDuck, Data Engineering and Data Analytics
Search and filter
Search and filter
Topic
2026/03/19 - Garrett O'Brien
Claudeception: Inside the Mind of an Analytics Agent
More tool calls, more schema exploration, more verification — does it help, or hurt? We dug into the chain-of-thought traces behind one of the hardest text-to-SQL benchmarks to understand how analytics agents actually think.
2026/03/13 - Simon Späti
DuckDB Ecosystem Newsletter – March 2026
SQL Transpilers, VS Code Extensions, Dives and more
2026/03/09 - Alex Monahan
DuckDB 1.5 Features I am Excited About
DuckDB 1.5 is both faster and easier to use! JSON analysis can be up to 100x faster thanks to the VARIANT type and JSON shredding. Real-world queries are faster, including both basic and complex queries. Writes to Azure are supported, and checkpoint concurrency is dramatically improved.
2026/03/09 - Alex Monahan
DuckDB 1.5 Features I am Excited About
DuckDB 1.5 is both faster and easier to use! JSON analysis can be up to 100x faster thanks to the VARIANT type and JSON shredding. Real-world queries are faster, including both basic and complex queries. Writes to Azure are supported, and checkpoint concurrency is dramatically improved.
2026/03/06 - Mehdi Ouazza
What is MCP? A Data Person's Guide to Agentic Analytics
MCP explained for data people: what it is, how it works, and how to connect your AI agent to your databases and tools
2026/03/05 - Garrett O'Brien, Louisa Huang
Dashboards as Code : CI/CD For MotherDuck Dives
Local development, version control, and automated CI/CD deployments for MotherDuck Dives — composable data visualizations that are just code.
2026/03/03 - Garrett O'Brien
Give Your Agents Write Access
The MotherDuck remote MCP server now supports write operations. Learn how zero-copy clones, snapshots, and hypertenancy make it safe to let agents build in your data warehouse.
2026/03/02 - Alex Monahan
Claude Code + Dives = Any data UI
Learn how to build custom interactive data visualizations using MotherDuck Dives and Claude Code. From setup to sharing, create refreshable React and SQL-powered visuals with natural language prompts.
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.
2026/02/24 - Simon Späti
Git for Data Applied: Comparing Git-like Tools That Separate Metadata from Data
Comparing Git-like Tools That Separate Metadata from Data
2026/02/19 - Jordan Tigani
Duck, Dive, and Answer
AI is eating the data stack. Introducing Dives, a new MotherDuck feature that lets AI agents build shareable, real-time data visualizations with composable SQL.
2026/02/11 - Simon Späti
DuckDB Ecosystem Newsletter – February 2026
MSSQL Extension, Vortex File Format & 2TB Memory Benchmarks
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/02/05 - Simon Späti
Building an Obsidian RAG with DuckDB and MotherDuck
Build a local-first RAG for your Obsidian notes using DuckDB's vector search, then deploy it as a serverless web app with MotherDuck
2026/02/04 - Sheila Sitaram, Joseph Hwang, Nicholas Greenspan
More Control, Less Hassle: Self-Serve Recovery with Point-in-Time Restore
MotherDuck now supports point-in-time restores, making it easier than ever to roll back changes, undrop databases, and debug pipelines.
2026/02/02 - Dumky de Wilde
Microbatch: how to supercharge dbt-duckdb with the right incremental model
Microbatch support in dbt-duckdb lets you process large tables in time-based batches — making incremental models recoverable, backfillable, and parallelizable without rebuilding from scratch.
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/17 - Simon Späti
This Month in the DuckDB Ecosystem: January 2026
DuckDB news: Iceberg extension adds full DML (INSERT/UPDATE/DELETE). Process 1TB in 30 seconds. Query data via AI agents with MCP server. TypeScript macros for APIs.
2025/12/29 - Hannah Rifkin
We Built Our Employees a Wrapped—Using SQL and MotherDuck
We built a Spotify-style "Wrapped" for MotherDuck employees using our own platform. Discover the SQL queries, data tricks, and fun personas behind our internal leaderboard.
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/22 - Carly Spoljaric, Jerel Navarrete
A Quack-Packed Fall
MotherDuck spent fall on the conference circuit across Europe and the US. Here's what we presented and the pattern that emerged in nearly every conversation about analytics.
2025/12/19 - Ryan Boyd
Stop Paying the Complexity Tax
My personal reflections from watching Jordan Tigani’s keynote "The Unbearable Bigness of Small Data" at Small Data SF. Most data warehouses are overbuilt for scale you'll never need. Learn how to stop paying the complexity tax.
2025/12/18 - Till Döhmen
Building the MotherDuck Remote MCP Server: A Journey Through Context Engineering and OAuth Proxies
How MotherDuck built a production-ready remote MCP server—from OAuth proxy challenges with Auth0 to tool design patterns that help AI agents query data warehouses effectively. Includes lessons from a hackathon where agents ran 4,000+
2025/12/17 - Jordan Tigani
Building an answering machine
Discover how MotherDuck's MCP server enables true self-service analytics through AI agents. Query data in plain English with Claude, ChatGPT, or Gemini—no SQL required.
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/12/11 - Garrett O'Brien
Streaming Pipelines with MotherDuck and Artie
CDC streaming takes flight with Artie’s new MotherDuck destination.
2025/12/10 - Simon Späti
This Month in the DuckDB Ecosystem: December 2025
DuckDB news: v1.4 adds AES-256 encryption. DuckLake brings ACID-compliant lakehouse with time-travel queries. Gaggle extension queries Kaggle datasets directly via SQL.
2025/12/03 - Simon Späti
Simplicity of a Database, but the Speed of a Cache: OLAP Caches for DuckDB
Speed up slow dashboards without adding new infrastructure. Learn how DuckDB's caching extensions can drop query times from minutes to seconds.
2025/11/24 - Simon Späti
Branch, Test, Deploy: A Git-Inspired Approach for Data
This article explores how to bring Git style workflows like branching, testing, and deploying to your data stack. Learn how concepts like zero copy cloning and metadata pointers can finally give you isolated test environments.
2025/11/19 - Diptanu Gon Choudhury
Unstructured Document Analysis with Tensorlake and MotherDuck
Learn how to query unstructured documents with friendly SQL!
2025/11/14 - Garrett O'Brien
Small Data SF 2025: the Recap!
Dive into a recap of the world's hottest efficiency-themed data conference, Small Data SF!
2025/11/12 - Simon Späti
DuckDB Ecosystem: November 2025
DuckDB news: QuackStore caching cuts query time from 49s to 3s. Infera runs ONNX ML models in SQL. 127 community extensions analyzed. DuckLake architecture explained.
2025/10/30 - Simon Späti
4 Senior Data Engineers Answer 10 Top Reddit Questions
A great panel answering the most voted/commented data questions on Reddit
2025/10/28 - Jordan Tigani
Faster Ducks
Benchmarks, efficiency, and how MotherDuck just got nearly 20% faster.
2025/10/09 - Alex Monahan, Garrett O'Brien
DuckDB 1.4.1 and DuckLake 0.3 Land in MotherDuck: New SQL Syntax, Iceberg Interoperability, and Performance Gains
MotherDuck now supports DuckDB 1.4.1 and DuckLake 0.3, with new SQL syntax, faster sorting, Iceberg interoperability, and more. Read on for the highlights from these major releases.
