MOTHERDUCK BLOG
DuckDB, MotherDuck, Data Engineering and Data Analytics
Search and filter
Search and filter
Topic
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.
Subscribe to MotherDuck Blog
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!
