Skip to main content

Release notes

Welcome to our release notes, we're excited to hear about your experience 😃

info

💁 If you have any questions, please connect with us directly in our Community Slack support channel or send a note to support@motherduck.com.

For older updates, see the release notes archive.

July 9, 2026​

  • Write to Databricks-managed Iceberg tables: MotherDuck can now write to Databricks-managed Iceberg tables.
  • Flights available on all plans: Flights are now available on Free and Lite plans, in addition to Business.
  • Flight secrets available as non-namespaced environment variables: Flight secrets are now injected into the Flight runtime under both the namespaced <secret_name>_<KEY> name and the bare <KEY> name, so your code can read them without the secret_name prefix.
  • Status page updates: Users can now subscribe to updates on the MotherDuck status page to be notified about system health and scheduled maintenance. Refer to Service status for details.
  • Connect your tools: Integrations have been added to the Home page for easy access in the UI.
  • Dive statuses: Dives now carry a status (draft, ready, endorsed, or archived) to distinguish work-in-progress from vetted, endorsed Dives. Dive status shows up in the Dives list and the MCP/SQL tools for filtering and sorting.

July 2, 2026​

  • [Preview] Server-side Iceberg attach: Attach an external Apache Iceberg REST catalog to MotherDuck and query your Iceberg tables server-side, alongside your MotherDuck and DuckLake data. Available in Preview.
  • dbt Cloud support via the Postgres endpoint: You can now connect dbt Cloud to MotherDuck directly through the Postgres endpoint, without standing up a self-hosted pg_duckdb proxy.

June 25, 2026​

June 10, 2026​

  • [Preview] Launching Flights - agent-native data pipelines in MotherDuck: Build and deploy data pipelines using a flexible Python runtime, natively connected to your MotherDuck data — for ingest, transformation, warehouse replication, SaaS ETL, and more. Create and manage Flights via SQL, UI, or any MCP-capable AI agent. Available in Preview to Business and Enterprise plans. Read the announcement blog for more details and refer to the Flights documentation to get started.
  • Dives are generally available: Dives – interactive data apps you build from natural language and share across the MotherDuck UI, embeds, and MCP clients — have graduated from Preview to general availability (GA). Available on all plans.
  • MotherDuck cloud coverage extends to Europe (Dublin) eu-west-1: MotherDuck is available on AWS in Europe (Dublin) eu-west-1. Create new Organizations in Dublin for lower latency and regional data residency.
  • MotherDuck Wasm Client 1.5.3-r.1: Each release of the Wasm Client pins a specific DuckDB version instead of tracking the MotherDuck web UI's DuckDB version dynamically, so your DuckDB version stays predictable across deployments. Check pragma version to confirm which version is in use. This release builds on DuckDB 1.5.3 and adds the terminateDuckDB function, which resets the shared in-browser DuckDB instance so you can recreate it. Refer to the Wasm Client documentation to learn more.

June 2, 2026​

May 22, 2026​

  • Postgres wire protocol endpoint support for Looker: The Postgres Endpoint, a Postgres wire protocol-compatible MotherDuck client, now enables connectivity with Looker.
  • DuckDB & MotherDuck plugin for Obsidian: Run DuckDB SQL or MotherDuck queries from inside an Obsidian note, with results frozen as a markdown table directly below the query. Local DuckDB blocks run in Wasm with no account required; motherduck blocks reach your MotherDuck account for hybrid execution against shared databases. Install from the Obsidian Community Plugins directory.
  • Manual member deprovisioning: Organization admins can now deprovision and reactivate members directly from the Members page in Settings in the MotherDuck UI, without needing SCIM or an external identity provider.
  • Compound file extensions in Add Data: The Add Data UI now recognizes compound suffixes such as .parquet.zst, .csv.zst, and .parquet.snappy when detecting file types from object storage.
  • TOON-encoded responses from the MCP server: Responses from the MotherDuck remote MCP server are now encoded in TOON, a compact, token-efficient format for LLM consumption, reducing payload size on large result sets.
  • Pin a Dive version when embedding: Embed sessions now accept an optional version parameter so production embeds keep rendering a vetted Dive version even when the source Dive is edited. Omit it to follow the current version.
  • Dive Viewer in ChatGPT: The MCP Dive Viewer is now available as a ChatGPT app, rendering Dives inline in conversations.
  • "Open in MotherDuck" preserves Dive state: Clicking "Open in MotherDuck" from the MCP Dive Viewer now carries your current filters and selections through to the full MotherDuck UI.
  • Dive Viewer auto-refreshes stale tokens: Dives left open in browser tabs for hours no longer show "Invalid Token" errors. The session token now refreshes silently when the tab regains focus.

