SERVER

MCP Server Motherduck

Rank #603

io.github.motherduckdb/mcp-server-motherduck

SQL analytics and data engineering for AI Assistants and IDEs

16 versions

523 GitHub stars

by motherduckdb (1 servers)View repository ↗Claim this server

First listed

Jan 8, 2025

Last publish date

Aug 19, 2026

OVERVIEW

MCP Server Motherduck is a Model Context Protocol (MCP) server published by motherduckdb. It ranks #603 of 132,046 servers tracked on MCP Toplist, and its repository has 523 GitHub stars. MCP Server Motherduck is listed across 4 registries — Official MCP, PulseMCP, mcp.so and Glama, with 16 tracked versions. It was first listed on Jan 8, 2025 and most recently updated on Aug 19, 2026.

STANDING

#603of 132,046 tracked serversTop 0.5%

Ranks ahead of 131,443 of 132,046 servers on MCP Toplist.

Recent momentum

+133GitHub stars since Sep 8 (+34%)

CONNECT

Use MCP Server Motherduck

No setupRuns out of the box

No credentials or required configuration declared — add it to your MCP client and go.

Python package (PyPI)

claude mcp add mcp-server-motherduck -e "motherduck_token=<your motherduck_token>" -e "MOTHERDUCK_TOKEN=<your MOTHERDUCK_TOKEN>" -e "HOME=<your HOME>" -e "AWS_ACCESS_KEY_ID=<your AWS_ACCESS_KEY_ID>" -e "AWS_SECRET_ACCESS_KEY=<your AWS_SECRET_ACCESS_KEY>" -e "AWS_SESSION_TOKEN=<your AWS_SESSION_TOKEN>" -e "AWS_DEFAULT_REGION=<your AWS_DEFAULT_REGION>" -e "AWS_ENDPOINT=<your AWS_ENDPOINT>" -- uvx mcp-server-motherduck --transport stdio --port 8000 --host 127.0.0.1 --db-path :memory: --max-rows 1024 --max-chars 50000 --query-timeout -1

Replace each placeholder with your own value before saving.

Python package (PyPI)

[mcp_servers.mcp-server-motherduck]
command = "uvx"
args = ["mcp-server-motherduck", "--transport", "stdio", "--port", "8000", "--host", "127.0.0.1", "--db-path", ":memory:", "--max-rows", "1024", "--max-chars", "50000", "--query-timeout", "-1"]

[mcp_servers.mcp-server-motherduck.env]
motherduck_token = "<your motherduck_token>"
MOTHERDUCK_TOKEN = "<your MOTHERDUCK_TOKEN>"
HOME = "<your 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 = "<your AWS_DEFAULT_REGION>"
AWS_ENDPOINT = "<your AWS_ENDPOINT>"

Add to ~/.codex/config.toml. Replace each placeholder with your own value before saving.

Python package (PyPI)

{
  "mcpServers": {
    "mcp-server-motherduck": {
      "command": "uvx",
      "args": [
        "mcp-server-motherduck",
        "--transport",
        "stdio",
        "--port",
        "8000",
        "--host",
        "127.0.0.1",
        "--db-path",
        ":memory:",
        "--max-rows",
        "1024",
        "--max-chars",
        "50000",
        "--query-timeout",
        "-1"
      ],
      "env": {
        "motherduck_token": "<your motherduck_token>",
        "MOTHERDUCK_TOKEN": "<your MOTHERDUCK_TOKEN>",
        "HOME": "<your 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": "<your AWS_DEFAULT_REGION>",
        "AWS_ENDPOINT": "<your AWS_ENDPOINT>"
      }
    }
  }
}

Add to claude_desktop_config.json (Settings → Developer → Edit Config). Replace each placeholder with your own value before saving.

Python package (PyPI)

{
  "mcpServers": {
    "mcp-server-motherduck": {
      "command": "uvx",
      "args": [
        "mcp-server-motherduck",
        "--transport",
        "stdio",
        "--port",
        "8000",
        "--host",
        "127.0.0.1",
        "--db-path",
        ":memory:",
        "--max-rows",
        "1024",
        "--max-chars",
        "50000",
        "--query-timeout",
        "-1"
      ],
      "env": {
        "motherduck_token": "<your motherduck_token>",
        "MOTHERDUCK_TOKEN": "<your MOTHERDUCK_TOKEN>",
        "HOME": "<your 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": "<your AWS_DEFAULT_REGION>",
        "AWS_ENDPOINT": "<your AWS_ENDPOINT>"
      }
    }
  }
}

Add to ~/.cursor/mcp.json (global) or .cursor/mcp.json (per project). Replace each placeholder with your own value before saving.

Python package (PyPI)

