Motherduck · Blogs

Blogs listings from Motherduck on TechiSeek. 253 public listings.

• Internal vs. External Storage: What's the Limit of External Tables? (Motherduck)
  25 years of external tables, from Oracle 9i to DuckLake. external tables, why they keep getting re-added to every major data warehouse, and…
• From BigQuery to DuckDB and MotherDuck : Efficient Local and Cloud Data Pipelines (Motherduck)
  Learn how to query load table from BigQuery to DuckDB and MotherDuck using SQL and Python!
• MCP + DuckDB: Connect AI Assistants to Your Data Pipelines (Motherduck)
  Use the Model Context Protocol (MCP) to connect Claude, Cursor, or other AI tools directly to DuckDB.
• MotherDuck on Cloudflare Workers: real-time apps at the edge (Motherduck)
  Build a real-time voting app on Cloudflare Workers that queries MotherDuck through the Postgres endpoint, using Durable Objects for live st…
• Real-Time MySQL to MotherDuck Streaming with Streamkap: A Shift Left Architecture Guide (Motherduck)
  Build real-time MySQL to MotherDuck pipelines with Streamkap. Learn Shift Left architecture, streaming CDC, and how to replace batch ETL fo…
• Introducing the prompt() Function: Use the Power of LLMs with SQL! (Motherduck)
  Introducing the prompt() Function: Use the Power of LLMs with SQL! - 6 min read In recent years, the costs associated with running large la…
• This Month in the DuckDB Ecosystem: January 2024 (Motherduck)
  DuckDB news: Query Google Sheets with one line of SQL. Join across PostgreSQL, SQLite, and MySQL databases.
• Announcing the Data Outpost Conference (Motherduck)
  Data Outpost is a new conference for data and AI builders, coming to San Francisco November 4-5, 2026.
• Jev for analytics: turn text columns into gold, in plain SQL (Motherduck)
  Turn a free-text column into typed SQL columns with prompt_jev(): 100,000 consumer complaints classified in 82 seconds, at about 1% of a fr…
• Why you should learn SQL in 2024 (Motherduck)
  SQL is an accessible, ubiquitous, and valuable language you can learn in 2024. It’s a marketable skill that practically every organization…
• with DuckLake: A New Table Format for Your Lakehouse (Motherduck)
  with Duck Lake: A New Table Format for Your Lakehouse - 9 min read DuckDB just introduced a new table format named Duck Lake.
• What is MCP? A Data Person's Guide to Agentic Analytics (Motherduck)
  A Data Person's Guide to Agentic Analytics - 8 min read AI has gotten really good. But if you're a developer, you're probably still the bot…
• This Month in the DuckDB Ecosystem: October 2023 (Motherduck)
  DuckDB news: Enhanced CSV reader with dialect detection. Spatial data management course launches.
• Improved Control and Ergonomics on MotherDuck (Motherduck)
  November's Feature Roundup focuses on efficient query control and ergonomics. Now that's something to flap your wings about!
• The Open Lakehouse Stack: DuckDB and the Rise of Table Formats (Motherduck)
  The Open Lakehouse Stack: DuckDB and the Rise of Table Formats - 22 min read Wouldn't it be great to build a data warehouse on top of affor…
• Build It Yourself: What You'll Make at the Data Outpost Workshops (Motherduck)
  Data Outpost kicks off on November 4, 2026 in San Francisco with 11 hands-on workshops from MotherDuck, Vercel, Sigma, Prefect, Estuary, Ai…
• This Month in the DuckDB Ecosystem: April 2023 (Motherduck)
  DuckDB news: Mode adopts DuckDB for visual data exploration.
• Vibe Coding Comes for BI: A Tactical Guide for Analysts & Analytics Engineers (Motherduck)
  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…
• DuckDB 1.4.1 and DuckLake 0.3 Land in MotherDuck: New SQL Syntax, Iceberg Interoperability, and (Motherduck)
  MotherDuck now supports DuckDB 1.4.1 and DuckLake 0.3, with new SQL syntax, faster sorting, Iceberg interoperability, and more.
• Hello, World! Quack. Quack. (Motherduck)
  MotherDuck is building a serverless SQL analytics platform to use as a data warehouse and backend to data apps.
• Scalable Data Apps with MotherDuck & Replit (Motherduck)
  AI agents make building data apps easy, but what about deploying them or making sure they scale?
• I let an agent sign itself up to a cloud data warehouse, then replayed every step (Motherduck)
  AI agents can now provision a Postgres database, an email inbox or a data warehouse with no signup and no credit card.
• with modern GIS using DuckDB (Motherduck)
  with modern GIS using DuckDB - 10 min read Geospatial analysis has always been an important topic in data, but pretty hard to dive into.
• This Month in the DuckDB Ecosystem: November 2024 (Motherduck)
  DuckDB news: HTTP extension queries REST APIs in SQL. Drug database demo processes 6M records per minute.
• Agentic SQL for Free with Qwen3.8 27B and DuckDB (Motherduck)
  If your laptop has 16GB of RAM, your agent can write SQL locally for free with Qwen3.8 27B.
