--- title: "Mehdi Ouazza - MotherDuck Blog" description: "Mehdi joins us as a Data Engineering and Analytics Advocate after a career as a Data Engineer and a nighttime hobby of creating YouTube videos and other content for data professionals." canonical: "https://motherduck.com/authors/mehdi-ouazza/" --- # Mehdi Ouazza Mehdi Ouazza's photo Data engineer & Developer Advocate Mehdi joins us as a Data Engineering and Analytics Advocate after a career as a Data Engineer and a nighttime hobby of creating YouTube videos and other content for data professionals. ## 101 BLOG POSTS AND VIDEOS [2026/08/27 - Mehdi Ouazza, MotherDuck team](/blog/motherduck-cli-announcement/) ### [MotherDuck CLI: query, pipelines, and dashboards from your terminal](/blog/motherduck-cli-announcement) 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](/blog/agent-signup-cloud-data-warehouse/) ### [I let an agent sign itself up to a cloud data warehouse, then replayed every step](/blog/agent-signup-cloud-data-warehouse) 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](/videos/robust-data-pipelines-ai/)[2026-07-22](/videos/robust-data-pipelines-ai/) ### [Writing robust data pipelines with AI](/videos/robust-data-pipelines-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](/blog/self-hosting-duckdb-road-to-production/) ### [Self-hosting DuckDB: the road to production](/blog/self-hosting-duckdb-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](/blog/robust-data-pipelines-with-ai/) ### [How to build robust data pipelines with AI](/blog/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](/blog/full-data-pipeline-one-prompt/) ### [What if a full data platform was one prompt away?](/blog/full-data-pipeline-one-prompt) 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](/videos/postgres-slow-analytics-queries/)[2026-06-09](/videos/postgres-slow-analytics-queries/) ### [Is Your Postgres Slow at Answering Analytics Questions?](/videos/postgres-slow-analytics-queries/) 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](/blog/obsidian-vault-duckdb-ai-agents/) ### [Your Obsidian Vault Can Now Run SQL (and Your Agent Can Read It)](/blog/obsidian-vault-duckdb-ai-agents) 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](/videos/pricemedic-data-product-motherduck/)[2026-05-12](/videos/pricemedic-data-product-motherduck/) ### [Building a Data Product on MotherDuck: PriceMedic's Path from Raw Data to Revenue](/videos/pricemedic-data-product-motherduck/) 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](/blog/motherduck-agent-skills/) ### [MotherDuck Skills: Teaching Your AI Agents to Do Analytics](/blog/motherduck-agent-skills) 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](/blog/vibecoding-dashboards-best-practices/) ### [Your AI dashboard looks cool. Nobody learns anything from it](/blog/vibecoding-dashboards-best-practices) 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](/blog/dive-gallery-share-interactive-data-apps/) ### [The Dive Gallery Is Live: Share Your Interactive Data Apps With the World](/blog/dive-gallery-share-interactive-data-apps) Share interactive, AI-built data apps with anyone through a unique link — queries run live on MotherDuck compute. [2026/03/06 - Mehdi Ouazza](/blog/what-is-mcp-guide-agentic-analytics/) ### [What is MCP? A Data Person's Guide to Agentic Analytics](/blog/what-is-mcp-guide-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](/videos/mcp-understand-it-set-it-up-use-it/)[2026-02-13](/videos/mcp-understand-it-set-it-up-use-it/) ### [MCP: Understand It, Set It Up, Use It](/videos/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](/videos/no-more-writing-sql-for-quick-analysis/)[2026-01-21](/videos/no-more-writing-sql-for-quick-analysis/) ### [No More Writing SQL for Quick Analysis](/videos/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](/webinar/unlocking-duckdb-in-your-gold-layer/) ### [Boosting Data Performance: Unlocking the Power of DuckDB in your Gold Layer](//webinar/unlocking-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](/webinar/building-data-apps-and-customer-facing-analytics/) ### [Beyond BI: Building Data Apps and Customer-Facing Analytics](//webinar/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](/webinar/simplifying-the-transformation-layer/) ### [Simplifying the Transformation Layer](//webinar/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](/blog/python-duckdb-vs-dataframe-libraries/) ### [Why Python Developers Need DuckDB (And Not Just Another DataFrame Library)](/blog/python-duckdb-vs-dataframe-libraries) Understand why a database is much more than just a dataframe library [2025/08/11 - Mehdi Ouazza](/blog/spark-ducklake-getting-started/) ### [When Spark Meets DuckLake: Tooling You Know, Simplicity You Need](/blog/spark-ducklake-getting-started) 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](/video/fix-slow-postrges-analytics/) ### [Why Your Postgres Analytics Are So Slow (And 3 Ways to Fix It)](//video/fix-slow-postrges-analytics) 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](/blog/fix-outdated-llm-documentation-duckdb/) ### [Teaching Your LLM About DuckDB the Right Way: How to Fix Outdated Documentation](/blog/fix-outdated-llm-documentation-duckdb) Learn how to keep LLMs updated with llms.txt and Cursor's docs feature. [46:26](/videos/escaping-catalog-hell-a-guide-to-iceberg-duckdb-the-data-lakehouse/)[2025-06-12](/videos/escaping-catalog-hell-a-guide-to-iceberg-duckdb-the-data-lakehouse/) ### [Escaping Catalog Hell: A Guide to Iceberg, DuckDB & the Data Lakehouse](/videos/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](/blog/getting-started-ducklake-table-format/) ### [Getting Started with DuckLake: A New Table Format for Your Lakehouse](/blog/getting-started-ducklake-table-format) 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](/videos/understanding-ducklake-a-table-format-with-a-modern-architecture/) ### [Understanding DuckLake: A Table Format with a Modern Architecture](/videos/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](/blog/bigquery-to-duckdb-motherduck/) ### [From BigQuery to DuckDB and MotherDuck : Efficient Local and Cloud Data Pipelines](/blog/bigquery-to-duckdb-motherduck) Learn how to query load table from BigQuery to DuckDB and MotherDuck using SQL and Python! [2025-05-20](/videos/ai-powered-bi-can-llms-really-generate-your-dashboards-ft-michael-driscoll/) ### [AI Powered BI: Can LLMs REALLY Generate Your Dashboards? ft. Michael Driscoll](/videos/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](/videos/faster-data-pipelines-development-with-mcp-and-duckdb/) ### [Faster Data Pipelines development with MCP and DuckDB](/videos/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](/blog/local-duckdb-ui-visual-data-analysis/) ### [Meet the New DuckDB Local UI: Analyze Data Visually, Right Where It Lives](/blog/local-duckdb-ui-visual-data-analysis) Walkthrough of the new DuckDB UI features! [2025-04-23](/videos/what-if-sql-queries-returned-results-instantly/) ### [What If SQL Queries Returned Results Instantly?](/videos/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](/blog/faster-data-pipelines-with-mcp-duckdb-ai/) ### [MCP + DuckDB: Connect AI Assistants to Your Data Pipelines](/blog/faster-data-pipelines-with-mcp-duckdb-ai) 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](/videos/4-lightning-talks-on-practical-ai-workflows-from-notion-1password-motherduck-evidence/) ### [4 Lightning Talks on Practical AI Workflows from Notion, 1Password, MotherDuck & Evidence](/videos/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](/webinar/practical-ai-use-cases-for-data/) ### [Practical AI Workflows For Data Professionals](//webinar/practical-ai-use-cases-for-data) 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](/videos/how-to-use-the-new-duckdb-ui-fast-free-and-local/)[2025-03-14](/videos/how-to-use-the-new-duckdb-ui-fast-free-and-local/) ### [How to Use the New DuckDB UI – Fast, Free, and Local](/videos/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](/videos/duckdb-motherduck-for-beginners-your-ultimate-guide/) ### [DuckDB & MotherDuck for Beginners: Your Ultimate Guide](/videos/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](/videos/from-core-to-custom-unlocking-new-possibilities-with-duckdb-extensions/) ### [From Core to Custom: Unlocking new possibilities with DuckDB Extensions](/videos/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 ## SUBSCRIBE ### Subscribe to MotherDuck Blog Also subscribe to other MotherDuck updates Submit