May 15, 2026​

  • SCIM provisioning: MotherDuck now supports SCIM, so you can manage MotherDuck users from your identity provider. Available on Business and Enterprise plans. Refer to the documentation for more details.
  • Per-session database override for Dives: Embedded Dives and the view_dive MCP tool now accept a required_resources parameter that overrides the Dive's source-declared REQUIRED_DATABASES for the session. This lets you point a single Dive at different databases per tenant or environment.
  • Share Dives with their current view: Share a Dive along with its interactive state — filters, drill-downs, sort orders, selected views. In the MotherDuck UI, the state is captured in the URL fragment, so sharing the URL lands recipients on the same view. In embedded Dives, state changes emit postMessage events your host page can listen for and persist in your application.
  • Preconfigure Dives with a starting UI state: A new initial_state parameter on embed sessions and the view_dive MCP tool loads the Dive with specific filters and selections already applied.
  • Data exports from Dives in MCP apps: The MCP Dive Viewer now lets users export Dive results as CSV, Parquet, or XLSX.
  • Claude Cowork support for the Dive Viewer: The MCP Dive Viewer now renders Dives inline in Claude Cowork, alongside existing MCP client support.

May 7, 2026​

  • Data exports from Dives: Dives can now include export buttons that deliver CSV, JSON, Parquet, or Excel files, both in the MotherDuck UI and in embedded Dives. Wire up exports from your Dive code with the new exportAs and useExport hooks from @motherduck/react-sql-query. Embedded exports are delivered to your host page through a postMessage channel and require dual mode, now the default for embedded Dives.
  • MotherDuck extends cloud coverage to Oregon us-west-2: MotherDuck is now available on AWS in Oregon us-west-2; users are able to create new Organizations in Oregon for lower latency and regional data residency.
  • Drizzle support via the Postgres endpoint: You can now connect to MotherDuck from Drizzle using the Postgres endpoint.

May 1, 2026​

  • Streamlined Dives sidebar: The Dives list in the Object Explorer is now capped at your 10 most recent Dives, with a new View all Dives link that opens the full searchable Dives table.
  • Wasm Client SDK no longer requires COI headers: The MotherDuck Wasm client SDK (now at version 1.5.2) no longer requires Cross-Origin Isolation (COI) headers, so custom DuckDB Wasm applications using LOAD motherduck can run in standard, non-COI environments. This change also brings faster transfers for larger payloads.
  • JIT provisioning enabled by default for SSO: When you activate SSO for the first time, Just-in-Time (JIT) provisioning is now on by default, so users from your verified domain can join the organization automatically on first login.
  • Link handling in Dives: When you click a link inside a Dive, MotherDuck surfaces a confirmation popup for external URLs so you can review the destination before opening it, and navigates directly for links that point inside the MotherDuck UI (for example, another Dive). Embedded Dives forward each click to the host page through a postMessage channel, so the parent app can apply its own navigation policy.

April 22, 2026​

  • Duckling Overview UI: MotherDuck Admins now have access to a Duckling Overview page in Settings for a view of activity across every Duckling in the organization over the last 24 hours, including key metrics like status, disk spills, active minutes, and query-level drilldowns.
  • Dive Viewer Inline Preview for Remote MCP Server: The MotherDuck remote MCP server now includes an inline preview Dive Viewer, allowing users and AI agents to create and view Dives directly in their chat workflow.
  • Removed Cross-Origin Isolation (COI) requirement for DuckDB Wasm: MotherDuck's DuckDB Wasm integration can now run in standard i-frames and non-COI third-party environments. This is already powering the MotherDuck UI and Embedded Dives, which default to dual execution for zero-latency client-side queries. Support for LOAD motherduck from custom DuckDB Wasm applications will follow in a future WASM SDK release.