{
  "servers": {
    "mcp-server-motherduck": {
      "type": "stdio",
      "command": "uvx",
      "args": [
        "mcp-server-motherduck",
        "--transport",
        "stdio",
        "--port",
        "8000",
        "--host",
        "127.0.0.1",
        "--db-path",
        ":memory:",
        "--max-rows",
        "1024",
        "--max-chars",
        "50000",
        "--query-timeout",
        "-1"
      ],
      "env": {
        "motherduck_token": "<your motherduck_token>",
        "MOTHERDUCK_TOKEN": "<your MOTHERDUCK_TOKEN>",
        "HOME": "<your 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": "<your AWS_DEFAULT_REGION>",
        "AWS_ENDPOINT": "<your AWS_ENDPOINT>"
      }
    }
  }
}

Save as .vscode/mcp.json in your workspace. Replace each placeholder with your own value before saving.

Python package (PyPI)

{
  "mcpServers": {
    "mcp-server-motherduck": {
      "command": "uvx",
      "args": [
        "mcp-server-motherduck",
        "--transport",
        "stdio",
        "--port",
        "8000",
        "--host",
        "127.0.0.1",
        "--db-path",
        ":memory:",
        "--max-rows",
        "1024",
        "--max-chars",
        "50000",
        "--query-timeout",
        "-1"
      ],
      "env": {
        "motherduck_token": "<your motherduck_token>",
        "MOTHERDUCK_TOKEN": "<your MOTHERDUCK_TOKEN>",
        "HOME": "<your 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": "<your AWS_DEFAULT_REGION>",
        "AWS_ENDPOINT": "<your AWS_ENDPOINT>"
      }
    }
  }
}

Add to ~/.codeium/windsurf/mcp_config.json. Replace each placeholder with your own value before saving.

Python package (PyPI)

{
  "mcpServers": {
    "mcp-server-motherduck": {
      "command": "uvx",
      "args": [
        "mcp-server-motherduck",
        "--transport",
        "stdio",
        "--port",
        "8000",
        "--host",
        "127.0.0.1",
        "--db-path",
        ":memory:",
        "--max-rows",
        "1024",
        "--max-chars",
        "50000",
        "--query-timeout",
        "-1"
      ],
      "env": {
        "motherduck_token": "<your motherduck_token>",
        "MOTHERDUCK_TOKEN": "<your MOTHERDUCK_TOKEN>",
        "HOME": "<your 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": "<your AWS_DEFAULT_REGION>",
        "AWS_ENDPOINT": "<your AWS_ENDPOINT>"
      }
    }
  }
}

Replace each placeholder with your own value before saving.

BADGE

Show your rank

Maintain this server? Add the live rank badge to your README — it updates automatically as the leaderboard changes.

Markdown

[![MCP Toplist](https://mcptoplist.com/badge/io.github.motherduckdb%2Fmcp-server-motherduck.svg)](https://mcptoplist.com/server/io.github.motherduckdb%2Fmcp-server-motherduck)

HTML

<a href="https://mcptoplist.com/server/io.github.motherduckdb%2Fmcp-server-motherduck"><img src="https://mcptoplist.com/badge/io.github.motherduckdb%2Fmcp-server-motherduck.svg" alt="MCP Toplist: Top 1% of 132,046" /></a>

Variants: append ?metric=score or ?metric=stars to the image URL.

REGISTRIES

Listed on 4 registries

ORGANIZATION

motherduckdb

Organization

motherduckdb

Servers in org

Versions across org

VERSIONS

Available versions (16)

Version	Published
1.0.8	Aug 19, 2026
1.0.7	Jun 9, 2026
1.0.6	Apr 29, 2026
1.0.5	Apr 28, 2026
1.0.4	Mar 30, 2026
1.0.3	Mar 4, 2026
1.0.2	Mar 3, 2026
1.0.1	Feb 12, 2026
1.0.0	Feb 2, 2026
0.8.1	Jan 26, 2026
0.8.0	Nov 11, 2025
0.7.2	Oct 13, 2025
0.7.1	Oct 12, 2025
0.7.0	Sep 30, 2025
0.6.4	Sep 10, 2025
0.1.0	Nov 25, 2024

FAQ

Frequently asked questions

Who maintains MCP Server Motherduck?: MCP Server Motherduck is maintained by motherduckdb, which publishes 1 MCP server (16 total versions) tracked on MCP Toplist.
Is MCP Server Motherduck listed on the Official MCP Registry?: Yes — MCP Server Motherduck is listed on the Official MCP Registry, alongside PulseMCP, mcp.so and Glama.
How many versions does MCP Server Motherduck have?: MCP Toplist tracks 16 versions of MCP Server Motherduck, most recently published on Aug 19, 2026.
Where can I find the source code for MCP Server Motherduck?: The source code for MCP Server Motherduck is hosted at github.com/motherduckdb/mcp-server-motherduck.

Used in projects

Do you run this server?

Add to a project

Community projects list the MCP servers behind real agents and apps. Publish yours and this page will link to it.

EXPLORE

All MCP Servers Official MCP Servers GitHub MCP Servers Best MCP Servers Most Active MCP Servers New MCP Servers Best New MCP Servers