Sign in

MotherDuck

@motherduck.com
602 followers 92 following 115 posts

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

PostsRepliesMedia
Reposted by MotherDuck
Andy Pavlo @andypavlo.bsky.social · 18/09/2025
Fall 2025 Seminar Schedule: Sep 22: Apache Iceberg Sep 29: Apache Hudi Oct 06: @motherduck.com Oct 13: SpiralDB Vortex Oct 27: @singlestore.com Nov 03: @deltalakeoss.bsky.social Nov 10: Mooncake Nov 17: @firebolthq.bsky.social Nov 24: @xtdb.com Dec 01: Apache Polaris
Future Data Systems Seminar Schedule (Fall 2025)
1185
Reposted by MotherDuck
Mid terms are November 3rd 2026. Go register voters. @usrbinr.bsky.social · 12/09/2025
Just use @motherduck.com instead
283
Reposted by MotherDuck
jd @jd.codes · 05/09/2025
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
3133
MotherDuck @motherduck.com · 19/08/2025
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.com
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
050
MotherDuck @motherduck.com · 07/08/2025
The August DuckDB Ecosystem Newsletter is out! Highlights: • DuckDB grew 50.7% YoY (1.8M HN headlines analyzed) • Claude + DuckDB = full Spotify analytics pipeline • AI that debugs its own SQL • Real-time news sentiment with DuckDB motherduck.com/blog/duckdb-...
motherduck.com
DuckDB Ecosystem: August 2025 - MotherDuck Blog
DuckDB Monthly #32: DuckDB hits 50.7% growth—vector search, WASM, and analytics take the spotlight | Reading time: 7 min read
060
MotherDuck @motherduck.com · 21/07/2025
🚀 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
140
MotherDuck @motherduck.com · 18/07/2025
All roads lead to Rome, but there are 3 ways to get your Postgres analytics queries from painfully slow to lightning fast ⚡ Watch the latest video of @mehdio.com to understand 3 distinct paths to DuckDB integration, each with its own pros/cons👇 youtu.be/86V4wbFtuaY
youtu.be
Why Your Postgres Analytics Are So Slow (And 3 Ways to Fix It)
YouTube video by MotherDuck
030
MotherDuck @motherduck.com · 17/07/2025
Come join us for THE conference of the year! 🎫🦆 Early bird tix are live! 🎤 First round of speakers just dropped! Join the builders doing more with less → $295 until Aug 4: smalldatasf.com
smalldatasf.com
Small Data 2025 – The San Francisco Event on Small, Local-First Data
Save the date for Small Data 2025, the event where simplicity meets impact. Join industry leaders in exploring the joys of small, local-first data and the future of efficient computing.
041
MotherDuck @motherduck.com · 16/07/2025
🦆 NEW: Mega and Giga ducklings are here! For when your data is too big, your queries too complex, and "fast enough" isn't fast enough. Learn More: motherduck.com/blog/announc...
051
MotherDuck @motherduck.com · 15/07/2025
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.com
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
040
MotherDuck @motherduck.com · 08/07/2025
🦆 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.com
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
050
MotherDuck @motherduck.com · 03/07/2025
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.com
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...
062
MotherDuck @motherduck.com · 01/07/2025
MotherDuck now supports DuckLake! 🦆 New open table format for extreme scale with database-backed metadata. Two options: 🚀 Fully managed ☁️ Bring your own bucket Ready to dive in (the lake 🥁)? CREATE DATABASE (TYPE ducklake); motherduck.com/blog/announc...
motherduck.com
MotherDuck Managed DuckLakes Now in Preview: Scale to Petabytes - MotherDuck Blog
Preview support of MotherDuck includes both fully-managed DuckLake support and ability to bring your own bucket. Combined with MotherDuck's storage, you get both high-speed access to recent data and s...
0113
MotherDuck @motherduck.com · 23/06/2025
If you missed the livestream with @jrdntgn.bsky.social and @hannes.muehleisen.org, now it's your time to catch up! A technical discussion about the evolution of open table formats and lakehouse architecture. youtu.be/-PYLFx3FRfQ
youtu.be
How DuckLake Simplifies Lakehouse Architecture ft. Jordan Tigani & Hannes Mühleisen
YouTube video by MotherDuck
072
Reposted by MotherDuck
DuckDB @duckdb.org · 13/06/2025
Curious to know more about DuckLake? Next Tuesday, DuckDB co-creator @hannes.muehleisen.org will talk with @motherduck.com CEO @jrdntgn.bsky.social about DuckLake and the future of open table formats. 📆 June 17 (Tuesday), 8:00 PDT / 17:00 CEST ✍️ Register at lu.ma/mt9f8xh1?tk=...
lu.ma
DuckLake & The Future of Open Table Formats · Luma
Join MotherDuck CEO Jordan Tigani and DuckDB's Hannes Mühleisen for an in-depth discussion about DuckLake, the new lakehouse format that's rethinking how we…
0214
MotherDuck @motherduck.com · 13/06/2025
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.com
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
142
MotherDuck @motherduck.com · 10/06/2025
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!
100
MotherDuck @motherduck.com · 09/06/2025
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.com
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
060
Reposted by MotherDuck
Mehdi Ouazza @mehdio.com · 05/06/2025
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.
031
MotherDuck @motherduck.com · 06/06/2025
🚀 DuckDB Ecosystem: June 2025 — just out! 🦆 Big news: DuckLake — a new table format powered by pure SQL + open formats. Also in this issue: ✅ GTFS transit data ✅ MinIO lakehouse ✅ CSV reader win and much more... 👉 motherduck.com/blog/duckdb-...
motherduck.com
DuckDB Ecosystem: June 2025 - MotherDuck Blog
DuckDB Monthly #30: DuckDB's new table format, Radio extension and more! | Reading time: 7 min read
040
MotherDuck @motherduck.com · 05/06/2025
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
youtu.be
Understanding DuckLake: A Table Format with a Modern Architecture
YouTube video by MotherDuck
051
MotherDuck @motherduck.com · 01/06/2025
DuckDB 1.3.0 is live in MotherDuck! New SQL syntax, blazing-fast Parquet reads and writes, and even better performance. Learn more: motherduck.com/blog/announc... @duckdb.org
motherduck.com
DuckDB 1.3 Lands in MotherDuck: Performance Boosts, Even Faster Parquet, and Smarter SQL - MotherDuck Blog
DuckDB 1.3 has launched, with performance boosts, faster Parquet reads and writes, and new SQL syntax for ducking awesome analytics with full support in MotherDuck. Read on for highlights from this ma...
0103
MotherDuck @motherduck.com · 30/05/2025
If you’re using BigQuery and want to level up your local development or supercharge your DuckDB workflows with MotherDuck, it’s never been easier to move data—using just SQL or Python. motherduck.com/blog/bigquer...
motherduck.com
From BigQuery to DuckDB and MotherDuck : Efficient Local and Cloud Data Pipelines - MotherDuck Blog
Learn how to query load table from BigQuery to DuckDB and MotherDuck using SQL and Python! | Reading time: 7 min read
040
Reposted by MotherDuck
Jacob Matson @matsonj.com · 29/05/2025
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.
161
MotherDuck @motherduck.com · 28/05/2025
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.com
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
1302
MotherDuck @motherduck.com · 20/05/2025
On the last Quack&Code @mehdio.com sat down with Michael Driscoll from RillData to explore how LLMs are revolutionizing the way we interact with data. They got hands-on with some fun demos... all locally with Rill and @duckdb.org youtu.be/m0LKRX20PJ8
youtu.be
AI Powered BI: Can LLMs REALLY Generate Your Dashboards? ft. Michael Driscoll
YouTube video by MotherDuck
031
Reposted by MotherDuck
marimo @marimo.io · 20/05/2025
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.com
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...
191
MotherDuck @motherduck.com · 13/05/2025
Quack... Quack... and code! @mehdio.com and @medriscoll.com from @rilldata.com are diving into how GenAI is reshaping BI-as-code — from idea to implementation. This one’s for data folks who want to see beyond the hype. Register : lu.ma/w4ncmttn
lu.ma
BI-as-Code with GenAI+DuckDB Real Use, Not Just Hype · Luma
Mehdi and Michael dive into how GenAI is reshaping BI-as-code. And as always — it’s not just talk, it’s real code. Get ready for pragmatic insights and…
044
MotherDuck @motherduck.com · 13/05/2025
There is a lot of noise about MCP - but are they actually useful for data engineering ? @mehdio.com dives into a pragmatic example of how MCP, and specifically @duckdb MCP, can speed up data pipeline development Full video 📺 www.youtube.com/watch?v=yG1m...
youtube.com
Faster Data Pipelines development with MCP and DuckDB
YouTube video by MotherDuck
062
MotherDuck @motherduck.com · 12/05/2025
Haven’t tried the new duckdb UI yet? No worries — we’ve got you covered with a full walkthrough blog showcasing all the new features! 👉 motherduck.com/blog/local-d...
motherduck.com
022
MotherDuck @motherduck.com · 08/05/2025
The May 2025 DuckDB Ecosystem Newsletter is live! Among the top picks: - LLMs in SQL (FlockMTL) - DuckDB-WASM renders Doom - Geospatial SQL revolution - Instant SQL previews - Metabase + DuckDB motherduck.com/blog/duckdb-...
motherduck.com
DuckDB Ecosystem: May 2025 - MotherDuck Blog
DuckDB Monthly #29: From Metabase to Doom, DuckDB powers everything. | Reading time: 7 min read
030
MotherDuck @motherduck.com · 23/04/2025
Instant SQL is HERE #INSTANTSQL
1185
MotherDuck @motherduck.com · 23/04/2025
INSTANT SQL mic drops with @hamilton.bsky.social at Data Council 🔥🔥🔥 Bend reality with real-time SQL results... Speedrun ad-hoc SQL queries as you type... Type, see, tweak, repeat... Get SQL superpowers - it's 2025. Learn More: motherduck.com/blog/introdu...
0245
MotherDuck @motherduck.com · 18/04/2025
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.com
The Data Engineer's Guide to Efficient Log Parsing with DuckDB/MotherDuck - MotherDuck Blog
How to Query JSON and Log Files with SQL Using DuckDB and MotherDuck | Reading time: 23 min read
060
MotherDuck @motherduck.com · 15/04/2025
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.com
Close the Loop: Faster Data Pipelines with MCP, DuckDB & AI - MotherDuck Blog
How the MCP can accelerate data engineering workflows by connecting AI copilots directly to data tools like DuckDB | Reading time: 11 min read
1121
MotherDuck @motherduck.com · 07/04/2025
🚨 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.com
DuckDB Ecosystem: April 2025 - MotherDuck Blog
DuckDB Monthly #28: DuckDB goes streaming, local caching & more! | Reading time: 9 min read
040
MotherDuck @motherduck.com · 03/04/2025
Faraz Hameed, winner of the hackathon we co-hosted with Airbyte, shares the story behind his winning project — an IoT use case powered by a modern data stack. motherduck.com/blog/simplif...
motherduck.com
Simplifying IoT Analytics with MotherDuck - MotherDuck Blog
Exploring the sweet spot between simplicity and capability in data systems, one IoT hackathon at a time. | Reading time: 7 min read
021
MotherDuck @motherduck.com · 01/04/2025
Prompting is so 2024. We’re pushing the boundaries of simplicity with @duckdb.org Meet Quack to SQL — our new AI model that turns quack into powerful SQL 👇 www.youtube.com/watch?v=XJWP...
youtube.com
Just quack, and we’ll code | Quack To SQL AI model
YouTube video by MotherDuck
1123
MotherDuck @motherduck.com · 27/03/2025
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!
041
MotherDuck @motherduck.com · 25/03/2025
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
000
MotherDuck @motherduck.com · 25/03/2025
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.com
Enterprise Tech 30 | Presented by Wing Venture Capital
The 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.
010
MotherDuck @motherduck.com · 22/03/2025
San Francisco Bay folks: Our friends at bem are hosting a panel on data + ai product building trends, red flags and curiosities. Featuring Jordan Tigani, ​Tomasz Tunguz and ​Karan Goel. Join us Wednesday 26 March in SF. Register here:
buff.ly
bem AI + data panel · Luma
Hi there! We at bem (we structure + contextualize data as an ambient business system) are hosting our next panel, this time, focused on Data + AI product…
020
Reposted by MotherDuck
Mehdi Ouazza @mehdio.com · 14/03/2025
If you missed the memo on the new @duckdb.org UI, I just just dropped a walkthrough video on @motherduck.com channel, check it out! 👇 www.youtube.com/watch?v=vCbO...
youtube.com
How to Use the New DuckDB UI – Fast, Free, and Local
YouTube video by MotherDuck
081
MotherDuck @motherduck.com · 13/03/2025
Psst: It's not over till it's over....the DuckDB Local UI is now LIVE on ProductHunt 🎉 Check it out and send us your feedback: www.producthunt.com/posts/the-du...
040
Reposted by MotherDuck
Chris Atkins @itscatkins.bsky.social · 12/03/2025
🦆 @duckdb.org local UI is honestly the best thing since sliced Parquet 🍞 Awesome work! @motherduck.com duckdb.org/2025/03/12/d...
duckdb.org
The DuckDB Local UI
The DuckDB team and MotherDuck are excited to announce the release of a local UI for DuckDB shipped as part of the ui extension.
191
MotherDuck @motherduck.com · 12/03/2025
Introducing the DuckDB Local UI, the easiest way to explore local data files with DuckDB. Built in close partnership with @duckdb.org for the community. duckdb -ui Learn more: duckdb.org/2025/03/12/d...
02310
Reposted by MotherDuck
DuckDB @duckdb.org · 12/03/2025
DuckDB got a local UI. Thanks to our friends at MotherDuck, you can now interact with your DuckDB database through an interactive notebook, running on localhost. Read the announcement blog post at duckdb.org/2025/03/12/d...
1017047
MotherDuck @motherduck.com · 10/03/2025
Are you ready? 03.12.2025
0123
Reposted by MotherDuck
Simon Späti 🏔️ @ssp.sh · 26/02/2025
Are you working with geospatial data, or have you been wondering why we even use it? Then, this article might be for you. Introducing & showcasing its ubiquitous use. Exploring DuckDB's spatial capabilities, transforming complex geographic analysis into simple SQL queries. Hacking on Foursquare.
motherduck.com
A Beginner’s Guide to Geospatial with DuckDB Spatial and MotherDuck - MotherDuck Blog
Unlock the power of geospatial analysis with DuckDB Spatial and MotherDuck, making location-based data processing faster, simpler, and more accessible for data engineers. | Reading time: 19 min read
1245
MotherDuck @motherduck.com · 25/02/2025
What does an “in-process” database mean? Let’s revisit the basics and explore the differences between OLTP and OLAP database setups 👇 youtube.com/shorts/yuA6N...
youtube.com
Understanding Key Differences Between OLTP vs OLAP Databases
YouTube video by MotherDuck
010