April 16, 2026​

  • DuckDB 1.5.2 support: MotherDuck supports DuckDB 1.5.2, a bugfix release. Learn more in the official DuckDB Labs 1.5.2 announcement and changelog.
  • DuckLake 1.0 support: MotherDuck supports DuckLake 1.0. Learn more in the official DuckDB Labs DuckLake 1.0 announcement.
  • Concurrent checkpoints: Checkpoints can now run concurrently to reads, insertions and deletions. Previously they could block or be blocked by user queries and also interfere with share updates, as these require a checkpoint. Note that concurrent checkpoints require writes or deletions to be issued by DuckDB clients that are at least on version 1.5.

April 9, 2026​

  • Postgres wire protocol endpoint support for PowerBI: The Postgres Endpoint, a Postgres wire protocol-compatible MotherDuck client, now enables connectivity with PowerBI.

April 3, 2026​

  • [Preview] Embedded Dives: MotherDuck Dives can now be embedded directly in your customer-facing applications. Create a Dive, generate an embed session, and drop an iframe into your app. Your end-users can explore data in real time, powered by MotherDuck. Embedded Dives currently require a Business plan. Read the announcement blog for more details or refer to the documentation to get started.
  • Airbyte Connector Certified: MotherDuck is now a certified Airbyte destination. Refer to the Airbyte destination documentation for more details.
  • Customizable Sidebar: The Object Explorer sidebar is now fully customizable. Right-click any section to show, hide, or reorder it — or access the customization dialog from the command menu or the org menu. Your expand/collapse state is persisted across sessions.

March 25, 2026​

  • Configurable Duckling cooldown periods: The cooldown period for Standard, Jumbo, Mega, and Giga Ducklings can now be configured from 1 minute to 24 hours via the UI, SQL, or REST API. Learn more in the Duckling sizes documentation.
  • SHUTDOWN and SHUTDOWN TERMINATE commands: Two new SQL commands give you direct control over Duckling lifecycle without waiting for the cooldown period. SHUTDOWN shuts down a Duckling after running queries complete; SHUTDOWN TERMINATE force-terminates immediately. Both are subject to a 1-minute billing minimum and are useful for cost control in batch pipelines or CI/CD workflows where you want to stop billing as soon as work is done. See the command reference for details.
  • Dives Version History in UI: Every time you update a Dive, MotherDuck saves a version. Browse previous versions using the version picker in the top-right corner of any Dive or retrieve them programmatically with list_dives and read_dive. Version browsing is read-only — selecting an older version does not overwrite the latest.

March 24, 2026​

  • DuckDB 1.5.1 support: MotherDuck supports DuckDB 1.5.1 ("Variegata"). This release brings significant performance improvements including bloom filter join pushdown, stats-only min/max evaluation, faster TopN queries with late materialization, and lazy view binding. Note that the VARIANT data type and background checkpointing improvements are not yet supported in MotherDuck and will be made available in a future update. See the version lifecycle schedules for supported version ranges.
  • DuckLake 0.4: The DuckLake open table format has been updated to version 0.4, introducing deletion inlining, sorted compaction, stats-only COUNT(*), TopN file pruning, expression-based default values, and macro support.

March 12, 2026​

  • Postgres wire protocol endpoint support for Tableau Cloud: The Postgres Endpoint, a Postgres wire protocol-compatible MotherDuck client, now enables connectivity with Tableau Cloud.
  • Dives can now be remixed: A new 'Remix this Dive' menu option in the left-side object explorer opens ChatGPT or Claude with pre-filled metadata to help you explore and iterate on existing analysis and create new Dives.

March 6, 2026​

  • Postgres wire protocol endpoint: Query your MotherDuck databases using any Postgres-compatible client, including psql, Python libraries like psycopg2/psycopg3, JDBC drivers, and serverless platforms like Cloudflare Workers — without installing a DuckDB client library. The Postgres endpoint is ideal for serverless environments, languages without a DuckDB SDK, thin client architectures, or any tool that supports PostgreSQL data sources. See guides for Python, Java (JDBC), and Cloudflare Workers.

