MotherDuck

Official MotherDuck Data & databases

Lets an agent run SQL to read and write data in MotherDuck and DuckDB, and inspect database catalogs. Summary written by AI Index.

The registry’s description: SQL analytics and data engineering for AI Assistants and IDEs

Local package (pypi)

Add to your client

Add the MotherDuck MCP server to Claude Code

  1. Run the command

    claude mcp add motherduck -- uvx mcp-server-motherduck
  2. Fill in the values ↓

  3. Check it’s connected

If the file already has servers, add the entry inside the existing object. To check it’s connected, restart or reload the client and look for motherduck in its list of MCP servers. A server that needs sign-in opens it on first use.

What you fill in

Required values appear as <NAME> placeholders in the snippets; add optional ones the same way. Descriptions are the server’s registry entry’s.

  • <motherduck_token> Environment variable Optional · Secret

    Access token for MotherDuck connections (alternative to --motherduck-token)

  • <MOTHERDUCK_TOKEN> Environment variable Optional · Secret

    Access token for MotherDuck connections (alternative to --motherduck-token)

  • <HOME> Environment variable Optional

    Used by DuckDB for extensions and config. Override with --home-dir if not set.

  • <AWS_ACCESS_KEY_ID> Environment variable Optional · Secret

    AWS access key for S3 database connections

  • <AWS_SECRET_ACCESS_KEY> Environment variable Optional · Secret

    AWS secret access key for S3 database connections

  • <AWS_SESSION_TOKEN> Environment variable Optional · Secret

    AWS session token for temporary credentials

  • <AWS_DEFAULT_REGION> Environment variable Optional

    AWS region for S3 database connections

  • <AWS_ENDPOINT> Environment variable Optional

    AWS endpoint for S3 database connections

Client compatibility

By transport: whether the client’s docs list a transport this server offers. It doesn’t cover sign-in or other requirements.

Sources

This data comes from the Official MCP Registry.