DuckDB, MotherDuck, Data Engineering and Data Analytics
Search and filter
Search and filter
Topic
2026/06/18 - Alex Monahan
Build full data pipelines by prompting your AI agent, no Python required. MotherDuck Flights are perfect for data ingestion, transformation, and activation. Flight Plan templates show you and your agent how to ingest from Postgres, sync Google Sheets, and send Slack alerts.
2026/06/16 - Carlin Eng
How MotherDuck replaced its BI tool in under a month using Claude Code agents: a migration that once would have taken 3 people six months and $500K.
2026/06/12 - Simon Späti
The June 2026 DuckDB Ecosystem Newsletter: a local-first ETL/ELT studio, the Quack client-server protocol and its OAuth layer, DuckLake inlining, DuckDB internals, MotherDuck Flights for agent-native ingest, plus a community spotlight on Ryan Dolley.
2026/06/12 - Simon Späti
The June 2026 DuckDB Ecosystem Newsletter: a local-first ETL/ELT studio, the Quack client-server protocol and its OAuth layer, DuckLake inlining, DuckDB internals, MotherDuck Flights for agent-native ingest, plus a community spotlight on Ryan Dolley.
2026/06/10 - Miguel Miranda, Doo Shim
Build, deploy, and schedule Python data pipelines from a prompt, a SQL function, or the MotherDuck UI.
2026/06/08 - Jacob Matson
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.
2026/06/05 - Simon Späti
Wes McKinney, creator of pandas and co-creator of Apache Arrow, shares how he works with AI coding agents: spec-driven workflows with superpowers, continuous AI code review with Roborev, token economics, and why vibe coding is dangerous but agentic engineering isn't.
2026/06/04 - Mehdi Ouazza
Run DuckDB SQL inside your Obsidian notes and freeze the results as plain markdown tables, local files or MotherDuck cloud data alike. Your vault becomes a local knowledge base your AI agent can read without ever querying the warehouse
2026/05/28 - Jerel Navarrete
DiveMaxxing is an online data viz competition for MotherDuck Dives. Three categories, duckified Mac Minis on the line, and a community vote. Free to enter through June 22.
2026/05/21 - Simon Späti
Chris Riccomini on using AI for data engineering: correctness in financial data, why LLMs should speak Substrait over SQL, the Ralph Loop for context management, security with 'Okta for Agents', and the future of the data engineer role.
2026/05/12 - Jordan Tigani
DuckDB Labs announced Quack, a client-server protocol for DuckDB. Here's why we're excited, what it means for MotherDuck, and why it's so great for the DuckDB community.
2026/05/11 - Simon Späti
DuckDB Monthly #41: Torsten's 15-week DuckDB internals course, Pete's full-text search walkthrough on a multi-GB email corpus, Mark's GCAT satellite pipeline with H3, plus column-level lineage with duck_lineage and DuckLake v1.0.
2026/04/30 - Dumky de Wilde
Track AI agent traffic that bypasses your web analytics. Stream Vercel Log Drains into MotherDuck to see how ChatGPT, Claude, and other agents browse your site.
2026/04/30 - Jacob Matson
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.
2026/04/27 - Garrett O'Brien
April 2026 at MotherDuck: Duckling compute monitoring, Embedded Dives, agent Skills, DuckLake 1.0 support, and Power BI + Tableau via the Postgres Endpoint.
2026/04/24 - Simon Späti
25 years of external tables, from Oracle 9i to DuckLake. When to use internal storage vs. external tables, why they keep getting re-added to every major data warehouse, and a benchmark showing the speed tax for cold data.
2026/04/21 - Dumky de Wilde
Build a real-time voting app on Cloudflare Workers that queries MotherDuck through the Postgres endpoint, using Durable Objects for live state and the pg package for analytical workloads.
2026/04/20 - Mehdi Ouazza, Samantha Lohier, Leonardo Vida
MotherDuck Agent Skills is an open-source catalog that teaches AI coding agents how to work with MotherDuck: exploring schemas, writing DuckDB SQL, using the REST API, and building Dives. If MCP gives agents hands, skills give them a playbook.
2026/04/17 - Simon Späti
DuckLake 1.0 ships, Lance adds vector search, Rust-native extension
2026/04/16 - Alex Monahan
MotherDuck now supports DuckLake 1.0, the open table lakehouse format designed for simplicity and low latency. Learn what's new in the 1.0 release, including data inlining, clustering, bucket partitioning, geometry and variant types, plus multi-engine support. Learn how DuckLake compares with Apache Iceberg and Delta Lake.
2026/04/15 - Jordan Tigani
In a fully agentic world, will we still need analytics at all? A particularly unhinged example might offer some clues.
2026/04/10 - Mehdi Ouazza
Five fundamental data visualization principles that transform AI-generated dashboards from pretty charts into actionable insights. Learn chart selection, design, narrative, and interactivity.
2026/04/08 - Aditya Somani
Learn how to build a text-to-SQL LLM and LangChain SQL agent with DuckDB and MotherDuck, including schema inspection, query checking, and self-correction.
2026/04/03 - Jordan Tigani
What does AI think its own impact will be on the data and analytics industry? I asked Claude to share its predictions on the Modern Data Stack, data jobs, and the future of analytics.
2026/04/02 - Garrett O'Brien, Hamilton Ulmer
Real-time, interactive data apps – now embedded anywhere in your application. Created by your favorite agents and powered by dual execution.
2026/04/01 - Jordan Tigani
2026/03/31 - Louisa Huang, Jelte Fennema-Nio, Sheila Sitaram, Garrett O'Brien
MotherDuck's Postgres endpoint lets you query your data warehouse using any PostgreSQL-compatible client, driver, or BI tool — no new dependencies needed.
2026/03/27 - Simon Späti
Mark Freeman, Head of DevRel at Gable, shares his Spec-Driven Development workflow for producing high-quality, reproducible AI outcomes using Claude Code, ExcaliDraw diagrams, JSON schemas, and agent teams with tmux.
2026/03/25 - Ryan Boyd, Mehdi Ouazza
Share interactive, AI-built data apps with anyone through a unique link — queries run live on MotherDuck compute.
2026/03/24 - Alex Monahan
Learn how MotherDuck's Hosted DuckLake combines lakehouse scale (borrowing the best ideas from Apache Iceberg and Delta Lake) with low latency and agent sandbox isolation, making it the simplest data lakehouse for AI-powered agentic workflows.
2026/03/23 - Jordan Tigani
If the Modern Data Stack isn't yet dead, it's at least incredibly sleepy. AI is bringing the "long run" closer than ever — here's what might come next for ETL, BI, data warehouses, and the role of data engineers.
2026/03/19 - Garrett O'Brien
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
SQL Transpilers, VS Code Extensions, Dives and more
2026/03/09 - Alex Monahan
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
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 - Louisa Huang, Garrett O'Brien
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
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
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
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
Comparing Git-like Tools That Separate Metadata from Data
2026/02/19 - Jordan Tigani
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
MSSQL Extension, Vortex File Format & 2TB Memory Benchmarks
2026/02/06 - Jacob Matson
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
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
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 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
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
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 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 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
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
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
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
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
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
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
CDC streaming takes flight with Artie’s new MotherDuck destination.
2025/12/10 - Simon Späti
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
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
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
Learn how to query unstructured documents with friendly SQL!
2025/11/14 - Garrett O'Brien
Dive into a recap of the world's hottest efficiency-themed data conference, Small Data SF!
2025/11/12 - Simon Späti
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
A great panel answering the most voted/commented data questions on Reddit
2025/10/28 - Jordan Tigani
Benchmarks, efficiency, and how MotherDuck just got nearly 20% faster.
2025/10/09 - Alex Monahan, Garrett O'Brien
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.
2025/10/08 - Mehdi Ouazza
Understand why a database is much more than just a dataframe library
2025/10/07 - Simon Späti
DuckDB news: v1.4.0 LTS brings AES-256 encryption, MERGE statements, and Iceberg writes. 100x faster than Spark on local Parquet. Official Docker images released.
2025/09/24 - Garrett O'Brien, Sheila Sitaram
Serverless analytics built on DuckDB, running entirely in the EU.
2025/09/09 - Patrick Garcia
Discover how Galileo.world is revolutionizing geospatial analysis. Say goodbye to slow performance and complex setups. Analyze and visualize big data right in your browser.
2025/09/09 - Simon Späti
DuckDB news: Spatial joins 58x faster via R-tree indexing. pg_duckdb 1.0 adds OLAP analytics to PostgreSQL. One team cut Snowflake costs 79% using DuckDB caching.
2025/09/03 - Jelte Fennema-Nio, Jacob Matson
PostgreSQL gets a DuckDB-flavored power-up for faster analytical queries without ever leaving Postgres.
2025/08/29 - Vasilije Markovic
SQL analytics and graph-native retrieval together, eliminating the trade-off between fast analytics and one-off RAG retrievals.