February 27, 2026​

  • Write support for the MCP server is now live: Users can now perform write operations via the MCP Server using the new query_rw tool. This enables programmatic data modification workflows in addition to read queries. Refer to the documentation and setup guide for read-only access for more details.

February 26, 2026​

  • Dives are now available on all plans: Dives are now available on all MotherDuck plans, giving users access to shareable visualizations built by AI agents and backed by composable SQL. Refer to the documentation for more details.
  • Faster edits for Dive Previews in Claude: Claude agents in Claude Web and Claude Desktop now apply edits to the existing Dive preview instead of re-generating it from scratch.
  • SSO support: MotherDuck now supports Single Sign-On (SSO) with Okta, Microsoft Entra ID, and federated SAML/OIDC. Refer to the documentation for more details.

February 19, 2026​

  • Visualizations with Dives: Create interactive visualizations directly in your MotherDuck UI using natural language. To get started, connect your AI agent (Claude, ChatGPT, Cursor, or any MCP-compatible client) to the MotherDuck MCP Server and ask it to build a Dive. The agent writes the SQL, configures the charts, and saves the visualization in your MotherDuck UI. Dives stay live and up-to-date and can be shared across your organization. Read the announcement blog and get started in the Dives documentation. Dives are now available on all MotherDuck plans at no additional charge.

February 5, 2026​

  • Expanded DuckDB Extension support in the MotherDuck MCP Server: The MotherDuck Remote MCP Server is now compatible with the DuckLake, Spatial, Iceberg, and Delta DuckDB extensions. Read more about using the MotherDuck MCP Server in the documentation.
  • Point-in-time Restore: Restore databases to previous states using automatic or named snapshots within a configurable retention window of up to 90 days. Use UNDROP DATABASE to recover deleted databases. Learn more in the launch blog post and the data recovery documentation.
  • DuckDB Database File Upload: Upload DuckDB database files (.duckdb, .db) from your laptop to MotherDuck using the "Add data" menu in the MotherDuck UI. Preview tables and schemas in the UI before copying to MotherDuck. See the documentation on loading DuckDB databases into MotherDuck to learn more about using DuckDB database files.

January 29, 2026​

January 23, 2026​

  • Expanded MCP Server support: The MotherDuck remote MCP Server now supports Warp, PearAI, Trae, Void, Positron, Supermaven, Aider, and JetBrains IDEs. Use your favorite AI assistant to answer questions about your data through natural conversation. See the MCP Server documentation to get started.
  • Add Data from Cloud Storage: Import data from Amazon S3, Google Cloud Storage, Cloudflare R2, and others directly in the MotherDuck UI. Click "Add data" and select "From cloud storage" to browse your bucket, select files (or use Wildcard mode for patterns), preview the data, and create tables. Learn more in the documentation for loading data from Cloud Storage.

January 8, 2026​

  • Giga Ducklings on Business plan: Users on any MotherDuck Business plan can now access Giga Ducklings, our largest compute Duckling size, built to tackle the largest, toughest, most complex data transformations. Configure your Duckling size in Settings > Ducklings.

December 17, 2025​

  • MotherDuck MCP Server: Your favorite AI assistant can now talk directly to your data. Connect Claude, ChatGPT, Cursor, or any MCP-compatible client to MotherDuck using the MotherDuck remote MCP Server at https://api.motherduck.com/mcp. Your agent can explore schemas, run read-only SQL queries, and answer questions about your databases through natural conversation. Learn more in the announcement blog, and MCP Server documentation.

