MotherDuck

@motherduck.com

Making analytics fun, frictionless and ducking awesome with an unorthodox data warehouse for the post big data era based on @duckdb.org in collab with DuckDB Labs

I've been leading the data infrastructure efforts at my job (I used to work as a Data Engineer in big tech) and the stack we've landed on is so enjoyable to work with. @dagster.io - Orchestration @duckdb.org - Database @motherduck.com - Data Warehouse/storage DBT - Data modeling

Why use a semantic layer? 🤔 @ssp.sh shows how to build the simplest one with just: ⚡ YAML for metrics ⚡ Python + DuckDB + Ibis to query 20M NYC taxi records You'll understand when it's useful and when it's overkill motherduck.com/blog/semanti...

Why Semantic Layers Matter — and How to Build One with DuckDB - MotherDuck Blog

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 | Reading time: 21 min read

motherduck.com

🚀 Just published a 3-week data engineering roadmap - perfect for summer learning! 📖 Week 1: SQL, Git & Linux basics ⚙️ Week 2: Python, cloud & data modeling 🔥 Week 3: Streaming, data quality & DevOps Perfect for beginners or skill refreshers. Consistency > speed! 👏 Thanks @ssp.sh

Bild

Your AI thinks DuckDB is v0.10.2 😱 Current version? 1.3.2 Stop feeding your AI stale docs! Quick fixes: 1️⃣ llms.txt files - copy fresh docs directly 2️⃣ Cursor's docs feature - auto-crawl documentation 📖 motherduck.com/blog/fix-outdated-llm-documentation-duckdb/

Teaching Your LLM About DuckDB the Right Way: How to Fix Outdated Documentation - MotherDuck Blog

Learn how to keep LLMs updated with llms.txt and Cursor's docs feature. | Reading time: 4 min read

motherduck.com

🦆 DuckDB Ecosystem Newsletter is live! 🔥 YamlQL, Tributary Kafka extension, SQLRooms browser apps, DuckDB Wizard 🚀 DuckDB 1.3.0 with 100x perf gains, DuckLake, AWS/PostgreSQL integrations 👨‍💻 Community spotlight: Rusty Conover motherduck.com/blog/duckdb-...

This Month in the DuckDB Ecosystem: July 2025 - MotherDuck Blog

DuckDB Monthly #31: Kafka Integration, Browser-Based Analytics, and Lake Format Innovations | Reading time: 7 min read

motherduck.com

The toolkit explosion is real for data engineers. One day you're optimizing SQL queries, the next debugging Kubernetes, then explaining to stakeholders why their dashboard is empty. The secret? Infrastructure as Code + DevOps principles. Read more by @ssp.sh : motherduck.com/blog/data-en...

The Data Engineer Toolkit: Infrastructure, DevOps, and Beyond - MotherDuck Blog

A comprehensive guide to advanced data engineering tools covering everything from SQL engines and orchestration platforms to DevOps, data quality, AI workflows, and the soft skills needed to build pro...

motherduck.com

Still using REST or JDBC to serve data? 🐢 You’re slowing things down. It’s like putting a Ferrari engine in a horse-drawn carriage. 🚗🐎 Arrow Flight SQL streams columnar data at 20+ Gb/s/core. Serve data as fast as you compute it, by Thomas McGeehan: motherduck.com/blog/flight-...

Why REST and JDBC Are Killing Your Data Stack — Flight SQL to the Rescue - MotherDuck Blog

Understand how Flight SQL can speed up how your serve data with DuckDB | Reading time: 8 min read

motherduck.com

We're thrilled to be part of Redpoint's 2025 InfraRed 100 list, which highlights 100 transformative companies in cloud infrastructure. Proud to be in such outstanding company - congratulations to everyone listed!

Bild

If you still haven’t gotten your hands dirty with DuckLake, here’s your opportunity! In this blog, @mehdio.com covers : 🔍 Recap on what table formats are 🧠 Understand why DuckLake's architecture is faster 🛠️ Create your first DuckLake table motherduck.com/blog/getting...

Getting Started with DuckLake: A New Table Format for Your Lakehouse - MotherDuck Blog

Learn how DuckLake simplifies metadata and brings fast, database-like features to your data lakehouse — with a hands-on example using DuckDB and PostgreSQL | Reading time: 8 min read

motherduck.com

If you're wondering what all the fuss is about table formats—and this new one called DuckLake—this video is for you. If you don’t choose table formats but benchmark them, it’s for you too. If you don’t like table formats at all? Well, then share this video with your enemies.

MotherDuck@motherduck.com · last yr.

Forget what you know about table formats — DuckLake flips the script. ✅ Metadata in Postgres/DuckDB ✅ Data in Parquet on S3 ✅ No more crawling metadata files @mehdio.com breaks it down with a hands-on @supabase + @duckdb.org setup 🛠️ 📺 youtu.be/hrTjvvwhHEQ

One of the notions we think about quite a bit at @motherduck.com is "handling data before it becomes big" and I think this example from @tigrisdata.com really nails it. The trick here is parsing the JSON on insert so its really quick to query it.

Tigris Data@tigrisdata.com · last yr.

AI scrapers can overload your app before you even see them coming. Anubis uses proof-of-work + honeypots to fight back—paired with @motherduck.com + @tigrisdata.com for real-time pattern detection at scale. 🧠 Detect bots. 🚫 Stop downtime. 🔗 www.tigrisdata.com/blog/anubis/

S3 isn’t a database. But what if your lakehouse finally acted like one? @jrdntgn.bsky.social shares why the current generation of lakehouse formats like Iceberg and Delta Lake might be missing the point—and how DuckLake, a new table format, changes the game. motherduck.com/blog/ducklak...

A Duck Walks into a Lake - MotherDuck Blog

DuckDB introduces a new table format, what does it mean for the future of data lakes ? | Reading time: 9 min read

motherduck.com

There's a bunch of new features from @motherduck.com‬ and marimo that really play nice together, so we're teaming up with Mehdi Ouazza this week for a livestream. Join us this Friday to get a preview of some new features for your data work here: youtube.com/live/--ExP9...

Exploring motherduck with marimo

We are experimenting with livestreams! We try to explore new tools and techniques weekly.The code for this project can be found here:https://github.com/koani...

youtube.com