MOTHERDUCK BLOG

DuckDB, MotherDuck, Data Engineering and Data Analytics

Search and filter

Search and filter

Topic

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.

Subscribe to MotherDuck Blog

Blog subscription card section illustration
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.

MotherDuck Integrates with PlanetScale Postgres

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.

Calling All SQL Sleuths: The Christmas Heist Awaits

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.

Streaming Pipelines with MotherDuck and Artie

2025/12/11 - Garrett O'Brien

Streaming Pipelines with MotherDuck and Artie

CDC streaming takes flight with Artie’s new MotherDuck destination.

This Month in the DuckDB Ecosystem: December 2025

2025/12/10 - Simon Späti

This Month in the DuckDB Ecosystem: December 2025

DuckDB ecosystem December roundup: encryption in v1.4, new spatial tools, DuckLake serverless lakehouse, Reddit Q&A with data engineers, and community highlights.

Simplicity of a Database, but the Speed of a Cache: OLAP Caches for DuckDB

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.

Branch, Test, Deploy: A Git-Inspired Approach for Data

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.

Small Data SF 2025: the Recap!

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!

DuckDB Ecosystem: November 2025

2025/11/12 - Simon Späti

DuckDB Ecosystem: November 2025

DuckDB Monthly #35: DuckDB extensions, DuckLake, DataFrame, and more!

4 Senior Data Engineers Answer 10 Top Reddit Questions

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

Faster Ducks

2025/10/28 - Jordan Tigani

Faster Ducks

Benchmarks, efficiency, and how MotherDuck just got nearly 20% faster.

DuckDB 1.4.1 and DuckLake 0.3 Land in MotherDuck: New SQL Syntax, Iceberg Interoperability, and Performance Gains

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.