mcpbeat Sign in

MCP Server Motherduck

by motherduckdb Your server? Claim it
local only

MCP Server Motherduck runs on your own machine — the client starts it, so there is no endpoint to ping. 4 435 installs a week from pypi. Last commit 19 Aug 2026.

SQL analytics and data engineering for AI Assistants and IDEs

Installs per day peak 2 667 · avg 1 001 · -21% w/w
a month agotoday
4 435
Installs / week
pypi · mcp-server-motherduck
522
Stars
2 open issues
19 Aug 2026
Last commit
0 releases in 90 days
MIT
License
Python

What the code does

We read the source, 19 h ago · rules 3dff92dd89df

Capabilities

What this server is able to do. For an MCP server this is often the job itself — a terminal server runs commands because that is what it is for. Listed so you know what you are plugging in, not as an accusation.

Builds a database query by concatenation [пакет] .github/workflows/bump-version.yml:57, .github/workflows/bump-version.yml:57
      - name: Update version to ${{ inputs.version }}

Is this your server and something here is wrong? Tell us — corrections are free and do not require a plan.

This code can reach further than it looks

We found places where it runs commands, builds paths or queries from values it is given. None of that is a flaw by itself — it becomes one when the code changes, and code changes quietly between releases. We re-read it on every one.

Three servers free · no card

Connect this server

This server runs on your own machine — install it with the package manager and the client starts it for you. Package name taken from the official registry entry.

run in your terminal
claude mcp add mcp-server-motherduck -- uvx mcp-server-motherduck
~/Library/Application Support/Claude/claude_desktop_config.json
{
  "mcpServers": {
    "mcp-server-motherduck": {
      "args": [
        "mcp-server-motherduck"
      ],
      "command": "uvx"
    }
  }
}
~/.codex/config.toml
[mcp_servers.mcp-server-motherduck]
command = "uvx"
args = ["mcp-server-motherduck"]
.cursor/mcp.json
{
  "mcpServers": {
    "mcp-server-motherduck": {
      "args": [
        "mcp-server-motherduck"
      ],
      "command": "uvx"
    }
  }
}
.vscode/mcp.json
{
  "mcpServers": {
    "mcp-server-motherduck": {
      "args": [
        "mcp-server-motherduck"
      ],
      "command": "uvx"
    }
  }
}

This one needs environment variables set before it will start: motherduck_token (Access token for MotherDuck connections (alternative to --motherduck-token)), MOTHERDUCK_TOKEN (Access token for MotherDuck connections (alternative to --motherduck-token)), HOME (Used by DuckDB for extensions and config. Override with --home-dir if not set.), AWS_ACCESS_KEY_ID (AWS access key for S3 database connections), AWS_SECRET_ACCESS_KEY (AWS secret access key for S3 database connections), AWS_SESSION_TOKEN (AWS session token for temporary credentials), AWS_DEFAULT_REGION (AWS region for S3 database connections), AWS_ENDPOINT (AWS endpoint for S3 database connections). The author declared them in the registry entry; get the values from the project itself.

Alternatives to MCP Server Motherduck

same job, measured the same way
Snowflake MCP Server
by nsphung

A Snowflake MCP server — SQL queries, schema exploration, and data insights for AI assistants

591 installs/wk local only
fabric-dw
by sdebruyn

MCP server for Microsoft Fabric Data Warehouses and SQL Analytics Endpoints

local only
Manticore Search
by manticoresoftware

MCP server for Manticore Search — lets AI assistants query and manage search databases.

75 installs/wk local only
Keboola
by keboola

Connect your AI assistants to Keboola and expose your data, transformations, SQL queries, ...

3 079 installs/wk answering
Memory Engine MCP
by simoneb79

Local-first graph memory for AI assistants with SQLite, semantic search, and MCP tools.

local only
SAP HANA CLI
by sap-samples

150+ SAP HANA database tools as MCP tools for AI assistants

766 installs/wk local only
openLCA MCP Server
by below280

Connect AI assistants to openLCA. 31 tools for database search, model building, and LCIA.

4 503 installs/wk local only
Infrawise
by sidd27

Live AWS, database & Kafka infrastructure context for AI coding assistants via MCP.

350 installs/wk local only

MCP Server Motherduck — questions

Answers built from our own checks of this server.

Why is there no uptime for MCP Server Motherduck?
MCP Server Motherduck runs on your own machine over stdio — there is no network address to reach, so uptime cannot be measured for it by anyone. What can be measured is adoption: the pypi package mcp-server-motherduck was installed 4 435 times last week.
How do I connect MCP Server Motherduck?
Copy the ready config from this page — we generate it for Claude Code, Claude Desktop, Codex, Cursor and VS Code, each with the file path that client actually reads. It runs locally, so the command pulls mcp-server-motherduck straight from pypi; nothing to host, nothing to sign up for.
How many people use MCP Server Motherduck?
The pypi package mcp-server-motherduck was installed 4 435 times in the last week. Week over week that is -21%. We show installs rather than GitHub stars on purpose: a star is a bookmark, an install is someone actually running it.
Is MCP Server Motherduck open source?
Yes — it is published under the MIT licence, written in Python, 522 stars on GitHub and 2 open issues. The source link is on this page, so you can read exactly what it does with your data before you connect it.