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 718 installs a week from pypi. Last commit 7 Oct 2026.

SQL analytics and data engineering for AI Assistants and IDEs

Installs per day peak 2 332 · avg 833 · -11% w/w
a month agotoday
4 718
Installs / week
pypi · mcp-server-motherduck
536
Stars
0 open issues
7 Oct 2026
Last commit
from GitHub
MIT
License
Python

Nothing serious here today

Today is the operative word: we check MCP Server Motherduck every 15 minutes and re-read its code on every release. Watch it and you find out the day that stops being true.

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": {
      "command": "uvx",
      "args": [
        "mcp-server-motherduck"
      ]
    }
  }
}
~/.codex/config.toml
[mcp_servers.mcp-server-motherduck]
command = "uvx"
args = ["mcp-server-motherduck"]
.cursor/mcp.json
{
  "mcpServers": {
    "mcp-server-motherduck": {
      "command": "uvx",
      "args": [
        "mcp-server-motherduck"
      ]
    }
  }
}
.vscode/mcp.json
{
  "servers": {
    "mcp-server-motherduck": {
      "type": "stdio",
      "command": "uvx",
      "args": [
        "mcp-server-motherduck"
      ]
    }
  }
}

Optional settings from the registry entry, left out of the block above: 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).

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

194 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.

114 installs/wk local only
Keboola
by keboola

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

2 294 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

2 186 installs/wk local only
Muvia BI
by muviabi

Company and industrial data for AI assistants: datasets, SQL, dashboards, alarms, with approvals.

answering
openLCA MCP Server
by below280

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

244 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 718 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 in the form 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 718 times in the last week. Week over week that is -11%. 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 and 536 stars on GitHub. The source link is on this page, so you can read exactly what it does with your data before you connect it.