2026/09/10 - Mehdi Ouazza
Why DuckDB 2.0 is faster
DuckDB 2.0 alpha vs 1.5.5 on one laptop: recursive CTEs up to 90x, VARIANT 6x faster than JSON text, async I/O 2.4x on S3. What changes, and how to model data to get the speedup.
102 BLOG POSTS AND VIDEOS
2026/08/27 - Mehdi Ouazza, MotherDuck team
MotherDuck CLI: query, pipelines, and dashboards from your terminal
Meet the MotherDuck CLI: one install to query data, publish Python pipelines, and host dashboards from your terminal, for coding agents and CI alike.
2026/08/04 - Mehdi Ouazza
I let an agent sign itself up to a cloud data warehouse, then replayed every step
AI agents can now provision a Postgres database, an email inbox or a data warehouse with no signup and no credit card. Here is how MotherDuck's agent signup endpoint works, and how motherduck.com/try lets you inspect, share and replay everything the agent did.
41:41
2026-07-22
Writing robust data pipelines with AI
AI writes data pipelines in seconds, but green isn't correct. Build robust data pipelines with AI: eyes on data, foundations, tests, and contracts.
Webinar
Data Pipelines
AI, ML and LLMs
MotherDuck Features
2026/07/14 - Mehdi Ouazza
Self-hosting DuckDB: the road to production
A practical map of self-hosting DuckDB, from a laptop to a full data platform: the architectures people actually build at each stage, benchmarks that show the trade-offs, and the boxes you end up maintaining, so you can make an honest build-versus-buy call.
2026/07/07 - Mehdi Ouazza
How to build robust data pipelines with AI
AI pipelines run green and still return wrong numbers. Four habits to turn a one-shot prompt into a data pipeline you can actually trust.
2026/06/29 - Mehdi Ouazza
What if a full data platform was one prompt away?
We launched Flights, an AI-native Python runtime in MotherDuck. Here's how I built a full end-to-end data pipeline (two scheduled Flights and a Dive dashboard) from a single prompt, using an AI coding agent and the MotherDuck MCP.
42:30
2026-06-09
Is Your Postgres Slow at Answering Analytics Questions?
Postgres slows down on analytics as your app grows. Learn the signs you've hit its ceiling and how to offload analytical queries to MotherDuck.
Webinar
SQL
Data Pipelines
MotherDuck Features
2026/06/04 - Mehdi Ouazza
Your Obsidian Vault Can Now Run SQL (and Your Agent Can Read It)
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
53:19
2026-05-12
Building a Data Product on MotherDuck: PriceMedic's Path from Raw Data to Revenue
PriceMedic replaced Athena and Redshift with MotherDuck. Co-founder Josh Nakka on the 14x speedup, $20K/month savings, and Dives for customers.
Webinar
MotherDuck Features
AI, ML and LLMs
2026/04/20 - Mehdi Ouazza, Samantha Lohier, Leonardo Vida
MotherDuck Skills: Teaching Your AI Agents to Do Analytics
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/10 - Mehdi Ouazza
Your AI dashboard looks cool. Nobody learns anything from it
Five fundamental data visualization principles that transform AI-generated dashboards from pretty charts into actionable insights. Learn chart selection, design, narrative, and interactivity.
2026/03/25 - Ryan Boyd, Mehdi Ouazza
The Dive Gallery Is Live: Share Your Interactive Data Apps With the World
Share interactive, AI-built data apps with anyone through a unique link — queries run live on MotherDuck compute.
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
9:09
2026-02-13
MCP: Understand It, Set It Up, Use It
Learn what MCP (Model Context Protocol) is, how its three building blocks work, and how to set up remote and local MCP servers. Includes a real demo chaining MotherDuck and Notion MCP servers in a single prompt.
YouTube
MCP
AI, ML and LLMs
0:09:18
2026-01-21
No More Writing SQL for Quick Analysis
Learn how to use the MotherDuck MCP server with Claude to analyze data using natural language—no SQL required. This text-to-SQL tutorial shows how AI data analysis works with the Model Context Protocol (MCP), letting you query databases, Parquet files on S3, and even public APIs just by asking questions in plain English.
YouTube
Tutorial
AI, ML and LLMs
2025-10-27
Boosting Data Performance: Unlocking the Power of DuckDB in your Gold Layer
Watch this webinar with MotherDuck and Artefact for a discussion about how to achieve exceptional performance for gold layer analytics using DuckDB .
Webinar
2025-10-15
Beyond BI: Building Data Apps and Customer-Facing Analytics
In this webinar, we compare classic BI dashboards with custom-built data apps built in Python and JavaScript. We'll also show how MotherDuck can power both data teams and software engineers to deliver analytics directly to users.
Webinar
2025-10-14
Simplifying the Transformation Layer
Explore the latest transformation layer architectures and real-world uses, plus how MotherDuck utilizes DuckDB for cloud-scale transformation.
Webinar
2025/10/08 - Mehdi Ouazza
Why Python Developers Need DuckDB (And Not Just Another DataFrame Library)
Understand why a database is much more than just a dataframe library
2025/08/11 - Mehdi Ouazza
When Spark Meets DuckLake: Tooling You Know, Simplicity You Need
Learn how to combine Apache Spark’s scale with DuckLake’s simplicity to build a lakehouse with ACID, time travel, and schema evolution
2025-07-17
Why Your Postgres Analytics Are So Slow (And 3 Ways to Fix It)
Struggling with slow PostgreSQL analytics queries? @mehdio shows 3 proven methods to supercharge performance using DuckDB and MotherDuck. Perfect for GROUP BY aggregations taking 30+ seconds.
YouTube
2025/07/15 - Mehdi Ouazza
Teaching Your LLM About DuckDB the Right Way: How to Fix Outdated Documentation
Learn how to keep LLMs updated with llms.txt and Cursor's docs feature.
46:26
2025-06-12
Escaping Catalog Hell: A Guide to Iceberg, DuckDB & the Data Lakehouse
Building a data stack means choosing between easy SaaS and complex open-source. Apache Iceberg is a middle ground, but its catalog is a hurdle. New tools now simplify using Iceberg with DuckDB to create a flexible, local data lakehouse.
MotherDuck Features
2025/06/09 - Mehdi Ouazza
Getting Started with DuckLake: A New Table Format for Your Lakehouse
Learn how DuckLake simplifies metadata and brings fast, database-like features to your data lakehouse — with a hands-on example using DuckDB and PostgreSQL
2025-06-05
Understanding DuckLake: A Table Format with a Modern Architecture
Discover how DuckLake revolutionizes data lake table formats by storing metadata in relational databases, enabling faster, scalable, and ACID-compliant analytics on object storage like S3.
YouTube
2025/05/30 - Mehdi Ouazza
From BigQuery to DuckDB and MotherDuck : Efficient Local and Cloud Data Pipelines
Learn how to query load table from BigQuery to DuckDB and MotherDuck using SQL and Python!
2025-05-20
AI Powered BI: Can LLMs REALLY Generate Your Dashboards? ft. Michael Driscoll
Discover how business intelligence is evolving from drag-and-drop tools to code-based, AI-powered workflows—leveraging LLMs, DuckDB, and local development for faster, more flexible analytics.
YouTube
AI, ML and LLMs
BI & Visualization
2025-05-13
Faster Data Pipelines development with MCP and DuckDB
Discover how the Model Context Protocol (MCP) accelerates data pipeline development with AI tools, DuckDB, and MotherDuck, streamlining schema discovery and code generation for data engineers.
YouTube
AI, ML and LLMs
2025/05/12 - Mehdi Ouazza
Meet the New DuckDB Local UI: Analyze Data Visually, Right Where It Lives
Walkthrough of the new DuckDB UI features!
2025-04-23
What If SQL Queries Returned Results Instantly?
With Instant SQL, the MotherDuck UI revolutionizes SQL development with instant query results, real-time debugging, and faster iteration—eliminating decades of delays for modern data professionals.
YouTube
2025/04/15 - Mehdi Ouazza
MCP + DuckDB: Connect AI Assistants to Your Data Pipelines
Use the Model Context Protocol (MCP) to connect Claude, Cursor, or other AI tools directly to DuckDB. Query data, generate SQL, and automate pipelines—without copy-pasting
2025-04-10
4 Lightning Talks on Practical AI Workflows from Notion, 1Password, MotherDuck & Evidence
Learn how data teams at MotherDuck, Notion, 1Password, and Evidence use AI tools to automate workflows, enrich data, speed up BI development, and enhance documentation.
YouTube
2025-04-10
Practical AI Workflows For Data Professionals
4 lightning talks on practical AI workflows: -Mehdi: MCP feedback loops for faster data engineering cycles -Archie: Cursor configs for data app dev -Nate: LLMs + SQL for CRM cleaning -Evelyn: Auto-generated data catalog descriptions
Interview
AI, ML and LLMs
Data Quality
Data Pipelines
5:20
2025-03-14
How to Use the New DuckDB UI – Fast, Free, and Local
Mehdi walks through the new DuckDB UI, a free local SQL notebook you launch with duckdb -ui, and shows how to connect it to MotherDuck for cloud access.
YouTube
2025-02-21
DuckDB & MotherDuck for Beginners: Your Ultimate Guide
Mehdi revisits the basics in this 35-minute video, covering everything you need to know about DuckDB and MotherDuck.
YouTube
