McpMux
Back to Registry

MotherDuck (uvx) MCP Server

Community

Contributed by MotherDuck

Query data with DuckDB's analytical SQL across local DuckDB files, in-memory databases, S3, and the MotherDuck cloud. Run SQL and browse database catalogs. Read-only by default.

Install with McpMuxSource CodeDocs

About the MotherDuck (uvx) MCP Server

The MotherDuck (uvx) MCP server is a local (stdio) Model Context Protocol server available in the McpMux registry. Query data with DuckDB's analytical SQL across local DuckDB files, in-memory databases, S3, and the MotherDuck cloud. Run SQL and browse database catalogs. Read-only by default. This is a community-contributed MCP server by MotherDuck.

Install the MotherDuck (uvx) MCP server with one click using McpMux. It works with Cursor, Claude Desktop, Claude Code, VS Code, ChatGPT, Windsurf, JetBrains, and any MCP-compatible AI client. This server requires authentication — McpMux securely stores your credentials with AES-256-GCM encryption.

Transport Configuration

Transport Configuration
{
  "type": "stdio",
  "command": "uvx",
  "args": [
    "mcp-server-motherduck",
    "--db-path",
    "md:"
  ],
  "env": {
    "motherduck_token": "${input:MOTHERDUCK_TOKEN}"
  },
  "metadata": {
    "inputs": [
      {
        "id": "MOTHERDUCK_TOKEN",
        "label": "MotherDuck Token",
        "description": "MotherDuck access token, used to connect to the MotherDuck cloud (md: database path). Leave empty when using a local DuckDB file or :memory: instead.",
        "type": "text",
        "required": false,
        "secret": true,
        "placeholder": "***************************",
        "obtain": {
          "url": "https://app.motherduck.com/settings/tokens",
          "instructions": "1. Sign in to MotherDuck\n2. Open Settings > Access Tokens\n3. Click Create token (Read/Write or Read Scaling)\n4. Copy the token",
          "button_label": "Create Token"
        }
      }
    ]
  }
}
Details
TransportLocal (stdio)
Hostinglocal
Authoptional_api_key
Capabilities
Tools

Categories

Database

Tags

motherduckduckdbsqldatabaseanalyticsdata-warehouse

Links

RepositoryHomepageDocumentation

Supported AI Clients

The MotherDuck (uvx) MCP server works with all MCP-compatible AI clients through McpMux:

CursorClaude DesktopClaude CodeVS CodeChatGPTWindsurfJetBrainsZedClineGemini CLIAmazon Q

Related MCP Servers

MongoDB (Docker)

Connect to MongoDB databases and Atlas clusters via Docker. Query collections, inspect schemas, manage indexes, and run aggregation pipelines in an isolated container.

MongoDB (npx)

Connect to MongoDB databases and Atlas clusters. Query collections, inspect schemas, manage indexes, and run aggregation pipelines through the official MongoDB MCP server.

PostgreSQL (Docker)

Query PostgreSQL databases, analyze performance, and optimize indexes via Docker. Execute SQL, inspect schemas, get EXPLAIN plans, identify slow queries, and run health checks.

PostgreSQL (uvx)

Query PostgreSQL databases, analyze performance, and optimize indexes. Execute SQL, inspect schemas, get EXPLAIN plans, identify slow queries, and run health checks via Postgres MCP Pro.

Redis (Docker)

Interact with Redis databases via Docker. Execute commands, manage keys, and work with data structures across standalone, cluster, and Sentinel modes.

Redis (uvx)

Interact with Redis databases. Execute commands, manage keys, and work with data structures across standalone, cluster, and Sentinel modes.

Install MotherDuck (uvx) with McpMux

One-click install from the McpMux desktop app. Auto-configures for Cursor, Claude, VS Code, ChatGPT, Windsurf, JetBrains, and any MCP-compatible client.

Install