mcp-server-motherduck

{
  "server.json": {
    "name": "io.github.motherduckdb/mcp-server-motherduck",
    "status": "active",
    "$schema": "https://static.modelcontextprotocol.io/schemas/2025-07-09/server.schema.json",
    "version": "0.6.4",
    "packages": [
      {
        "version": "0.6.4",
        "transport": {
          "type": "stdio"
        },
        "identifier": "mcp-server-motherduck",
        "registry_type": "pypi",
        "package_arguments": [
          {
            "name": "--transport",
            "type": "named",
            "choices": [
              "stdio",
              "sse",
              "stream"
            ],
            "default": "stdio",
            "description": "Transport type for MCP server",
            "is_required": false
          },
          {
            "name": "--port",
            "type": "named",
            "format": "number",
            "default": "8000",
            "description": "Port to listen on for sse and stream transport mode",
            "is_required": false
          },
          {
            "name": "--db-path",
            "type": "named",
            "default": "md:",
            "description": "Path to local DuckDB database file or MotherDuck database",
            "is_required": false
          },
          {
            "name": "--motherduck-token",
            "type": "named",
            "is_secret": true,
            "description": "Access token to use for MotherDuck database connections",
            "is_required": false
          },
          {
            "name": "--read-only",
            "type": "named",
            "description": "Flag for connecting to DuckDB or MotherDuck in read-only mode",
            "is_required": false
          },
          {
            "name": "--home-dir",
            "type": "named",
            "description": "Home directory for DuckDB",
            "is_required": false
          },
          {
            "name": "--saas-mode",
            "type": "named",
            "description": "Flag for connecting to MotherDuck in SaaS mode (disables filesystem and write permissions for local DuckDB)",
            "is_required": false
          },
          {
            "name": "--json-response",
            "type": "named",
            "description": "Enable JSON responses for HTTP stream (only supported for stream transport)",
            "is_required": false
          }
        ],
        "registry_base_url": "https://pypi.org",
        "environment_variables": [
          {
            "name": "motherduck_token",
            "is_secret": true,
            "description": "Access token to use for MotherDuck database connections",
            "is_required": false
          },
          {
            "name": "HOME",
            "description": "Home directory for DuckDB (used as default if --home-dir not specified)",
            "is_required": false
          }
        ]
      }
    ],
    "repository": {
      "url": "https://github.com/motherduckdb/mcp-server-motherduck",
      "source": "github"
    },
    "description": "Fast analytics and data processing with DuckDB and MotherDuck"
  }
}