M

MotherDuck Release Notes

M
MotherDuck Release Notes Data & Analytics

[Preview] Guides: You can now teach AI agents your organization's context with Guides: mar

[Preview] Guides: You can now teach AI agents your organization's context with Guides: markdown documents in MotherDuck holding your metric definitions, join rules, columns to avoid, and conventions for Dives and Flights. Agents read them automatically through the MCP server, so every session writes SQL against the same definitions instead of rediscovering them. Share guides org-wide to align ever…

M
MotherDuck Release Notes Data & Analytics

Role-based access controls (RBAC): Admins can assign roles and grant scoped privileges to

Role-based access controls (RBAC): Admins can assign roles and grant scoped privileges to control access to databases, shares, and platform-level resources using the Members and Roles page in Settings. RBAC is available on Business and Enterprise plans; custom roles are also available for Enterprise customers. Read and write to Cloudflare R2 Data Catalog: MotherDuck can now read from and write to…

M
MotherDuck Release Notes Data & Analytics

MotherDuck cloud coverage extends to Asia Pacific: MotherDuck is now available on AWS in A

MotherDuck cloud coverage extends to Asia Pacific: MotherDuck is now available on AWS in Asia Pacific (Sydney) ap-southeast-2 and Asia Pacific (Tokyo) ap-northeast-1. Create new organizations in either region for lower latency and regional data residency. Flights are not yet available in these regions and are coming soon. Run a Flight with a custom config: In the Flights UI, users can click the Ru…

M
MotherDuck Release Notes Data & Analytics

Write to Databricks-managed Iceberg tables: MotherDuck can now write to Databricks-managed

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 _ name and the bare name, so your code…

M
MotherDuck Release Notes Data & Analytics

[Preview] Server-side Iceberg attach: Attach an external Apache Iceberg REST catalog to Mo

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

M
MotherDuck Release Notes Data & Analytics v1.4.5

DuckDB 1.4.5 and 1.5.4 support: MotherDuck supports DuckDB 1.4.5 and 1.5.4. Refer to the c

DuckDB 1.4.5 and 1.5.4 support: MotherDuck supports DuckDB 1.4.5 and 1.5.4. Refer to the changelog and the official announcement for details. Postgres endpoint JDBC compatibility improvements: The Postgres endpoint now resolves primary keys and indexes, reports column precision and identity metadata, exposes table and column comments, and scopes catalog views to the connected database, enabling BI…

M
MotherDuck Release Notes Data & Analytics v1.4.5

DuckDB 1.4.5 and 1.5.4 support: MotherDuck supports DuckDB 1.4.5 and 1.5.4. Refer to the c

DuckDB 1.4.5 and 1.5.4 support: MotherDuck supports DuckDB 1.4.5 and 1.5.4. Refer to the changelog and the official announcement for details. Postgres endpoint JDBC compatibility improvements: The Postgres endpoint now resolves primary keys and indexes, reports column precision and identity metadata, exposes table and column comments, and scopes catalog views to the connected database, enabling [B…

M
MotherDuck Release Notes Data & Analytics

[Preview] Launching Flights - agent-native data pipelines in MotherDuck: Build and deploy

[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 b…

M
MotherDuck Release Notes Data & Analytics v1.5.3

DuckDB 1.5.3 support: MotherDuck supports DuckDB 1.5.3. Refer to the changelog and the off

DuckDB 1.5.3 support: MotherDuck supports DuckDB 1.5.3. Refer to the changelog and the official announcement for details. Compact URLs for Dives with large filter state: Sharing or copying the URL of a Dive with extensive filters now uses a shortened URL to facilitate easier sharing. Retool Cloud native integration: Connect Retool Cloud apps to MotherDuck through a native MotherDuck resource type,…

M
MotherDuck Release Notes Data & Analytics

Postgres wire protocol endpoint support for Looker: The Postgres Endpoint, a Postgres wire

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;…

M
MotherDuck Release Notes Data & Analytics

Postgres wire protocol endpoint support for Looker: The Postgres Endpoint, a Postgres wire

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;…

M
MotherDuck Release Notes Data & Analytics

SCIM provisioning: MotherDuck now supports SCIM, so you can manage MotherDuck users from y

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 sess…

M
MotherDuck Release Notes Data & Analytics

Data exports from Dives: Dives can now include export buttons that deliver CSV, JSON, Parq

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 embedd…

M
MotherDuck Release Notes Data & Analytics

Streamlined Dives sidebar: The Dives list in the Object Explorer is now capped at your 10

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…

M
MotherDuck Release Notes Data & Analytics

Duckling Overview UI: The Duckling Overview page in Settings provides a view of activity a

Duckling Overview UI: The Duckling Overview page in Settings provides 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. Viewing it requires permission to view organization-wide Duckling activity, which the Admin and Builder preset roles include by default. Dive Viewer Inli…

M
MotherDuck Release Notes Data & Analytics

Duckling Overview UI: MotherDuck Admins now have access to a Duckling Overview page in Set

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 View…

M
MotherDuck Release Notes Data & Analytics v1.5.2

DuckDB 1.5.2 support: MotherDuck supports DuckDB 1.5.2, a bugfix release. Learn more in th

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…

M
MotherDuck Release Notes Data & Analytics

[Preview] Embedded Dives: MotherDuck Dives can now be embedded directly in your customer-f

[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. Airby…

M
MotherDuck Release Notes Data & Analytics

Configurable Duckling cooldown periods: The cooldown period for Standard, Jumbo, Mega, and

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 d…

M
MotherDuck Release Notes Data & Analytics v1.5.1

DuckDB 1.5.1 support: MotherDuck supports DuckDB 1.5.1 ("Variegata"). This release brings

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 availab…

M
MotherDuck Release Notes Data & Analytics

Postgres wire protocol endpoint support for Tableau Cloud: The Postgres Endpoint, a Postgr

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.

M
MotherDuck Release Notes Data & Analytics

Postgres wire protocol endpoint: Query your MotherDuck databases using any Postgres-compat

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…

M
MotherDuck Release Notes Data & Analytics

Dives are now available on all plans: Dives are now available on all MotherDuck plans, giv

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 scra…

M
MotherDuck Release Notes Data & Analytics

Visualizations with Dives: Create interactive visualizations directly in your MotherDuck U

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 an…

M
MotherDuck Release Notes Data & Analytics

Expanded DuckDB Extension support in the MotherDuck MCP Server: The MotherDuck Remote MCP

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 day…

M
MotherDuck Release Notes Data & Analytics

Expanded MCP Server support: The MotherDuck remote MCP Server now supports Warp, PearAI, T

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…