Back to Browse

Motherduck MCP Server

Developer ToolsLow Risk10.0MCP RegistryLocal
Free

Server data from the Official MCP Registry

SQL analytics and data engineering for AI Assistants and IDEs

About

SQL analytics and data engineering for AI Assistants and IDEs

Security Report

10.0
Low Risk10.0Low Risk

Valid MCP server (0 strong, 4 medium validity signals). No known CVEs in dependencies. Imported from the Official MCP Registry. 1 finding(s) downgraded by scanner intelligence.

5 files analyzed · 1 issue found

Security scores are indicators to help you make informed decisions, not guarantees. Always review permissions before connecting any MCP server.

Permissions Required

This plugin requests these system permissions. Most are normal for its category.

file_system

Check that this permission is expected for this type of plugin.

env_vars

Check that this permission is expected for this type of plugin.

What You'll Need

Set these up before or after installing:

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

Environment variable: motherduck_token

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

Environment variable: MOTHERDUCK_TOKEN

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

Environment variable: HOME

AWS access key for S3 database connectionsRequired

Environment variable: AWS_ACCESS_KEY_ID

AWS secret access key for S3 database connectionsRequired

Environment variable: AWS_SECRET_ACCESS_KEY

AWS session token for temporary credentialsRequired

Environment variable: AWS_SESSION_TOKEN

AWS region for S3 database connectionsOptional

Environment variable: AWS_DEFAULT_REGION

AWS endpoint for S3 database connectionsOptional

Environment variable: AWS_ENDPOINT

How to Install

Add this to your MCP configuration file:

{
  "mcpServers": {
    "io-github-motherduckdb-mcp-server-motherduck": {
      "env": {
        "HOME": "your-home-here",
        "AWS_ENDPOINT": "your-aws-endpoint-here",
        "MOTHERDUCK_TOKEN": "your-motherduck-token-here",
        "motherduck_token": "your-motherduck-token-here",
        "AWS_ACCESS_KEY_ID": "your-aws-access-key-id-here",
        "AWS_SESSION_TOKEN": "your-aws-session-token-here",
        "AWS_DEFAULT_REGION": "your-aws-default-region-here",
        "AWS_SECRET_ACCESS_KEY": "your-aws-secret-access-key-here"
      },
      "args": [
        "mcp-server-motherduck"
      ],
      "command": "uvx"
    }
  }
}

Reviews

No reviews yet

Be the first to review this server!