77 BLOG POSTS AND VIDEOS
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-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/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
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
2025-02-10
From Core to Custom: Unlocking new possibilities with DuckDB Extensions
Learn how DuckDB extensions—both core and community—expand database capabilities, streamline workflows, and empower developers to easily create, install, and share powerful new features.
YouTube
2025/02/04 - Mehdi Ouazza
Why CSV Files Won’t Die and How DuckDB Conquers Them
Learn how you can pragmatically use DuckDB to parse any CSVs
2024/12/20 - Mehdi Ouazza
We made a fake duck game: compete to win!
Spot the fake (AI generated) duck to win!
2024/12/18 - Mehdi Ouazza
Why web developers should care about analytical databases
Learn how analytical database can help your web app, with MotherDuck and the native integration with Vercel
08:48
2024-12-11
Why web developers should care about analytical databases
You often start your web application with an OLTP database like Postgres, but should you crunch your analytics there? In this video, Mehdi explains what OLAP databases are, when to use them, and more.
YouTube
Wasm
SQL
16:37
2024-11-22
Can DuckDB revolutionize the data lake experience?
Mehdi explores DuckDB as a catalog for Data Lake and Lakehouse pattern. He'll define what we mean by "data catalog", gives clear examples on how they work and dive into a pragmatic use case with DuckDB & MotherDuck.
YouTube
Data Pipelines
Sources
2024/11/20 - Simon Späti, Mehdi Ouazza
How to Extract Analytics from Bluesky, the New Open Social Network
Discover how to build data pipelines to get insights from Bluesky
2024/11/14 - Mehdi Ouazza
From Data Lake to Lakehouse: Can DuckDB be the best portable data catalog?
Discover how catalog became crucial for Lakehouse and how DuckDB can help as a catalog
2024/10/31 - Mehdi Ouazza, Ryan Boyd
DuckDB Tutorial For Beginners
Learn DuckDB from scratch: install in 2 minutes, set up VSCode, and build your first SQL analytics project. No database experience required.
14:18
2024-10-25
pg_duckdb: Postgres analytics just got faster with DuckDB
Postgres analytics 10x faster?! 🤯 pg_duckdb is here! This open-source extension adds DuckDB's analytics to Postgres, supporting Parquet, CSV, Iceberg reads, and direct MotherDuck queries—all within Postgres!
YouTube
Ingestion
SQL
Ecosystem
2024/10/23 - Jelte Fennema-Nio, Mehdi Ouazza
pg_duckdb beta release : Even faster analytics in Postgres
pg_duckdb makes elephants fly, marking its first release.
2024/09/27 - Mehdi Ouazza
5 Hidden gems in DuckDB 1.1
Discover some underrated features from DuckDB 1.1
1:00:53
2024-09-24
A new paradigm for data visualization with just SQL + Markdown
Come to this Quack&Code where Mehdi will discuss data visualization with DuckDB/MotherDuck, specifically focusing on Evidence! Archie, who is building evidence.dev, will join us to share his wisdom on charts ;-)
BI & Visualization
YouTube
Quack & Code
2024/09/18 - Mehdi Ouazza
Getting started with modern GIS using DuckDB
Learn how DuckDB can help you started with Geospatial analysis
2024/09/03 - Mehdi Ouazza
This Month in the DuckDB Ecosystem: September 2024
DuckDB news: pg_duckdb brings analytical queries to PostgreSQL. Ibis makes DuckDB its default backend, dropping Pandas. Getting Started with DuckDB book released.
14:49
2024-08-29
Is DuckDB the Secret to Unlocking Your GIS Potential?
In this video, Mehdi walks you through the basics of working with geospatial data and introduces the DuckDB spatial extension. By the end, you will create your own heatmap using DuckDB, Python, and MotherDuck for sharing and scalability.
YouTube
Tutorial
SUBSCRIBE
Subscribe to MotherDuck Blog
