D
DuckDB CLI for MotherDuck
Details
Authentication
env motherduck_token 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.
MotherDuck MCP OAuth authorization oauth2 discovered
$ duckdb "md:" Acquired by the CLI — running duckdb "md:" opens the auth flow and stores the credential.