Motherduck MCP Server

by motherduckdbio.github.motherduckdb/mcp-server-motherduckv1.1.0

SQL analytics and data engineering for AI Assistants and IDEs

526Pythonstdioofficial registry

context tax

queued

security

queued

cold start

queued

freshness

Active2d ago

Install Motherduck MCP server

claude mcp add motherduck -e motherduck_token='<motherduck-token>' -e MOTHERDUCK_TOKEN='<motherduck-token>' -e AWS_ACCESS_KEY_ID='<aws-access-key-id>' -e AWS_SECRET_ACCESS_KEY='<aws-secret-access-key>' -e AWS_SESSION_TOKEN='<aws-session-token>' -- uvx mcp-server-motherduck --transport stdio --port 8000 --host 127.0.0.1 --db-path :memory: --max-rows 1024 --max-chars 50000 --query-timeout -1

{
  "mcpServers": {
    "motherduck": {
      "command": "uvx",
      "args": [
        "mcp-server-motherduck",
        "--transport",
        "stdio",
        "--port",
        "8000",
        "--host",
        "127.0.0.1",
        "--db-path",
        ":memory:",
        "--max-rows",
        "1024",
        "--max-chars",
        "50000",
        "--query-timeout",
        "-1"
      ],
      "env": {
        "motherduck_token": "<motherduck-token>",
        "MOTHERDUCK_TOKEN": "<motherduck-token>",
        "AWS_ACCESS_KEY_ID": "<aws-access-key-id>",
        "AWS_SECRET_ACCESS_KEY": "<aws-secret-access-key>",
        "AWS_SESSION_TOKEN": "<aws-session-token>"
      }
    }
  }
}

Add to ~/.cursor/mcp.json (global) or .cursor/mcp.json (project).

{
  "mcpServers": {
    "motherduck": {
      "command": "uvx",
      "args": [
        "mcp-server-motherduck",
        "--transport",
        "stdio",
        "--port",
        "8000",
        "--host",
        "127.0.0.1",
        "--db-path",
        ":memory:",
        "--max-rows",
        "1024",
        "--max-chars",
        "50000",
        "--query-timeout",
        "-1"
      ],
      "env": {
        "motherduck_token": "<motherduck-token>",
        "MOTHERDUCK_TOKEN": "<motherduck-token>",
        "AWS_ACCESS_KEY_ID": "<aws-access-key-id>",
        "AWS_SECRET_ACCESS_KEY": "<aws-secret-access-key>",
        "AWS_SESSION_TOKEN": "<aws-session-token>"
      }
    }
  }
}

Settings → Developer → Edit Config (claude_desktop_config.json), then restart.

{
  "servers": {
    "motherduck": {
      "type": "stdio",
      "command": "uvx",
      "args": [
        "mcp-server-motherduck",
        "--transport",
        "stdio",
        "--port",
        "8000",
        "--host",
        "127.0.0.1",
        "--db-path",
        ":memory:",
        "--max-rows",
        "1024",
        "--max-chars",
        "50000",
        "--query-timeout",
        "-1"
      ],
      "env": {
        "motherduck_token": "<motherduck-token>",
        "MOTHERDUCK_TOKEN": "<motherduck-token>",
        "AWS_ACCESS_KEY_ID": "<aws-access-key-id>",
        "AWS_SECRET_ACCESS_KEY": "<aws-secret-access-key>",
        "AWS_SESSION_TOKEN": "<aws-session-token>"
      }
    }
  }
}

Add to .vscode/mcp.json in your workspace.

{
  "mcpServers": {
    "motherduck": {
      "command": "uvx",
      "args": [
        "mcp-server-motherduck",
        "--transport",
        "stdio",
        "--port",
        "8000",
        "--host",
        "127.0.0.1",
        "--db-path",
        ":memory:",
        "--max-rows",
        "1024",
        "--max-chars",
        "50000",
        "--query-timeout",
        "-1"
      ],
      "env": {
        "motherduck_token": "<motherduck-token>",
        "MOTHERDUCK_TOKEN": "<motherduck-token>",
        "AWS_ACCESS_KEY_ID": "<aws-access-key-id>",
        "AWS_SECRET_ACCESS_KEY": "<aws-secret-access-key>",
        "AWS_SESSION_TOKEN": "<aws-session-token>"
      }
    }
  }
}

Add to ~/.codeium/windsurf/mcp_config.json.

Configuration

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

Freshness

Active — last maintenance signal 2d ago. The newest of the signals below sets the band.

Last commit (default branch)
2026-10-07 · 2d ago · GitHub
Latest release
2026-10-07 · 2d ago · GitHub · v1.1.0
Package published
no data · npm/PyPI
Registry entry updated
2026-10-07 · 2d ago · official registry · v1.1.0

FAQ

›How do I install the Motherduck MCP server in Claude Code?

Run: claude mcp add motherduck -e motherduck_token='<motherduck-token>' -e MOTHERDUCK_TOKEN='<motherduck-token>' -e AWS_ACCESS_KEY_ID='<aws-access-key-id>' -e AWS_SECRET_ACCESS_KEY='<aws-secret-access-key>' -e AWS_SESSION_TOKEN='<aws-session-token>' -- uvx mcp-server-motherduck --transport stdio --port 8000 --host 127.0.0.1 --db-path :memory: --max-rows 1024 --max-chars 50000 --query-timeout -1. For Cursor, VS Code, Claude Desktop and Windsurf, use the install tabs above.

›Does Motherduck require an API key?

Yes. It expects motherduck_token, MOTHERDUCK_TOKEN, AWS_ACCESS_KEY_ID, AWS_SECRET_ACCESS_KEY, AWS_SESSION_TOKEN, of which 5 are secrets.

›Can I use Motherduck as a remote (hosted) MCP server?

No hosted endpoint is published; it runs locally over stdio.

›Is Motherduck in the official MCP registry?

Yes, as io.github.motherduckdb/mcp-server-motherduck.