Connect

8 clients · secrets stay placeholders

JSON (mcpServers)Claude CodeCodexOpenCodeCursorVS CodeGemini CLIGoose

{
  "mcpServers": {
    "mcp-server-motherduck": {
      "command": "uvx",
      "args": [
        "mcp-server-motherduck==1.1.0",
        "--transport",
        "stdio",
        "--port",
        "8000",
        "--host",
        "127.0.0.1",
        "--db-path",
        ":memory:",
        "--motherduck-token",
        "${MOTHERDUCK_TOKEN}",
        "--read-write",
        "--allow-switch-databases",
        "--motherduck-saas-mode",
        "--init-sql",
        "--home-dir",
        "--max-rows",
        "1024",
        "--max-chars",
        "50000",
        "--query-timeout",
        "-1",
        "--ephemeral-connections"
      ],
      "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}"
      }
    }
  }
}

claude mcp add mcp-server-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==1.1.0 --transport stdio --port 8000 --host 127.0.0.1 --db-path :memory: --motherduck-token "${MOTHERDUCK_TOKEN}" --read-write --allow-switch-databases --motherduck-saas-mode --init-sql --home-dir --max-rows 1024 --max-chars 50000 --query-timeout -1 --ephemeral-connections

[mcp_servers.mcp-server-motherduck]
command = "uvx"
args = ["mcp-server-motherduck==1.1.0", "--transport", "stdio", "--port", "8000", "--host", "127.0.0.1", "--db-path", ":memory:", "--motherduck-token", "${MOTHERDUCK_TOKEN}", "--read-write", "--allow-switch-databases", "--motherduck-saas-mode", "--init-sql", "--home-dir", "--max-rows", "1024", "--max-chars", "50000", "--query-timeout", "-1", "--ephemeral-connections"]
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}" }

{
  "$schema": "https://opencode.ai/config.json",
  "mcp": {
    "mcp-server-motherduck": {
      "type": "local",
      "command": [
        "uvx",
        "mcp-server-motherduck==1.1.0",
        "--transport",
        "stdio",
        "--port",
        "8000",
        "--host",
        "127.0.0.1",
        "--db-path",
        ":memory:",
        "--motherduck-token",
        "{env:MOTHERDUCK_TOKEN}",
        "--read-write",
        "--allow-switch-databases",
        "--motherduck-saas-mode",
        "--init-sql",
        "--home-dir",
        "--max-rows",
        "1024",
        "--max-chars",
        "50000",
        "--query-timeout",
        "-1",
        "--ephemeral-connections"
      ],
      "enabled": true,
      "environment": {
        "motherduck_token": "{env:motherduck_token}",
        "MOTHERDUCK_TOKEN": "{env:MOTHERDUCK_TOKEN}",
        "AWS_ACCESS_KEY_ID": "{env:AWS_ACCESS_KEY_ID}",
        "AWS_SECRET_ACCESS_KEY": "{env:AWS_SECRET_ACCESS_KEY}",
        "AWS_SESSION_TOKEN": "{env:AWS_SESSION_TOKEN}"
      }
    }
  }
}

{
  "mcpServers": {
    "mcp-server-motherduck": {
      "command": "uvx",
      "args": [
        "mcp-server-motherduck==1.1.0",
        "--transport",
        "stdio",
        "--port",
        "8000",
        "--host",
        "127.0.0.1",
        "--db-path",
        ":memory:",
        "--motherduck-token",
        "${MOTHERDUCK_TOKEN}",
        "--read-write",
        "--allow-switch-databases",
        "--motherduck-saas-mode",
        "--init-sql",
        "--home-dir",
        "--max-rows",
        "1024",
        "--max-chars",
        "50000",
        "--query-timeout",
        "-1",
        "--ephemeral-connections"
      ],
      "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}"
      }
    }
  },
  "deeplink": "cursor://anysphere.cursor-deeplink/mcp/install?name=mcp-server-motherduck&config=eyJjb21tYW5kIjoidXZ4IiwiYXJncyI6WyJtY3Atc2VydmVyLW1vdGhlcmR1Y2s9PTEuMS4wIiwiLS10cmFuc3BvcnQiLCJzdGRpbyIsIi0tcG9ydCIsIjgwMDAiLCItLWhvc3QiLCIxMjcuMC4wLjEiLCItLWRiLXBhdGgiLCI6bWVtb3J5OiIsIi0tbW90aGVyZHVjay10b2tlbiIsIiR7TU9USEVSRFVDS19UT0tFTn0iLCItLXJlYWQtd3JpdGUiLCItLWFsbG93LXN3aXRjaC1kYXRhYmFzZXMiLCItLW1vdGhlcmR1Y2stc2Fhcy1tb2RlIiwiLS1pbml0LXNxbCIsIi0taG9tZS1kaXIiLCItLW1heC1yb3dzIiwiMTAyNCIsIi0tbWF4LWNoYXJzIiwiNTAwMDAiLCItLXF1ZXJ5LXRpbWVvdXQiLCItMSIsIi0tZXBoZW1lcmFsLWNvbm5lY3Rpb25zIl0sImVudiI6eyJtb3RoZXJkdWNrX3Rva2VuIjoiJHttb3RoZXJkdWNrX3Rva2VufSIsIk1PVEhFUkRVQ0tfVE9LRU4iOiIke01PVEhFUkRVQ0tfVE9LRU59IiwiQVdTX0FDQ0VTU19LRVlfSUQiOiIke0FXU19BQ0NFU1NfS0VZX0lEfSIsIkFXU19TRUNSRVRfQUNDRVNTX0tFWSI6IiR7QVdTX1NFQ1JFVF9BQ0NFU1NfS0VZfSIsIkFXU19TRVNTSU9OX1RPS0VOIjoiJHtBV1NfU0VTU0lPTl9UT0tFTn0ifX0%3D"
}

