MOTHERDUCK BLOG
DuckDB, MotherDuck, Data Engineering and Data Analytics
Search and filter
Search and filter
Topic
2025/09/03 - Jelte Fennema-Nio, Jacob Matson
Announcing Pg_duckdb Version 1.0
PostgreSQL gets a DuckDB-flavored power-up for faster analytical queries without ever leaving Postgres.
2025/08/29 - Vasilije Markovic
DuckDB × cognee: Run SQL Analytics Right Beside Your Graph-Native RAG
SQL analytics and graph-native retrieval together, eliminating the trade-off between fast analytics and one-off RAG retrievals.
Subscribe to MotherDuck Blog
2025/08/22 - Jacob Matson
Nine Keyboard Shortcuts for SQL Flow State
Tired of clicking? Master 9 essential SQL keyboard shortcuts to achieve a true flow state and make your data analysis faster and more joyful. Learn to run queries, comment, format, and even use AI without leaving your keyboard.
2025/08/19 - Simon Späti
Why Semantic Layers Matter — and How to Build One with DuckDB
Learn what a semantic layer is, why it matters, and how to build a simple one with DuckDB and Ibis using just YAML and Python
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/08/07 - Simon Späti
DuckDB Ecosystem: August 2025
DuckDB Monthly #32: DuckDB hits 50.7% growth—vector search, WASM, and analytics take the spotlight
2025/08/07 - Oli Dinov
Real-Time MySQL to MotherDuck Streaming with Streamkap: A Shift Left Architecture Guide
Build real-time MySQL to MotherDuck pipelines with Streamkap. Learn Shift Left architecture, streaming CDC, and how to replace batch ETL for instant analytics and customer dashboards.
2025/08/04 - Jacob Matson, Alex Monahan
Just Enough SQL to be Dangerous with AI
Learn essential SQL to verify AI-generated queries. Master SELECT, JOIN, and CTEs to safely analyze data with LLMs. Includes DuckDB examples and safety tips
2025/07/25 - Hamilton Ulmer, Jacob Matson
MotherDuck's Latest AI Features: Smarter SQL Error Fixes and Natural Language Editing
Stay in flow with MotherDuck's latest features. Real-time SQL feedback and natural language editing.
2025/07/21 - Simon Späti
Summer Data Engineering Roadmap
A comprehensive 3-week structured roadmap for learning data engineering fundamentals, from SQL and Git basics to advanced topics like streaming, data quality, and DevOps.RetryClaude can make mistakes. Please double-check responses.
2025/07/17 - Ryan Boyd
Introducing Mega and Giga Ducklings: Scaling Up, Way Up
New MotherDuck instance sizes allow data warehousing users more flexibility for complex queries and transformations. Need more compute to scale up? Megas and Gigas will help!
2025/07/17 - Ryan Boyd
Small Data SF Returns November 4-5, 2025: First Speakers Announced
Conference with two days of practical innovation on data and AI: workshops and talks from industry leaders, including Benn Stancil, Joe Reis, Adi Polak, George Fraser, Jordan Tigani, Holden Karau, Ravin Kumar, Sam Alexander and more!
