io.github.motherduckdb/mcp-server-motherduck

Official

by motherduckdb · Python

SQL analytics and data engineering for AI Assistants and IDEs

SQL analytics and data engineering tools for AI assistants and IDEs.

Topics

aiduckdbmotherduck

Install

Configuration

Environment variables

motherduck_tokensecret

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

MOTHERDUCK_TOKENsecret

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

HOME

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

AWS_ACCESS_KEY_IDsecret

AWS access key for S3 database connections

AWS_SECRET_ACCESS_KEYsecret

AWS secret access key for S3 database connections

AWS_SESSION_TOKENsecret

AWS session token for temporary credentials

AWS_DEFAULT_REGION

AWS region for S3 database connections

AWS_ENDPOINT

AWS endpoint for S3 database connections

Arguments

--transportdefault stdio

--portdefault 8000

--hostdefault 127.0.0.1

--db-pathdefault :memory:

--motherduck-token

--read-write

--allow-switch-databases

--motherduck-saas-mode

--init-sql

--home-dir

--max-rowsdefault 1024

--max-charsdefault 50000

--query-timeoutdefault -1

--ephemeral-connections

claude_desktop_config.json

{
  "mcpServers": {
    "mcp-server-motherduck": {
      "command": "uvx",
      "args": [
        "mcp-server-motherduck",
        "--transport",
        "stdio",
        "--port",
        "8000",
        "--host",
        "127.0.0.1",
        "--db-path",
        ":memory:",
        "--motherduck-token",
        "--read-write",
        "--allow-switch-databases",
        "--motherduck-saas-mode",
        "--init-sql",
        "--home-dir",
        "--max-rows",
        "1024",
        "--max-chars",
        "50000",
        "--query-timeout",
        "-1",
        "--ephemeral-connections"
      ],
      "env": {
        "motherduck_token": "<YOUR_MOTHERDUCK_TOKEN>",
        "MOTHERDUCK_TOKEN": "<YOUR_MOTHERDUCK_TOKEN>",
        "HOME": "<YOUR_HOME>",
        "AWS_ACCESS_KEY_ID": "<YOUR_AWS_ACCESS_KEY_ID>",
        "AWS_SECRET_ACCESS_KEY": "<YOUR_AWS_SECRET_ACCESS_KEY>",
        "AWS_SESSION_TOKEN": "<YOUR_AWS_SESSION_TOKEN>",
        "AWS_DEFAULT_REGION": "<YOUR_AWS_DEFAULT_REGION>",
        "AWS_ENDPOINT": "<YOUR_AWS_ENDPOINT>"
      }
    }
  }
}