Version: 1.0.0

MotherDuck REST API

Preview Feature

The REST API methods are in 'Preview' and may change in the future

To better support scenarios that require some flexibility or dynamic configuration around managing a MotherDuck organization we are exposing an OpenAPI endpoint with some new functionality. At the moment it enables limited management of users and tokens via HTTP without requiring a DuckDB + MotherDuck client to be running.

All of the methods are authenticated using a Read/Write token of a user with the Admin role within your MotherDuck Organization and passing it via the Authorization header with a value of Bearer {TOKEN}.

Service Account Management

You can use this REST API to programmatically manage service accounts, including their creation, token generation, and Duckling configuration. For a detailed walkthrough, please see our Service Accounts Guide.

If you would like to generate your own OpenAPI client the spec file is located at https://api.motherduck.com/docs/specs

📄️ Get user Ducklings

Gets Duckling (instance) configuration for a user. Requires 'Admin' role.

📄️ Set user Ducklings

Configure account-specific settings, such as Duckling sizes for service accounts. See the Service Accounts Guide for context.

📄️ Create new user

Create a new user, typically a service account, within your MotherDuck organization.

📄️ Create an access token

Create an access token for a user, including service accounts.

📄️ Invalidate an access token

Invalidate a user access token

📄️ Delete a user

Permanently delete a user and all of their data. THIS CANNOT BE UNDONE

📄️ List a user's access tokens

List a user's access tokens

📄️ Get active accounts

[Preview] Get active accounts in an organization along with active Ducklings per account. Requires 'Admin' role