December 16, 2025​

  • DuckDB 1.4.3: MotherDuck supports DuckDB 1.4.3, a bugfix release. Learn more in the official DuckDB Labs 1.4.3 announcement and changelog.
  • PlanetScale Postgres integration: Users of PlanetScale Postgres can now use pg_duckdb to push analytical queries to MotherDuck. Analytical queries are accelerated up to 200x faster with MotherDuck, and keep your Postgres cluster optimized for transactions. Learn more in the announcement blog, and integration documentation.
  • MotherDuck destination for Artie CDC: Artie now supports MotherDuck as a destination for CDC. Users of Artie can now stream changes from OLTP databases like PostgreSQL, MySQL, and MongoDB to MotherDuck in real-time. Learn more in the announcement blog, and Artie documentation.
  • Recent Queries added to MD_INFORMATION_SCHEMA: Organization admins on MotherDuck Business plans can now access a more realtime view of all currently running or recently completed queries across their full organization using the RECENT_QUERIES view. This view offers detail for queries not yet captured in the QUERY_HISTORY view. Both views are accessible in the MD_INFORMATION_SCHEMA.
  • New columns for query attribution in query history: The QUERY_HISTORY view along with the new RECENT_QUERIES view in the MD_INFORMATION_SCHEMA now contain session_name and duckling_id columns, making it easy to identify which Duckling executed each query, and group read scaling queries by session_name.
  • MotherDuck Wasm SDK 0.8: The MotherDuck Wasm Client now leverages a different mechanism for loading the MotherDuck Wasm extension, which makes it easier to control which version of the extension is loaded. Refer to the documentation to learn more.

December 12, 2025​

  • Query Scheduling Improvements: Small queries now complete faster without getting stuck waiting behind large, resource-intensive queries, even when heavy queries are processing in the background
  • Search Enhancements: The search bar in the top left pane of the Object Explorer can now be used to search for schemas, tables, and columns in addition to databases and shares
  • Dvorak Keyboard Support: Dvorak keyboard shortcuts are now supported in the MotherDuck UI
  • Column Comments added to the Table Summary: In the Table Summary, users can now hover over any column name to view its comments alongside the column name and type

December 4, 2025​

  • Transient storage filter in Settings: The Databases page in Settings in the MotherDuck UI now supports filtering by storage type
  • DESCRIBE and SUMMARIZE exports: Downloading the results of DESCRIBE and SUMMARIZE queries is now supported in the MotherDuck UI
  • DuckLake option in the Add Database menu: MotherDuck users can create a new DuckLake in the 'Add Database' modal in the left hand pane of the object explorer in the MotherDuck UI
  • Inline Docs are now available in the Query Editor: Notebook cells in the MotherDuck query editor provide function information on hover, showing function signatures, parameter types, return types, and descriptions without leaving the notebook. Inline Docs can be toggled on and off by going to the Preferences page in Settings.

November 14, 2025​

  • DuckDB 1.4.2: MotherDuck supports DuckDB 1.4.2, a bugfix release. Learn more in the official DuckDB Labs 1.4.2 announcement and changelog.
  • Full command menu now at Cmd/Ctrl+K: Access common MotherDuck UI actions from your keyboard, including generating query edits, adding notebook cells, creating notebooks, and navigating between pages. Open the command menu with Cmd/Ctrl+K and search for options. For quick access to generate query edits, use Cmd/Ctrl+Shift+E. (Note: Cmd/Ctrl+Shift+P no longer opens the command menu.)
  • Run queries across multiple notebooks: You can now run cells across multiple MotherDuck UI notebooks, and allowing each to queue and run. Hover over any notebook in the left sidebar to see how many cells are running or queued. Query cancellation is also more reliable across all notebooks.

November 6, 2025​

  • MotherDuck extends cloud coverage to Europe: MotherDuck is now available on AWS in Frankfurt eu-central-1; users are able to create new Organizations in Europe for lower latency and regional data residency
  • Expanded AI functions support for PROMPT(): The prompt function now supports additional parameters; MotherDuck users can now interact with Large Language Models (LLMs) directly from SQL with more customization and improved support for struct arrays, timestamps, and date and time values -
    • return_type: Generate strongly-typed outputs by specifying the exact SQL type to return
    • reasoning_effort: Use GPT-5 models with the prompt() function
  • MotherDuck Wasm SDK 0.7.0: The MotherDuck Wasm Client now supports attach_mode='single', simplifying query execution and improving resource predictability when working with a single database. Refer to the documentation to learn more.
  • Usernames added to Database listings in Settings: MotherDuck Admins can now see the usernames for human users and service accounts on the Databases page in Settings for more intuitive lookups
  • New export options for EXPLAIN: MotherDuck notebook cells now support copying or exporting EXPLAIN results to simplify query inspection
  • Enhanced Column Explorer experience for UUIDs: The Column Explorer now has added support for UUIDs and fields that default to top-N values for improved column-level insights and schema exploration. Refer to the documentation to learn more.

