MOTHERDUCK BLOG

DuckDB, MotherDuck, Data Engineering and Data Analytics

Search and filter

Search and filter

Topic

Give Your Agents Write Access

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.

Claude Code + Dives = Any data UI

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.

Subscribe to MotherDuck Blog

How I dive - Claude.ai Edition

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.

Duck, Dive, and Answer

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.

DuckDB Ecosystem Newsletter – February 2026

2026/02/11 - Simon Späti

DuckDB Ecosystem Newsletter – February 2026

MSSQL Extension, Vortex File Format & 2TB Memory Benchmarks

Does "AI-Ready Data" simply mean "Good Data Modeling"?

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.

Building an Obsidian RAG with DuckDB and MotherDuck

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

More Control, Less Hassle: Self-Serve Recovery with Point-in-Time Restore

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.

SQL Golf: Lessons from Quackmas 2025

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.

This Month in the DuckDB Ecosystem: January 2026

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.

We Built Our Employees a Wrapped—Using SQL and MotherDuck

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.

What If We Don't Need the Semantic Layer?

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.

A Quack-Packed Fall

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.

Stop Paying the Complexity Tax

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.

Building the MotherDuck Remote MCP Server: A Journey Through Context Engineering and OAuth Proxies

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+

Building an answering machine

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.