D

DuckDB CLI for MotherDuck

CLI discovered

Details
Command
duckdb
Docs
https://motherduck.com/docs/getting-started/interfaces/connect-query-from-duckdb-cli/
Authentication
MotherDuck access token bearer discovered Get token ↗
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 SettingsService 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.