October 24, 2025​

  • Duplicate MotherDuck notebook cells: Duplicate cells in MotherDuck UI notebooks using the cell options menu or command menu. Access the duplicate option from the three-dot options menu on any cell, or use Cmd/Ctrl + Shift + P to open the command menu and search for "duplicate."

October 9, 2025​

MotherDuck now supports DuckDB versions 1.4.0 and 1.4.1, and DuckLake version 0.3 🎉

DuckDB 1.4 delivers performance gains with improvements like a rewritten sorting engine, more efficient small writes, and new SQL syntax including the MERGE statement. Learn more in the DuckDB 1.4.0 and 1.4.1 changelogs.

Performance improvements​

SQL syntax updates​

Parquet improvements​

Learn more in the official DuckDB Labs announcements for 1.4.0 and 1.4.1.

While you can continue using your current version of DuckDB with MotherDuck, we encourage you to upgrade your DuckDB clients to 1.4.1 as soon as you can to take advantage of the fixes and performance improvements.

[Preview] DuckLake 0.3​

As we announced earlier this year, MotherDuck now supports DuckLake, an integrated data lake and catalog format. DuckLake 0.3 makes working with DuckLake more robust, including CHECKPOINT for easy maintenance, new paths for Iceberg interoperability, spatial geometry types, and MERGE INTO support.

Learn more about using DuckLake databases in MotherDuck in the documentation, and the recent improvements in the DuckDB Labs announcement for DuckLake 0.3.

September 30, 2025​

  • Get help from MotherDuck Experts: Get a human helping hand with technical questions, troubleshooting, and best practices directly in the MotherDuck UI. Open "Expert help" from the Help menu to talk with our team, and you'll be notified of responses. Expert help is available with Business and Lite plans.
  • Transient option for database storage retention: Databases can now be created with transient retention, which provides a minimal retention period and no failsafe storage. This option can be useful for intermediate datasets or data easily reconstructed from external sources. Create transient databases in the UI or via CREATE DATABASE db_name (TRANSIENT). Transient databases are available with Business and Lite plans. Learn more in the storage management documentation.
  • Duplicate notebooks: Copy existing SQL notebooks to reuse query templates or create variations of your analysis. Find the duplicate option in any notebook's options menu in the left sidebar.
  • Monitor database storage in the MotherDuck UI: Organization admins can now review database storage metrics in the updated Databases page, showing current and cumulative database storage footprint over time. Learn more in the storage lifecycle documentation.

September 10, 2025​

  • Instances are now called Ducklings: We've updated our name for instances to better reflect their purpose as dedicated and scalable DuckDB instances that provide isolated, on-demand compute for each user's analytics workload in MotherDuck. Find the familiar instance controls now in Settings > Ducklings. This release does not affect the Admin REST API methods for instances. Learn more about how Ducklings are different from standard data warehouse instances in this blog post.
  • Rename Notebooks from the Object Explorer: SQL notebooks can now be renamed directly from the left sidebar using a notebook's options menu.
  • Enum support in prompt function: The PROMPT SQL function now supports enum types for consistent classification outputs. See the function documentation for details and examples.
  • Command menu in the MotherDuck UI: Navigate the MotherDuck UI from your keyboard using the new command menu. Quickly access common actions like adding notebook cells, creating notebooks, and navigating between pages. Try it out with "Open command menu" in the top-left Organization dropdown, or use Cmd/Ctrl + Shift + P

