Feature Requests

It would be good to support 2FA, possibly through an app like Authy. Created on behalf of John Apps.

MotherDuck should support the creation of federated connections to other systems. Initially, this would allow for use the various oltp scanners (PostgreSQL, MySql, Sqlite, etc) but could allow for other types of data stores and catalogs.

Add DDL to rename a database. Actual syntax TBD, but we could do either: ALTER DATABASE <database> SET NAME = <name>; RENAME DATABASE <database> to <name>;

Users should be able to share notebooks with other folks in their organization

MotherDuck should be able to write data into Iceberg tables. Please include other details that would help in your use cases!

It would be very nice to dowload in .ipynb file the motherduck notebook !

In a notebook cell right now, there are options to 'Run cell, 'Run selection' and 'Run cell and advance'. I would like a 'Run current query' option to identify the query around the current cursor position (i.e. between two semicolons) and run it from a hotkey. My macOS SQL client (TablePlus) has this and I use it all the time to quickly run different queries in the same file/tab there. Ideally, highlight the current query with a subtle background color like in this screenshot

If I could sync notebooks to a git repo, this would allow me to use other editor tooling to create notebooks (e.g. an AI enhanced code editor). A git push (or button click on the MotherDuck UI side) could then trigger the sync. Obviously better if there was a concept of grouping notebooks to a project (or database).

It would be good to see all running queries on a duckling and to be able to cancel them. (Similar to show full processlist in mysql for example).

Received some user feedback that there should be a way to schedule queries to run automatically on a cadence.