{
  "servers": {
    "mcp-server-motherduck": {
      "type": "stdio",
      "command": "uvx",
      "args": [
        "mcp-server-motherduck==1.1.0",
        "--transport",
        "stdio",
        "--port",
        "8000",
        "--host",
        "127.0.0.1",
        "--db-path",
        ":memory:",
        "--motherduck-token",
        "${MOTHERDUCK_TOKEN}",
        "--read-write",
        "--allow-switch-databases",
        "--motherduck-saas-mode",
        "--init-sql",
        "--home-dir",
        "--max-rows",
        "1024",
        "--max-chars",
        "50000",
        "--query-timeout",
        "-1",
        "--ephemeral-connections"
      ],
      "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}"
      }
    }
  }
}

{
  "mcpServers": {
    "mcp-server-motherduck": {
      "command": "uvx",
      "args": [
        "mcp-server-motherduck==1.1.0",
        "--transport",
        "stdio",
        "--port",
        "8000",
        "--host",
        "127.0.0.1",
        "--db-path",
        ":memory:",
        "--motherduck-token",
        "${MOTHERDUCK_TOKEN}",
        "--read-write",
        "--allow-switch-databases",
        "--motherduck-saas-mode",
        "--init-sql",
        "--home-dir",
        "--max-rows",
        "1024",
        "--max-chars",
        "50000",
        "--query-timeout",
        "-1",
        "--ephemeral-connections"
      ],
      "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}"
      }
    }
  }
}

extensions:
  "mcp-server-motherduck":
    enabled: true
    name: "mcp-server-motherduck"
    type: stdio
    cmd: "uvx"
    args:
      - "mcp-server-motherduck==1.1.0"
      - "--transport"
      - "stdio"
      - "--port"
      - "8000"
      - "--host"
      - "127.0.0.1"
      - "--db-path"
      - ":memory:"
      - "--motherduck-token"
      - "${MOTHERDUCK_TOKEN}"
      - "--read-write"
      - "--allow-switch-databases"
      - "--motherduck-saas-mode"
      - "--init-sql"
      - "--home-dir"
      - "--max-rows"
      - "1024"
      - "--max-chars"
      - "50000"
      - "--query-timeout"
      - "-1"
      - "--ephemeral-connections"
    envs:
      "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}"
    timeout: 300

Placeholders to fill from your own secret store: ${motherduck_token}, ${MOTHERDUCK_TOKEN}, ${AWS_ACCESS_KEY_ID}, ${AWS_SECRET_ACCESS_KEY}, ${AWS_SESSION_TOKEN}, ${MOTHERDUCK_TOKEN}. The registry never accepts secret values.

This is a local package: the command runs on your machine.

Quality – / 100not scored

Not scored: fewer than three checks apply, usually because no remote answered a credential-free probe or the server is a local package.

protocoln/a · weight 25

n/a
protocol.modern, protocol.stateless, protocol.transport, protocol.list_ttlno remote answered a protocol handshake (not probed yet, unreachable, or local-only)

authorizationn/a · weight 15

n/a
auth.prm, auth.as_metadata, auth.cimdno remote uses OAuth
n/a
auth.secret_in_urlno templated URL

tool hygienen/a · weight 30

n/a
tools.descriptions, tools.description_length, tools.schemas, tools.annotations, tools.directory_hints, tools.token_cost, tools.api_dumptool list unknown (behind auth, not probed, or empty)

stabilityn/a · weight 15

n/a
stability.changes, stability.rug_pulltool list unknown

dependenciesn/a · weight 15

n/a
deps.known_vulns, deps.mcp_sdk_version, deps.resolvabledeps.dev does not know [email protected]

Tool list unknown · checked 2026-10-21 03:14 UTC

Tool changes

No tool definition changes recorded. A server's first observation is its baseline; later probes record what changes.

Checks run on what our credential-free, read-only probes observe; tools are never called and no code audit is performed. How it is computed.

Trust 91 / 100

provenance80

livenessn/a

freshness100

hygiene100

+repository +namespace-matches-repo ~liveness-unmeasured +updated-14d-ago

Derived from observable signals (official registry feed and our own credential-free probes); no code audit performed. How it is computed.

Dependencies

[email protected] PyPIthis version is not known to the dependency resolver