• MotherDuck Raises $47.5 Million to Make Analytics Fun, Frictionless and Ducking Awesome (Motherduck)
  MotherDuck is a new serverless data warehouse and backend for data apps based on DuckDB. MotherDuck provides SQL analytics at scale.
• Why Python Developers Need DuckDB (And Not Just Another DataFrame Library) (Motherduck)
  Why Python Developers Need DuckDB (And Not Just Another Data Frame Library) - 6 min read If you're working with Python and building data pi…
• DuckDB Ecosystem Newsletter : July 2026 (Motherduck)
  July's DuckDB Ecosystem Newsletter: a portable R2 + DuckLake analytics stack, why PostHog rebuilt on DuckDB over ClickHouse, DuckCon #7 and…
• DuckDB, MotherDuck, and Estuary: A Match Made for Your Analytics Architecture (Motherduck)
  DuckDB, Mother Duck, and Estuary: A Match Made for Your Analytics Architecture - 9 min read The data architecture field can seem littered w…
• Microbatch: how to supercharge dbt-duckdb with the right incremental model (Motherduck)
  Microbatch support in dbt-duckdb lets you process large tables in time-based batches — making incremental models recoverable, backfillable,…
• Performant dbt pipelines with MotherDuck (Motherduck)
  Learn how to take your dbt pipelines to new heights with MotherDuck. This blog walks through a recap of our recent dbt + MotherDuck worksho…
• Reflections on SIGMOD/PODS 2024: Insights and Highlights (Motherduck)
  MotherDuck Founding Engineer Stephanie Wang and AI/ML Lead Till Döhmen recap their highlights and key takeaways from SIGMOD PODS 2024 in Sa…
• Introducing HumanDB: The World's First Human-Powered Analytical Database (Motherduck)
  Introducing HumanDB: The World's First Human-Powered Analytical Database - 8 min read Over the past year, we've been pretty vocal about how…
• 5 Hidden gems in DuckDB 1.1 (Motherduck)
  DuckDB 1.1 was released on September 9, and we recently had a bug fix release, 1.1.1, out on September 23.
• This Month in the DuckDB Ecosystem: October 2025 | MotherDuck (Motherduck)
  DuckDB news: v1.4.0 LTS brings AES-256 encryption, MERGE statements, and Iceberg writes. 100x faster than Spark on local Parquet.
• MotherDuck acquires Tower.dev (Motherduck)
  MotherDuck Blog - MotherDuck Acquires Tower: Agents Can Answer.
• dbt Charts on MotherDuck: Declarative Dashboards (Motherduck)
  Define your dashboards in YAML with dbt Charts, then the same dbt build that runs your pipeline deploys them to MotherDuck Dives.
• Building an Obsidian RAG with DuckDB and MotherDuck (Motherduck)
  I always wanted a personal knowledge assistant based on my notes. One that uses Obsidian's backlinks and connections to surface ideas I've…
• The Data Engineering Toolkit: Essential Tools for Your Machine (Motherduck)
  Master the essential data engineering toolkit—Linux commands, Docker, Python, SQL, and developer tools.
• Big Data is Dead (Motherduck)
  For more than a decade now, the fact that people have a hard time gaining actionable insights from their data has been blamed on its size.
• MotherDuck + dbt: Better Together (Motherduck)
  My Personal DuckDB Story DuckDB has been charming to me ever since I wrote about it a year ago.
• DuckDB Ecosystem: June 2025 (Motherduck)
  DuckDB news: DuckLake combines catalog and table format with ACID metadata in SQL. Radio extension adds WebSocket and Redis Pub/Sub.
• This Month in the DuckDB Ecosystem: March 2024 (Motherduck)
  DuckDB news: Federated queries join PostgreSQL and blockchain data. PuppyGraph adds graph modeling on MotherDuck.
• What if a full data pipeline was one prompt away? (Motherduck)
  We launched Flights, an AI-native Python runtime in MotherDuck. Here's how I built a full end-to-end data pipeline (two scheduled Flights a…
• MotherDuck for Business Analytics: SOC 2 Type II, GDPR, and New Plan Offerings (Motherduck)
  Introducing new features designed to better support businesses looking for their first data warehouse, including SOC 2 Type II and GDPR com…
• Meet the New DuckDB Local UI: Analyze Data Visually, Right Where It Lives (Motherduck)
  Walkthrough of the new DuckDB UI features!
• DuckDB outgrows its nest | MotherDuck (Motherduck)
  Today Duck Labs, the developers of DuckDB, announced they are being acquired by Amazon. This is big news in the duck-iverse, and many peopl…
• MotherDuck CLI: query, pipelines, and dashboards from your terminal (Motherduck)
  Meet the MotherDuck CLI: one install to query data, publish Python pipelines, and host dashboards from your terminal, for coding agents and…
• This Month in the DuckDB Ecosystem: February 2023 (Motherduck)
  DuckDB news: v0.7.0 adds JSON ingestion, partitioned Parquet export, and UPSERT support. Benchmarks show 4-200x faster than Postgres on AWS…
• A Duck Walks into a Lake (Motherduck)
  DuckDB introduces a new table format, what does it mean for the future of data lakes ?