MotherDuck REST API

In the MotherDuck UI, open your organization menu, go to Settings, click + Create token, choose a token type (Read/Write or Read Scaling), optionally set an expiry, then copy the token. For service accounts, an org Admin can create the service account in Settings → Service Accounts and then create a token there; the walkthrough is in Create and configure service accounts. Store the token securely; for DuckDB clients MotherDuck recommends setting motherduck_token in your environment.