Dependency graphs from deps.dev; advisories from OSV.dev, including the GitHub Advisory Database and the PyPI Advisory Database; all CC BY 4.0. The graph is what a clean install of this version resolves today; nothing was installed or run. How it is checked.

Endpoints

package	registry	version	runtime	secrets
`mcp-server-motherduck`	pypi	1.1.0	–	`motherduck_token`, `MOTHERDUCK_TOKEN`, `AWS_ACCESS_KEY_ID`, `AWS_SECRET_ACCESS_KEY`, `AWS_SESSION_TOKEN`, `--motherduck-token`

Tools (0)

No tools observed. Local packages are never executed by the registry.

Schemas: list_tools.

Similar MCP servers

Official server.json

{
  "name": "io.github.motherduckdb/mcp-server-motherduck",
  "icons": [
    {
      "src": "https://t2.gstatic.com/faviconV2?client=SOCIAL&type=FAVICON&fallback_opts=TYPE,SIZE,URL&url=http://motherduck.com&size=64",
      "sizes": [
        "64x64"
      ],
      "mimeType": "image/png"
    }
  ],
  "$schema": "https://static.modelcontextprotocol.io/schemas/2025-12-11/server.schema.json",
  "version": "1.1.0",
  "packages": [
    {
      "version": "1.1.0",
      "transport": {
        "type": "stdio"
      },
      "identifier": "mcp-server-motherduck",
      "registryType": "pypi",
      "registryBaseUrl": "https://pypi.org",
      "packageArguments": [
        {
          "name": "--transport",
          "type": "named",
          "choices": [
            "stdio",
            "http",
            "sse",
            "stream"
          ],
          "default": "stdio",
          "description": "Transport type for MCP server. Use 'http' for HTTP Streamable transport."
        },
        {
          "name": "--port",
          "type": "named",
          "format": "number",
          "default": "8000",
          "description": "Port to listen on for HTTP transport"
        },
        {
          "name": "--host",
          "type": "named",
          "default": "127.0.0.1",
          "description": "Host to bind the MCP server"
        },
        {
          "name": "--db-path",
          "type": "named",
          "default": ":memory:",
          "description": "Database path: ':memory:' for in-memory, 'md:' for MotherDuck, or file/S3 path"
        },
        {
          "name": "--motherduck-token",
          "type": "named",
          "isSecret": true,
          "description": "Access token for MotherDuck connections"
        },
        {
          "name": "--read-write",
          "type": "named",
          "description": "Enable write access (server runs in read-only mode by default)"
        },
        {
          "name": "--allow-switch-databases",
          "type": "named",
          "description": "Enable the switch_database_connection tool to change databases at runtime"
        },
        {
          "name": "--motherduck-saas-mode",
          "type": "named",
          "description": "Enable SaaS mode for MotherDuck (disables local filesystem access)"
        },
        {
          "name": "--init-sql",
          "type": "named",
          "description": "SQL file path or SQL string to execute on startup"
        },
        {
          "name": "--home-dir",
          "type": "named",
          "description": "Home directory for DuckDB"
        },
        {
          "name": "--max-rows",
          "type": "named",
          "format": "number",
          "default": "1024",
          "description": "Maximum number of rows to return from queries"
        },
        {
          "name": "--max-chars",
          "type": "named",
          "format": "number",
          "default": "50000",
          "description": "Maximum number of characters in query results"
        },
        {
          "name": "--query-timeout",
          "type": "named",
          "format": "number",
          "default": "-1",
          "description": "Query execution timeout in seconds (-1 to disable)"
        },
        {
          "name": "--ephemeral-connections",
          "type": "named",
          "description": "Use temporary connections for read-only local DuckDB files (default: true)"
        }
      ],
      "environmentVariables": [
        {
          "name": "motherduck_token",
          "isSecret": true,
          "description": "Access token for MotherDuck connections (alternative to --motherduck-token)"
        },
        {
          "name": "MOTHERDUCK_TOKEN",
          "isSecret": true,
          "description": "Access token for MotherDuck connections (alternative to --motherduck-token)"
        },
        {
          "name": "HOME",
          "description": "Used by DuckDB for extensions and config. Override with --home-dir if not set."
        },
        {
          "name": "AWS_ACCESS_KEY_ID",
          "isSecret": true,
          "description": "AWS access key for S3 database connections"
        },
        {
          "name": "AWS_SECRET_ACCESS_KEY",
          "isSecret": true,
          "description": "AWS secret access key for S3 database connections"
        },
        {
          "name": "AWS_SESSION_TOKEN",
          "isSecret": true,
          "description": "AWS session token for temporary credentials"
        },
        {
          "name": "AWS_DEFAULT_REGION",
          "description": "AWS region for S3 database connections"
        },
        {
          "name": "AWS_ENDPOINT",
          "description": "AWS endpoint for S3 database connections"
        }
      ]
    }
  ],
  "repository": {
    "url": "https://github.com/motherduckdb/mcp-server-motherduck",
    "source": "github"
  },
  "description": "SQL analytics and data engineering for AI Assistants and IDEs"
}