motherduck.com
MotherDuck is a cloud data warehouse built on DuckDB for querying, sharing, and analyzing data. It also provides AI-oriented workflows such as an MCP server for connecting AI clients to MotherDuck databases.
MotherDuck exposes a preview REST Admin API with an OpenAPI spec, a remote MCP server at https://api.motherduck.com/mcp using OAuth or bearer tokens, and DuckDB CLI access authenticated via browser sign-in or access token.
- MotherDuck MCP Serverdiscovered
- MotherDuck REST APIdiscovered
- DuckDB CLI for MotherDuckdiscovered
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.
$ duckdb "md:"Acquired by the CLI — running duckdb "md:" opens the auth flow and stores the credential.
conventions · 2/8 published
- integrations.json✗
/.well-known/integrations.json - llms.txt✓https://motherduck.com/llms.txt
- API catalog✗
/.well-known/api-catalog - OpenAPI document✗
/api/schema/, /openapi.json, /swagger.json, /api/openapi.json, or /v1/openapi.json - MCP server card✗
/.well-known/mcp/server-card.json - OAuth protected resource✗
/.well-known/oauth-protected-resource - Agent card✗
/.well-known/agent-card.json - Agent skills✓https://motherduck.com/.well-known/agent-skills/index.json
Publish these signals → /publishing