September 4, 2025​

  • Pre-filled names for service accounts and tokens: When creating service accounts and tokens in the Settings > Service Accounts page, names are now pre-filled with the following format to help differentiate between them:
    • Service Accounts: {creator_username}_service_account_{number}
    • Read-Write Tokens: {sa_username}_read_write_token_{number}
    • Read-Scaling Tokens: {sa_username}_read_scaling_token_{number}
  • DuckLake database icon in the MotherDuck UI: DuckLake-backed databases now display a distinct icon to easily distinguish them from databases using MotherDuck native storage.

August 21, 2025​

  • Support for H3 Spatial Indexing Extension: MotherDuck now supports the H3 DuckDB Extension, which adds support for the H3 hierarchical hexagonal grid system for geospatial analysis. This extension is pre-installed in MotherDuck, and users are not required to install this extension.

August 13, 2025​

  • GPT 5 Support in prompt function: The PROMPT function now supports OpenAI's GPT 5 series models. Refer to the function documentation for more details.

August 12, 2025​

  • Display Preformatted VARCHAR values: VARCHAR results in the MotherDuck UI data value pane now support display of preformatted text.
  • Format SQL in MotherDuck Notebook: Format any SQL statement using the new Format button in the notebook cell options menu, or with Option/Alt + Cmd/Ctrl + O. When text is selected, only the selection is formatted.

August 8, 2025​

  • Test S3 Credentials: MotherDuck users can now test S3 credentials directly in the MotherDuck UI on the Secrets page in Settings when adding new S3 secrets.
  • Support for DuckDB Configuration Options: With this release, MotherDuck now correctly respects DuckDB configuration options and their local defaults, including extension settings like TimeZone. Broader coverage of additional configuration options is planned for the upcoming DuckDB 1.4 release.

July 31, 2025​

  • Updated FixIt Keyboard Shortcut: The Escape key can now be used to reject FixIt suggestions, providing a quicker way to dismiss generated SQL fixes.
  • Generate Notebook Names: Get descriptive, context-aware names for notebooks in the MotherDuck UI based on their SQL content. Click the new "Generate name from SQL" button to the left of a notebook's name to try it out. Available for users in MotherDuck's Business and Lite plans.

July 25, 2025​

  • Data Grid UX Improvements: Data grids now include row numbers to make it easier to explore query results and reference specific rows. Users can now select multiple rows by clicking row numbers with the shift-key modifier.
  • New UX for FixIt: FixIt now includes keybindings for the toggles to accept and reject suggestions and turn automatic suggestions on and off.
    • Cmd/Ctrl + Enter: Accept suggestion and run query
    • Cmd/Ctrl + Shift + Backspace: Reject suggestion

July 16, 2025​

  • NEW - Larger Compute Instances: MotherDuck now offers two new memory-rich compute duckling (instance) types, Mega and Giga, built to run at high-capacity for the largest, most demanding jobs. Learn more in the launch blog and Docs.

July 14, 2025​

  • DuckDB 1.3.2: MotherDuck supports DuckDB 1.3.2, a bugfix release. Additional details are available in the DuckDB 1.3.2 changelog.
  • The Settings Button has Moved to the Org Dropdown: Settings has moved from the left sidebar into the Organization dropdown at the top left for easier access and a cleaner layout.
  • Admin Experience Enhancements: With this week's release, MotherDuck organization admins now have the flexibility to do more to manage their Org directly from the MotherDuck UI due to better visibility and admin-specific functionality for managing tokens, service accounts, and storage.
    • New Service Accounts Page in Settings: Organization admins can now view, create, and manage service accounts and service account tokens in the Service Accounts section of MotherDuck settings.
    • Impersonation of Service Accounts: Organization admins can now temporarily impersonate a service account while using the MotherDuck UI.
    • Storage Usage History added to MD_INFORMATION_SCHEMA: Organization admins can now access up to 30 days of historical storage data using the STORAGE_INFO_HISTORY view in the MD_INFORMATION_SCHEMA. Each record includes a result_ts timestamp showing when the storage metrics were calculated.

July 01, 2025​

