MotherDuck

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

616 followers92 following115 posts

Pinned

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...

motherduck.comA Duck Walks into a Lake - MotherDuck BlogDuckDB introduces a new table format, what does it mean for the future of data lakes ? | Reading time: 9 min read

MotherDuck reposted

I'm super excited to join the folks from @motherduck.com at Data Outpost in November! I'll be speaking about why the investments that make SQL comfortable for humans turn out to be the same ones that make it tractable for an agent 🤖 Check out the details at www.dataoutpost.ai

MotherDuck reposted

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...

motherduck.comWhy Semantic Layers Matter — and How to Build One with DuckDB - MotherDuck BlogLearn 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

🚀 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

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/

motherduck.comTeaching Your LLM About DuckDB the Right Way: How to Fix Outdated Documentation - MotherDuck BlogLearn how to keep LLMs updated with llms.txt and Cursor's docs feature. | Reading time: 4 min read

🦆 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-...

motherduck.comThis Month in the DuckDB Ecosystem: July 2025 - MotherDuck BlogDuckDB Monthly #31: Kafka Integration, Browser-Based Analytics, and Lake Format Innovations | Reading time: 7 min read

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...

motherduck.comThe Data Engineer Toolkit: Infrastructure, DevOps, and Beyond - MotherDuck BlogA 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 reposted

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-...

motherduck.comWhy REST and JDBC Are Killing Your Data Stack — Flight SQL to the Rescue - MotherDuck BlogUnderstand how Flight SQL can speed up how your serve data with DuckDB | Reading time: 8 min read

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!

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...

motherduck.comGetting Started with DuckLake: A New Table Format for Your Lakehouse - MotherDuck BlogLearn 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 reposted

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

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

MotherDuck reposted

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

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/

MotherDuck reposted

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...

youtube.comExploring motherduck with marimoWe 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...

We debug Spark jobs and pipelines by grepping logs… but logs are data. In our latest post, @ssp.sh shows how to query logs with SQL using DuckDB + MotherDuck: • Parse messy JSON/syslog • Query vs. materialize • Analyze millions locally 👉 motherduck.com/blog/json-lo...

motherduck.comThe Data Engineer's Guide to Efficient Log Parsing with DuckDB/MotherDuck - MotherDuck BlogHow to Query JSON and Log Files with SQL Using DuckDB and MotherDuck | Reading time: 23 min read

Data engineering feedback loops too slow? 🐌 MCP connects AI copilots (Cursor, etc.) DIRECTLY to tools like DuckDB! Imagine AI inspecting schemas & testing queries before generating code. 🤯 @mehdio.com shows how w/ DuckDB/dbt 👇 motherduck.com/blog/faster-...

motherduck.comClose the Loop: Faster Data Pipelines with MCP, DuckDB & AI - MotherDuck BlogHow the MCP can accelerate data engineering workflows by connecting AI copilots directly to data tools like DuckDB | Reading time: 11 min read

🚨 New Month, New DuckDB Ecosystem Roundup! 👤 Shoutout to Caleb Fahlgren (Hugging Face) for showing how the DuckDB UI makes exploring hf:// datasets a breeze. 🔥 Highlights: • Streaming w/ SQLFlow • Hybrid search (Quiver) • S3 caching • UI tips • Pandas → SQL guide motherduck.com/blog/duckdb-...

motherduck.comDuckDB Ecosystem: April 2025 - MotherDuck BlogDuckDB Monthly #28: DuckDB goes streaming, local caching & more! | Reading time: 9 min read

Thank you, Nasdaq and Wing Venture Capital, for a warm welcome this evening to ring the closing bell 🔔 for this year's 2025 Enterprise Tech 30!

SF folk: Don't miss the panel tomorrow evening on building data + AI products featuring MotherDuck CEO Jordan Tigani, Theory Ventures GP​Tomasz Tunguz, Cartesia CEO ​Karan Goel. Starts at 530pm. Register here: buff.ly/FRhOw4N

We’re honored and excited to share that MotherDuck has been named as one of the top companies shaping the future of enterprise tech. Thanks to our friends Wing VC and Eric Newcomer! #ET30 Congrats to everyone who made the list: enterprisetech30.com

enterprisetech30.comEnterprise Tech 30 | Presented by Wing Venture CapitalThe Enterprise Tech 30 serves as a platform for the tech industry to identify, learn about, and build relationships with the most promising private companies in enterprise technology.