MCP Server

io.github.motherduckdb/mcp-server-motherduck MCP Server

Name: io.github.motherduckdb/mcp-server-motherduck MCP Server
Author: io.github.motherduckdb

io.github.motherduckdb/mcp-server-motherduck

Repository Registry

What is the io.github.motherduckdb/mcp-server-motherduck MCP server?

SQL analytics and data engineering for AI Assistants and IDEs

How to install io.github.motherduckdb/mcp-server-motherduck

Copy-paste configuration for popular MCP clients.

transport: stdio

Config generated by PluginBench — verify against the source before use.

Environment / auth

motherduck_token
secret
Access token for MotherDuck connections (alternative to --motherduck-token)
MOTHERDUCK_TOKEN
secret
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_ID
secret
AWS access key for S3 database connections
AWS_SECRET_ACCESS_KEY
secret
AWS secret access key for S3 database connections
AWS_SESSION_TOKEN
secret
AWS session token for temporary credentials
AWS_DEFAULT_REGION
AWS region for S3 database connections
AWS_ENDPOINT
AWS endpoint for S3 database connections

Claude Desktop

~/Library/Application Support/Claude/claude_desktop_config.json

{
  "mcpServers": {
    "mcp-server-motherduck": {
      "command": "uvx",
      "args": [
        "mcp-server-motherduck",
        "--transport",
        "--port",
        "--host",
        "--db-path",
        "--motherduck-token",
        "--read-write",
        "--allow-switch-databases",
        "--motherduck-saas-mode",
        "--init-sql",
        "--home-dir",
        "--max-rows",
        "--max-chars",
        "--query-timeout",
        "--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>"
      }
    }
  }
}

Cursor

~/.cursor/mcp.json

{
  "mcpServers": {
    "mcp-server-motherduck": {
      "command": "uvx",
      "args": [
        "mcp-server-motherduck",
        "--transport",
        "--port",
        "--host",
        "--db-path",
        "--motherduck-token",
        "--read-write",
        "--allow-switch-databases",
        "--motherduck-saas-mode",
        "--init-sql",
        "--home-dir",
        "--max-rows",
        "--max-chars",
        "--query-timeout",
        "--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>"
      }
    }
  }
}

Windsurf

~/.codeium/windsurf/mcp_config.json

{
  "mcpServers": {
    "mcp-server-motherduck": {
      "command": "uvx",
      "args": [
        "mcp-server-motherduck",
        "--transport",
        "--port",
        "--host",
        "--db-path",
        "--motherduck-token",
        "--read-write",
        "--allow-switch-databases",
        "--motherduck-saas-mode",
        "--init-sql",
        "--home-dir",
        "--max-rows",
        "--max-chars",
        "--query-timeout",
        "--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>"
      }
    }
  }
}

VS Code

.vscode/mcp.json

{
  "servers": {
    "mcp-server-motherduck": {
      "type": "stdio",
      "command": "uvx",
      "args": [
        "mcp-server-motherduck",
        "--transport",
        "--port",
        "--host",
        "--db-path",
        "--motherduck-token",
        "--read-write",
        "--allow-switch-databases",
        "--motherduck-saas-mode",
        "--init-sql",
        "--home-dir",
        "--max-rows",
        "--max-chars",
        "--query-timeout",
        "--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>"
      }
    }
  }
}

Claude Code

claude mcp add mcp-server-motherduck --env motherduck_token=<YOUR_MOTHERDUCK_TOKEN> --env MOTHERDUCK_TOKEN=<YOUR_MOTHERDUCK_TOKEN> --env HOME=<YOUR_HOME> --env AWS_ACCESS_KEY_ID=<YOUR_AWS_ACCESS_KEY_ID> --env AWS_SECRET_ACCESS_KEY=<YOUR_AWS_SECRET_ACCESS_KEY> --env AWS_SESSION_TOKEN=<YOUR_AWS_SESSION_TOKEN> --env AWS_DEFAULT_REGION=<YOUR_AWS_DEFAULT_REGION> --env AWS_ENDPOINT=<YOUR_AWS_ENDPOINT> -- uvx mcp-server-motherduck --transport --port --host --db-path --motherduck-token --read-write --allow-switch-databases --motherduck-saas-mode --init-sql --home-dir --max-rows --max-chars --query-timeout --ephemeral-connections