[Preview] DuckLake Support: MotherDuck now supports DuckLake, an integrated data lake and catalog format.

  • MotherDuck currently provides two options for creating and integrating with DuckLake databases:
    • Fully managed: MotherDuck manages both data storage and metadata
    • Bring your own bucket (BYOB): Connect your S3-compatible object storage with options for:
      • MotherDuck compute + MotherDuck catalog
      • Bring-your-own-compute (BYOC) + MotherDuck catalog

Learn more in the documentation and announcement blog.

June 26, 2025​

  • Chat Widget Optimization: Users can now view their inline edit history in a more compact chat widget and quickly request follow-up changes when needed.

  • Improved Boolean cell styling: Boolean values in the data grid now have distinct visual weights to make it easier to visually scan result sets and prevent confusion with empty cells.

June 18, 2025​

  • DuckDB 1.3.1: MotherDuck supports DuckDB 1.3.1, a bugfix release. Additional details are available in the DuckDB 1.3.1 changelog.
  • PIVOT statements in MotherDuck UI: The MotherDuck UI now supports PIVOT statements, with pivot columns also appearing in the Column Explorer. PIVOT transforms distinct column values into separate columns with aggregated data.
  • New STORAGE_INFO View in MD_INFORMATION_SCHEMA: Organization admins can now review detailed storage breakdowns per database using the new STORAGE_INFO view in the MD_INFORMATION_SCHEMA.

June 12, 2025​

  • Improved query execution UX: After 5 seconds, the run button now displays a timer showing how long the query has been running. It also offers clearer visual cues for canceling a query on mouseover and focus.

June 5, 2025​

  • Overwrite a database with a zero-copy clone: The new COPY FROM DATABASE (OVERWRITE) command replaces all data in the target database with the source's contents in a single atomic operation, waiting for active writes to finish and blocking new ones during the process.
  • Copy SQL definitions for views from the Object Explorer: The dropdown menu for views in the left-hand panel of the MotherDuck UI now lets you copy the associated SQL definition without opening the table summary.

May 29, 2025​

MotherDuck now supports DuckDB version 1.3.0 🎉

DuckDB 1.3.0 improves performance in real-world scenarios for faster queries, new SQL syntax, and smarter Parquet file handling. Learn more in the changelog here.

Parquet improvements​

SQL syntax updates​

Parquet improvements​

Learn more in the official DuckDB Labs 1.3.0 announcement.

While you can continue using your current version of DuckDB, we encourage you to upgrade your DuckDB clients to 1.3.0 as soon as you can to take advantage of the fixes and performance improvements.

Additional updates from this release are outlined below -​

  • Query results now display in a redesigned table that delivers enhanced performance when viewing and exploring data - column headers now include type information for better context. Additional table functionality, including sorting and filtering of results, is coming in future releases.

May 22, 2025​

  • Faster queries on complex filters and wide tables: We've significantly boosted performance for queries with IN filters, selective joins, and LIMIT clauses. Expect noticeable speedups on wide tables or those with large string or JSON columns.
  • New keybindings for power users:
    • Toggle Instant SQL for the current SQL cell: cmd/ctrl+shift+.
    • Toggle Object Explorer: cmd/ctrl+b
    • Toggle Inspector (Column Explorer): cmd/ctrl+i
    • Toggle worksheet mode for the current SQL cell: cmd/ctrl+e
  • Org-wide Active Accounts: Organization admins can now view all active accounts and their associated ducklings in the Active Accounts section of MotherDuck settings.
  • Smarter Instant SQL caching: Instant SQL now accounts for filters in your WHERE clause when building its cache, offering a greater number of relevant rows as you work.
  • Full row count in flat table results: SQL cells now display a full result row count when viewing results in "flat" table mode.
  • GPT 4.1 Support in prompt function: The PROMPT function now supports OpenAI's GPT 4.1 series models. Refer to the function documentation for more details.

May 16, 2025​

  • Multiple SQL statements now supported in Instant SQL: Execute individual statements within multi-statement SQL cells by clicking on the desired statement while Instant SQL is enabled.
  • Copy Table Names directly from Object Explorer: Use the options menu on any table in the Object Explorer to copy its name to your clipboard. Paste exact table references into any SQL editor—eliminating typos and saving time when writing queries.

For earlier updates, see the release notes archive.