DuckDB, MotherDuck, Data Engineering and Data Analytics
Search and filter
Search and filter
Topic
2026/04/30 - Jacob Matson
The agent writes the SQL and the data viz now. Here's what's still your job — and how to implement data-layer changes that took a very hard natural language to SQL benchmark from 30% to 93% accuracy with Gemini Flash.
2026/04/30 - Dumky de Wilde
Track AI agent traffic that bypasses your web analytics. Stream Vercel Log Drains into MotherDuck to see how ChatGPT, Claude, and other agents browse your site.
2026/04/27 - Garrett O'Brien
April 2026 at MotherDuck: Duckling compute monitoring, Embedded Dives, agent Skills, DuckLake 1.0 support, and Power BI + Tableau via the Postgres Endpoint.
2026/04/27 - Garrett O'Brien
April 2026 at MotherDuck: Duckling compute monitoring, Embedded Dives, agent Skills, DuckLake 1.0 support, and Power BI + Tableau via the Postgres Endpoint.
2026/04/24 - Simon Späti
25 years of external tables, from Oracle 9i to DuckLake. When to use internal storage vs. external tables, why they keep getting re-added to every major data warehouse, and a benchmark showing the speed tax for cold data.
2026/04/21 - Dumky de Wilde
Build a real-time voting app on Cloudflare Workers that queries MotherDuck through the Postgres endpoint, using Durable Objects for live state and the pg package for analytical workloads.
2026/04/20 - Mehdi Ouazza, Samantha Lohier, Leonardo Vida
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/17 - Simon Späti
DuckLake 1.0 ships, Lance adds vector search, Rust-native extension
2026/04/16 - Alex Monahan
MotherDuck now supports DuckLake 1.0, the open table lakehouse format designed for simplicity and low latency. Learn what's new in the 1.0 release, including data inlining, clustering, bucket partitioning, geometry and variant types, plus multi-engine support. Learn how DuckLake compares with Apache Iceberg and Delta Lake.
2026/04/15 - Jordan Tigani
In a fully agentic world, will we still need analytics at all? A particularly unhinged example might offer some clues.
2026/04/10 - Mehdi Ouazza
Five fundamental data visualization principles that transform AI-generated dashboards from pretty charts into actionable insights. Learn chart selection, design, narrative, and interactivity.
2026/04/08 - Aditya Somani
Learn how to build a text-to-SQL LLM and LangChain SQL agent with DuckDB and MotherDuck, including schema inspection, query checking, and self-correction.
2026/04/03 - Jordan Tigani
What does AI think its own impact will be on the data and analytics industry? I asked Claude to share its predictions on the Modern Data Stack, data jobs, and the future of analytics.
2026/04/02 - Garrett O'Brien, Hamilton Ulmer
Real-time, interactive data apps – now embedded anywhere in your application. Created by your favorite agents and powered by dual execution.
2026/04/01 - Jordan Tigani
2026/03/31 - Louisa Huang, Jelte Fennema-Nio, Sheila Sitaram, Garrett O'Brien
MotherDuck's Postgres endpoint lets you query your data warehouse using any PostgreSQL-compatible client, driver, or BI tool — no new dependencies needed.
2026/03/27 - Simon Späti
Mark Freeman, Head of DevRel at Gable, shares his Spec-Driven Development workflow for producing high-quality, reproducible AI outcomes using Claude Code, ExcaliDraw diagrams, JSON schemas, and agent teams with tmux.
2026/03/25 - Ryan Boyd, Mehdi Ouazza
Share interactive, AI-built data apps with anyone through a unique link — queries run live on MotherDuck compute.
2026/03/24 - Alex Monahan
Learn how MotherDuck's Hosted DuckLake combines lakehouse scale (borrowing the best ideas from Apache Iceberg and Delta Lake) with low latency and agent sandbox isolation, making it the simplest data lakehouse for AI-powered agentic workflows.
2026/03/23 - Jordan Tigani
If the Modern Data Stack isn't yet dead, it's at least incredibly sleepy. AI is bringing the "long run" closer than ever — here's what might come next for ETL, BI, data warehouses, and the role of data engineers.
2026/03/19 - Garrett O'Brien
More tool calls, more schema exploration, more verification — does it help, or hurt? We dug into the chain-of-thought traces behind one of the hardest text-to-SQL benchmarks to understand how analytics agents actually think.
2026/03/13 - Simon Späti
SQL Transpilers, VS Code Extensions, Dives and more
2026/03/09 - Alex Monahan
DuckDB 1.5 is both faster and easier to use! JSON analysis can be up to 100x faster thanks to the VARIANT type and JSON shredding. Real-world queries are faster, including both basic and complex queries. Writes to Azure are supported, and checkpoint concurrency is dramatically improved.
2026/03/06 - Mehdi Ouazza
MCP explained for data people: what it is, how it works, and how to connect your AI agent to your databases and tools
2026/03/05 - Garrett O'Brien, Louisa Huang
Local development, version control, and automated CI/CD deployments for MotherDuck Dives — composable data visualizations that are just code.
2026/03/03 - Garrett O'Brien
The MotherDuck remote MCP server now supports write operations. Learn how zero-copy clones, snapshots, and hypertenancy make it safe to let agents build in your data warehouse.
2026/03/02 - Alex Monahan
Learn how to build custom interactive data visualizations using MotherDuck Dives and Claude Code. From setup to sharing, create refreshable React and SQL-powered visuals with natural language prompts.
2026/02/25 - Jacob Matson
Explore first, find the story, iterate on the artifact, test in MotherDuck. The workflow I keep coming back to after weeks of building.
2026/02/24 - Simon Späti
Comparing Git-like Tools That Separate Metadata from Data
2026/02/19 - Jordan Tigani
AI is eating the data stack. Introducing Dives, a new MotherDuck feature that lets AI agents build shareable, real-time data visualizations with composable SQL.
2026/02/11 - Simon Späti
MSSQL Extension, Vortex File Format & 2TB Memory Benchmarks
2026/02/06 - Jacob Matson
I ran 500 text-to-SQL questions against three frontier LLMs with zero context beyond the schema. 95% accuracy. No semantic layer required.
2026/02/05 - Simon Späti
Build a local-first RAG for your Obsidian notes using DuckDB's vector search, then deploy it as a serverless web app with MotherDuck
2026/02/04 - Sheila Sitaram, Joseph Hwang, Nicholas Greenspan
MotherDuck now supports point-in-time restores, making it easier than ever to roll back changes, undrop databases, and debug pipelines.
2026/02/02 - Dumky de Wilde
Microbatch support in dbt-duckdb lets you process large tables in time-based batches — making incremental models recoverable, backfillable, and parallelizable without rebuilding from scratch.
2026/01/23 - Jacob Matson
From #N column references to boolean math, explore the extreme techniques used to solve the Quackmas 2025 SQL Golf challenge.
2026/01/17 - Simon Späti
DuckDB news: Iceberg extension adds full DML (INSERT/UPDATE/DELETE). Process 1TB in 30 seconds. Query data via AI agents with MCP server. TypeScript macros for APIs.
2025/12/29 - Hannah Rifkin
We built a Spotify-style "Wrapped" for MotherDuck employees using our own platform. Discover the SQL queries, data tricks, and fun personas behind our internal leaderboard.
2025/12/23 - Jacob Matson
What if AI could discover your business logic by mining query history instead of requiring manual metric definitions? Explore how LLMs are replacing static semantic layers with systems that learn from actual usage.
2025/12/22 - Carly Spoljaric, Jerel Navarrete
MotherDuck spent fall on the conference circuit across Europe and the US. Here's what we presented and the pattern that emerged in nearly every conversation about analytics.
2025/12/19 - Ryan Boyd
My personal reflections from watching Jordan Tigani’s keynote "The Unbearable Bigness of Small Data" at Small Data SF. Most data warehouses are overbuilt for scale you'll never need. Learn how to stop paying the complexity tax.
2025/12/18 - Till Döhmen
How MotherDuck built a production-ready remote MCP server—from OAuth proxy challenges with Auth0 to tool design patterns that help AI agents query data warehouses effectively. Includes lessons from a hackathon where agents ran 4,000+
2025/12/17 - Jordan Tigani
Discover how MotherDuck's MCP server enables true self-service analytics through AI agents. Query data in plain English with Claude, ChatGPT, or Gemini—no SQL required.
2025/12/16 - Garrett O'Brien, Jacob Matson
Run analytics 200x faster on PlanetScale Postgres with MotherDuck integration. Keep millisecond transactions while pushing analytical queries to serverless compute.
2025/12/12 - Jacob Matson
Christmas presents have vanished! Use your SQL skills to solve the mystery on DBQuacks and win prizes. 15 challenges. One leaderboard.
2025/12/11 - Garrett O'Brien
CDC streaming takes flight with Artie’s new MotherDuck destination.
2025/12/10 - Simon Späti
DuckDB news: v1.4 adds AES-256 encryption. DuckLake brings ACID-compliant lakehouse with time-travel queries. Gaggle extension queries Kaggle datasets directly via SQL.
2025/12/03 - Simon Späti
Speed up slow dashboards without adding new infrastructure. Learn how DuckDB's caching extensions can drop query times from minutes to seconds.
2025/11/24 - Simon Späti
This article explores how to bring Git style workflows like branching, testing, and deploying to your data stack. Learn how concepts like zero copy cloning and metadata pointers can finally give you isolated test environments.
2025/11/19 - Diptanu Gon Choudhury
Learn how to query unstructured documents with friendly SQL!
2025/11/14 - Garrett O'Brien
Dive into a recap of the world's hottest efficiency-themed data conference, Small Data SF!
2025/11/12 - Simon Späti
DuckDB news: QuackStore caching cuts query time from 49s to 3s. Infera runs ONNX ML models in SQL. 127 community extensions analyzed. DuckLake architecture explained.
2025/10/30 - Simon Späti
A great panel answering the most voted/commented data questions on Reddit
2025/10/28 - Jordan Tigani
Benchmarks, efficiency, and how MotherDuck just got nearly 20% faster.
2025/10/09 - Alex Monahan, Garrett O'Brien
MotherDuck now supports DuckDB 1.4.1 and DuckLake 0.3, with new SQL syntax, faster sorting, Iceberg interoperability, and more. Read on for the highlights from these major releases.
2025/10/08 - Mehdi Ouazza
Understand why a database is much more than just a dataframe library
2025/10/07 - Simon Späti
DuckDB news: v1.4.0 LTS brings AES-256 encryption, MERGE statements, and Iceberg writes. 100x faster than Spark on local Parquet. Official Docker images released.
2025/09/24 - Garrett O'Brien, Sheila Sitaram
Serverless analytics built on DuckDB, running entirely in the EU.
2025/09/09 - Patrick Garcia
Discover how Galileo.world is revolutionizing geospatial analysis. Say goodbye to slow performance and complex setups. Analyze and visualize big data right in your browser.
2025/09/09 - Simon Späti
DuckDB news: Spatial joins 58x faster via R-tree indexing. pg_duckdb 1.0 adds OLAP analytics to PostgreSQL. One team cut Snowflake costs 79% using DuckDB caching.
2025/09/03 - Jelte Fennema-Nio, Jacob Matson
PostgreSQL gets a DuckDB-flavored power-up for faster analytical queries without ever leaving Postgres.
2025/08/29 - Vasilije Markovic
SQL analytics and graph-native retrieval together, eliminating the trade-off between fast analytics and one-off RAG retrievals.
2025/08/22 - Jacob Matson
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
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
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 - Oli Dinov
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/07 - Simon Späti
DuckDB news: 50.7% YoY developer growth. DuckLake v0.2 adds credential secrets. BigQuery extension hits 21.7k weekly downloads. Vector search enables RAG applications.
2025/08/04 - Jacob Matson, Alex Monahan
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
Stay in flow with MotherDuck's latest features. Real-time SQL feedback and natural language editing.
2025/07/21 - Simon Späti
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
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
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!
2025/07/15 - Mehdi Ouazza
Learn how to keep LLMs updated with llms.txt and Cursor's docs feature.
2025/07/08 - Simon Späti
DuckDB news: Tributary streams Kafka data to SQL queries. SQLRooms enables browser analytics via DuckDB-WASM. pg_duckdb benchmarks show 1,500x TPC-DS speedup.
2025/07/03 - Simon Späti
Explore the top data engineering tools and platforms of 2026. This guide details the essential DevOps tools, CI/CD practices, and infrastructure needed to build a modern, scalable data platform.
2025/07/01 - Ryan Boyd
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 support for massive scale historical data.
2025/06/27 - Jacob Matson
Stop debugging AI-generated SQL queries. Learn the exact Cursor + MotherDuck setup that makes AI write working SQL on the first try, with step-by-step instructions.
2025/06/16 - Jacob Matson, Aditya Somani
Learn how to integrate PostgreSQL with DuckDB and MotherDuck for faster analytics. Compare DuckDB Postgres Extension, pg_duckdb, and CDC approaches with practical examples and best practices for each method.
2025/06/13 - Thomas (TFMV) McGeehan
Understand how Flight SQL can speed up how your serve data with DuckDB
2025/06/09 - Mehdi Ouazza
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/06 - Simon Späti
DuckDB news: DuckLake combines catalog and table format with ACID metadata in SQL. Radio extension adds WebSocket and Redis Pub/Sub. Top CSV benchmark results.
2025/06/01 - Sheila Sitaram
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 major release.
2025/05/30 - Mehdi Ouazza
Learn how to query load table from BigQuery to DuckDB and MotherDuck using SQL and Python!
2025/05/28 - Jordan Tigani
DuckDB introduces a new table format, what does it mean for the future of data lakes ?
2025/05/27 - Jacob Matson
Learn how to use the DuckDB Excel extension to directly read, import, and write XLSX files using the read_xlsx function. Plus, MotherDuck tips.
2025/05/23 - Simon Späti
Learn how DuckDB and open table formats like Iceberg power a fast, composable analytics stack on affordable cloud storage
2025/05/17 - Ryan Boyd
How to ingest and query CSV files in DuckDB using auto-detection, sniffing, manual configuration and more.
2025/05/12 - Mehdi Ouazza
Walkthrough of the new DuckDB UI features!
2025/05/08 - Simon Späti
DuckDB news: Metabase driver queries Parquet files directly. FlockMTL integrates LLMs into SQL workflows. Doom clone runs in DuckDB-WASM. Spatial wins top honors.
2025/05/06 - Jacob Matson
Use MotherDuck to power your Tableau Cloud, Server, and Desktop dashboards.
2025/04/23 - Hamilton Ulmer
Type, see, tweak, repeat! Instant SQL is now in Preview in MotherDuck and the DuckDB Local UI. Bend reality with SQL superpowers to get real-time query results as you type.
2025/04/18 - Simon Späti
How to Query JSON and Log Files with SQL Using DuckDB and MotherDuck
2025/04/17 - Emily Lucek
Ducks and estuaries go together. So it’s no surprise that MotherDuck, a cloud data warehouse, pairs well with Estuary, a data pipeline platform.
2025/04/16 - Ryan Boyd
aka What the duck is a Duckling?
2025/04/15 - Mehdi Ouazza
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/05 - Simon Späti
DuckDB news: Streaming support with new remote file caching. Community extensions expand real-time analytics. Event-driven processing patterns for data pipelines.
2025/04/03 - Faraz Hameed
Exploring the sweet spot between simplicity and capability in data systems, one IoT hackathon at a time.
2025/04/01 - MotherDuck team
Quack to SQL — our first AI model that understands duck sounds and translates them into queries.
2025/03/28 - Simon Späti
Understand when to use a vector database and how it differs from vector search engines.
2025/03/07 - Jacob Matson, Andrew Witten
Duckfooding MotherDuck with the postgres scanner
2025/03/07 - Simon Späti
DuckDB news: v1.2 adds Google Sheets extension for SQL on spreadsheets. Duckberg queries Iceberg tables via Python. Smallpond sorts 110TB in 30 min using Ray.
2025/03/06 - Daniel Palma, Emily Lucek
Stream data to MotherDuck with Estuary
2025/02/26 - Simon Späti
Unlock the power of geospatial analysis with DuckDB Spatial and MotherDuck, making location-based data processing faster, simpler, and more accessible for data engineers.
2025/02/20 - Adithya Krishnan
Learn how to build an unstructured data pipeline. This guide covers ETL, chunking, and generating vector embeddings directly in MotherDuck using Unstructured.io.
2025/02/14 - Amrutha Gujjar
Faster health data analysis with MotherDuck & Preswald
2025/02/12 - Marc Dupuis
Interactive, shareable sentiment analysis dashboard with MotherDuck & Fabi.ai
2025/02/11 - Sheila Sitaram
Introducing new features designed to better support businesses looking for their first data warehouse, including SOC 2 Type II and GDPR compliance, tiered support, read scaling, and a new Business Plan.
2025/02/09 - Simon Späti
DuckDB news: DuckCon #6 runs TPC-H SF300 on Raspberry Pi. SQL/PGQ graph queries 10-100x faster than Neo4j. Arrow Flight enables concurrent read/write access.
2025/02/05 - Sheila Sitaram
DuckDB 1.2 has launched, with improvements in performance, the SQL experience, CSV handling, and scalability - all fully supported in MotherDuck!
2025/02/04 - Mehdi Ouazza
Learn how you can pragmatically use DuckDB to parse any CSVs
2025/01/22 - Simon Späti
Master the essential data engineering toolkit—Linux commands, Docker, Python, SQL, and developer tools. A practical guide to the tools every DE needs.
2025/01/16 - Jacob Matson
Spark the Joy of beautiful local development workflows with MotherDuck & dbt
2025/01/10 - Simon Späti
DuckDB news: PyIceberg enables local Iceberg catalogs in Python. Zero-egress data sharing via Cloudflare R2. SQLFlow streams Kafka and Bluesky data with DuckDB SQL.
2024/12/21 - Sheila Sitaram
December’s feature roundup is focused on improving the user experience on multiple fronts. Introducing the User Management REST API, the Table Summary, and a read-only MD_INFORMATION_SCHEMA for metadata.
2024/12/20 - Mehdi Ouazza
Spot the fake (AI generated) duck to win!
2024/12/19 - Jacob Matson, Aditya Somani
Supercharge your window functions with MotherDuck SQL
2024/12/18 - Mehdi Ouazza
Learn how analytical database can help your web app, with MotherDuck and the native integration with Vercel
2024/12/17 - Jordan Tigani, Boaz Leskes
Why separate storage and compute in DuckDB, how we do it in MotherDuck to enable sharing and future work.
2024/12/12 - Adithya Krishnan
Leveraging LLM workflow in your data pipelines
2024/12/11 - Myles Scolnick
Visualizing text embeddings using MotherDuck and marimo
2024/12/11
DuckDB news: Query Bluesky social data via SQL. LLMs clean CRM data inside queries. Google Sheets extension launches. DuckDB-WASM powers sql-workbench.com browser IDE.
2024/12/09 - Sheila Sitaram
MotherDuck's native integration is now available on Vercel Marketplace. Developers can finally streamline their application maintenance overhead when building embedded analytics components and data apps. Start building with templates and a demo app!
2024/12/04 - Jordan Tigani
Read Scaling is now in preview! Read Scaling improves DuckDB SQL query performance by scaling out to multiple DuckDB instances, known as Read Scaling replicas. It is useful to speed up BI dashboards and data apps significantly.
2024/12/03 - Sahil Gupta
Learn how DoSomething, the premier platform fueling young people to change the world and actively shape the future of their communities, decided to adopt MotherDuck as their analytics data warehouse for efficient, high ROI analytics without the overhead.
2024/11/25 - Sheila Sitaram
November's Feature Roundup focuses on efficient query control and ergonomics. Now that's something to flap your wings about! Read on for updates on query management, in-memory performance, and connection management.
2024/11/20 - Simon Späti, Mehdi Ouazza
Discover how to build data pipelines to get insights from Bluesky
2024/11/14 - Mehdi Ouazza
Discover how catalog became crucial for Lakehouse and how DuckDB can help as a catalog
2024/11/12 - Simon Späti
Discover how companies are running DuckDB in production
2024/11/07 - Jordan Tigani
Using MotherDuck’s Dual Query execution on a Raspberry Pi to play a quack sound when users sign up for our service.
2024/11/04 - Simon Späti
DuckDB news: HTTP extension queries REST APIs in SQL. Unity Catalog integration via dbt. Pivot tables extension. Drug database demo processes 6M records per minute.
2024/11/01 - Jacob Matson
Learn how DuckDB and MotherDuck transform data into business insights. DuckDB’s fast SQL processing meets MotherDuck’s cloud integration, creating a flexible, powerful data warehouse solution to solve complex business challenges and drive impact.
2024/10/31 - Mehdi Ouazza, Ryan Boyd
Learn DuckDB from scratch: install in 2 minutes, set up VSCode, and build your first SQL analytics project. No database experience required.
2024/10/23 - Jelte Fennema-Nio, Mehdi Ouazza
pg_duckdb makes elephants fly, marking its first release.
2024/10/22 - Doug Raymond
Recently-launched features in the MotherDuck data warehouse: preview result cell contents UI, dual execution performance improvements, auto update of data shared within your organization (or globally!)
2024/10/19 - Sheila Sitaram
Catch up on the latest developments around simple, scalable workflows for Real data volumes from the first Small Data SF!
2024/10/18 - Daniel Sola
Leverage MotherDuck & Union to orchestrate advanced analytics flows, AI & LLMs
2024/10/17 - Till Döhmen
We make your database smarter with small language model (and LLM) support in SQL
2024/10/16 - Simon Späti
Let's take a closer look to understand the various Enterprise use cases of DuckDB and how they can help on your data and analytics journey.
2024/10/07 - Jacob Matson
Learn how to take your dbt pipelines to new heights with MotherDuck. This blog walks through a recap of our recent dbt + MotherDuck workshop from Small Data SF. Happy building!
2024/10/04 - Simon Späti
DuckDB news: v1.1 hits 6M monthly Python downloads. Spark API compatibility layer added. Build RAG apps with GPT-4o embeddings. Extensions reach 17M monthly downloads.
2024/10/01 - Jerel Navarrete
Get ready to make a splash at Coalesce 2024! 🦆 MotherDuck is bringing the fun to Las Vegas, and we can't wait to see you there. Whether you're a seasoned Coalesce pro or a first-timer, we've got everything you need to make this year's event unforgettable.
2024/09/27 - Mehdi Ouazza
Discover some underrated features from DuckDB 1.1
2024/09/18 - Mehdi Ouazza
Learn how DuckDB can help you started with Geospatial analysis
2024/09/06 - Till Döhmen
How to generate a web app dashboard based on your data
2024/09/04 - Jacob Matson
Learn how to use DuckDB's read_csv functionality to easily load data from Google Sheets into MotherDuck for Analysis!
2024/09/03 - Mehdi Ouazza
DuckDB news: pg_duckdb brings analytical queries to PostgreSQL. Ibis makes DuckDB its default backend, dropping Pandas. Getting Started with DuckDB book released.
2024/08/29 - Sheila Sitaram
We had such an awesome response to Small Data SF after launch: It was so great that we decided to add an additional day of hands-on workshops! Learn more about the full lineup on 9/23 - 9/24 and grab a ticket before it's too late.
2024/08/15 - Jordan Tigani, Brett Griffin
Introducing the DuckDB + Postgres Extension: You can have your analytics and transact them too with pg_duckdb by DuckDB Labs, MotherDuck, Hydra, Neon and Microsoft.
2024/08/14 - Till Döhmen
Doing RAG for LLMs or making semantic search results pop? MotherDuck and DuckDB make it easy!
2024/08/07 - Jordan Tigani
Jordan Tigani revisits his popular Big Data is Dead blog post with analysis of the data from the Redshift TPC is Not Enough paper.
2024/08/01 - Mehdi Ouazza
DuckDB news: Ranked #3 most desired database (StackOverflow 2024). Community extensions launch with registry. Delta Lake support via kernel. Memory management deep dive.
2024/07/19 - Andrew McEwen
The MotherDuck x Secoda integration allows you to enable data producers and consumers, regardless of technical ability, to easily locate and access the data they need! Learn how to enable the integration in two easy steps.
2024/07/18 - Sheila Sitaram, MotherDuck team
Read through the key principles and ethos behind the Small Data movement. Small data and AI is more powerful than you think. Data and AI that was once "Big" can now be handled by a single machine.
2024/07/16 - Ryan Boyd
Bring the Flock Together!
2024/07/15 - Mehdi Ouazza
using SQL, Markdown, DuckDB and MotherDuck to build a live dashboard
2024/07/03 - Saqib Rasul
Learn how to integrate MotherDuck and Geobase to visualize and build applications that have never been possible before using spatial-temporal data.
2024/07/02 - Stephanie Wang, Till Döhmen
MotherDuck Founding Engineer Stephanie Wang and AI/ML Lead Till Döhmen recap their highlights and key takeaways from SIGMOD PODS 2024 in Santiago, Chile. Learn more about emerging trends in Text2SQL, Hybrid Resource Allocation, Data Discovery, and more.
2024/07/01
DuckDB news: Native Delta Lake joins Iceberg for lakehouse support. DuckDB-WASM embeds full analytics in browsers. Vector search and embeddings tutorials. 12GB test data in 12s.
2024/06/20 - Adithya Krishnan
Explore search methods with DuckDB using Full-Text-Search and embeddings in a hybrid search engine fully accessible using SQL
2024/06/19 - Mehdi Ouazza
Explore DuckDB Wasm for fast, in-browser analytical SQL. Learn how to instantiate the JS API, query Parquet files, and export data to CSV with zero latency.
2024/06/11 - MotherDuck team
Turbocharge DuckDB's efficiency with multiplayer cloud analytics
2024/06/08 - Ryan Boyd
DuckDB news: v1.0.0 Snow Duck is production-ready. Query 150,000+ Hugging Face datasets directly. Crunchy Bridge adds DuckDB analytics to PostgreSQL. RAG implementations.
2024/06/03 - MotherDuck team
MotherDuck congratulates DuckDB Labs on their milestone, landmark 1.0 release. Learn more about its significance and what it means for MotherDuck! And stay tuned for some exciting news heading your way soon...
2024/05/08 - Sean M. Tracey
We stopped sifting our log data and started generating speedy logging insights to realize 95% in cost savings by pre-processing logs with Bacalhau and MotherDuck. How is that even possible? Let's walk through a step-by-step overview together.
2024/05/06 - Adithya Krishnan
Using DuckDB as the underlying storage for an AI-powered knowledge base, walk through a step-by-step tutorial using LlamaIndex, a data framework for LLMs, and Ollama, a simple API for creating, running, and managing models.
2024/04/30 - Luciano Galvão Filho
DuckDB news: Improved malformed CSV parsing. duckplyr brings DuckDB speed to R workflows. Parse 1 billion rows in Python efficiently. Geospatial raster via spatial extension.
2024/04/29 - Vasilije Markovic
Learn how to optimize Retrieval-Augmented Generation (RAG) systems with DuckDB, dlt, and Cognee to streamline data management and workflows for accurate LLM outputs.
2024/04/24 - Tino Tereshko
Learn how to use the MotherDuck WebAssembly (Wasm) SDK to solve the longstanding challenges of building and maintaining efficient, highly performant data-driven components and analytics applications.
2024/04/19 - Adithya Krishnan
Discover the power of AI search by using vector embeddings in natural language processing in the first blog in our informative three-part series! We'll cover the basics of vector embeddings and cosine similarity using DuckDB and MotherDuck.
2024/03/28 - Mehdi Ouazza
DuckDB news: Federated queries join PostgreSQL and blockchain data. PuppyGraph adds graph modeling on MotherDuck. End-to-end dbt pipelines. Co-creator Hannes interview.
2024/03/26 - Zhenni Wu
Discover how integrating DuckDB and PuppyGraph enables the incorporation of graph querying into your existing data warehouse!
2024/03/22 - Mehdi Ouazza
Learn how to build a production-ready data pipeline using dbt and DuckDB. Discover how to configure the dbt-duckdb adapter for local and cloud workflows.
2024/03/11 - Joseph Hwang
Differential Storage: A Key Building Block For A DuckDB-Based Data Warehouse
2024/03/01
2024/03/01 - Ryan Boyd
DuckDB news: v0.10.0 adds backwards-compatible storage and faster CSV parsing. PyAirbyte uses DuckDB as default cache. DuckDB-NSQL-7B LLM generates SQL locally.
2024/02/14 - Hamilton Ulmer
Column explorer : fewer queries, more insights
![DuckDB & Python : end-to-end data engineering project [1/3]](/_next/image/?url=https%3A%2F%2Fmotherduck-com-web-prod.s3.amazonaws.com%2Fassets%2Fimg%2Fblog_thumb_e2e_de_adf0434a84.png&w=3840&q=75)
2024/02/09 - Mehdi Ouazza
A end-to-end data project to explore DuckDB with Python
2024/01/31 - David Neal
SQL is an accessible, ubiquitous, and valuable language you can learn in 2024. It’s a marketable skill that practically every organization needs.
2024/01/30 - Ryan Boyd
DuckDB news: Query Google Sheets with one line of SQL. Join across PostgreSQL, SQLite, and MySQL databases. ERPL extension connects SAP data. Harlequin terminal IDE launches.
2024/01/25 - Till Döhmen, Jordan Tigani
Our first Text2SQL model release!
2024/01/24 - Mehdi Ouazza
Using CDC pipelines to stream data to MotherDuck