← Index

io.github.motherduckdb/mcp-server-motherduck

io.github.motherduckdb/mcp-server-motherduck·v1.0.6·Analytics
Quality Score
90
/100

SQL analytics and data engineering for AI Assistants and IDEs

§01  Install
Claude Desktop (uvx)
{
  "mcpServers": {
    "mcp-server-motherduck": {
      "command": "uvx",
      "args": [
        "mcp-server-motherduck"
      ],
      "env": {
        "motherduck_token": "<your-motherduck_token>",
        "MOTHERDUCK_TOKEN": "<your-motherduck_token>",
        "HOME": "<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": "<aws_default_region>",
        "AWS_ENDPOINT": "<aws_endpoint>"
      }
    }
  }
}
§02  Environment variables
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

§03  MCP Quality Score  ·  methodology
freshness
25
completeness
15
installability
25
documentation
15
stability
10
§04  Alternatives in Analytics