Developer · Local MCP server
MCP Server Motherduck
SQL analytics and data engineering for AI Assistants and IDEs.
What the MCP Registry states
The entry as published to the official MCP Registry (read 2026-10-04), latest version.
- Registry name
io.github.motherduckdb/mcp-server-motherduck- Version
- 1.0.8
- Status
- Active
- Category
- developer
- Transport
- stdio (local process)
- Package
- PyPI
- Published
- 2026-08-19
- Updated
- 2026-08-19
- Publisher
- motherduckdb (GitHub)
- Repository
- github.com/motherduckdb/mcp-server-motherduck
- Source
- Registry API entry
Packages
| Registry | Package | Version | Transport |
|---|---|---|---|
| PyPI | mcp-server-motherduck | 1.0.8 | stdio |
How to connect MCP Server Motherduck
MCP Server Motherduck runs locally from a Python package published to PyPI: mcp-server-motherduck version 1.0.8. It speaks MCP over stdio, so the client starts it as a program and talks to it through standard input and output. It needs Python; clients usually start it with uvx (from uv) or after pip install — the usual command is uvx mcp-server-motherduck. It reads these environment variables: motherduck_token (secret), MOTHERDUCK_TOKEN (secret), HOME, AWS_ACCESS_KEY_ID (secret), AWS_SECRET_ACCESS_KEY (secret), AWS_SESSION_TOKEN (secret), AWS_DEFAULT_REGION and AWS_ENDPOINT; set them in the client's configuration for this server.
In the mcpServers JSON format that many desktop and editor MCP clients read, the entry looks like this (placeholders in angle brackets):
{
"mcpServers": {
"mcp-server-motherduck": {
"command": "uvx",
"args": [
"mcp-server-motherduck"
],
"env": {
"motherduck_token": "<secret>",
"MOTHERDUCK_TOKEN": "<secret>",
"HOME": "<value>",
"AWS_ACCESS_KEY_ID": "<secret>",
"AWS_SECRET_ACCESS_KEY": "<secret>",
"AWS_SESSION_TOKEN": "<secret>",
"AWS_DEFAULT_REGION": "<value>",
"AWS_ENDPOINT": "<value>"
}
}
}
}Derived from the registry entry, not tested here. What the server does, and on what terms, is set by its publisher; check its repository or website before giving it access to your accounts or files. How to add an MCP server to an assistant · Before you connect
More developer servers
| Server | Runs |
|---|---|
| MCP Server IndexforgeSubmit URLs to Google and Bing for indexing, scan sitemaps, check index status. | Local · stdio |
| MCP Server KalshiMCP server for end-to-end trading on Kalshi prediction markets: discover, research, trade. | Local · stdio |
| MCP Server LolLeague of Legends AI coaching: player profiles, match history, ranked stats & performance analysis. | Remote · SSE |
| MCP Server MalcolmMCP server for Malcolm (Zeek/Suricata/Arkime/OpenSearch): threat-hunting access for AI agents. | Local · stdio |
| MCP Server PolarionMCP server for Polarion ALM — read and write documents and work items. | Local · stdio |
| MCP Server R CounterA MCP Server Counting Number of r's for a Given Query. | Local · stdio |
| MCP Server Research SignalsScored trend intelligence from HN, Reddit, ArXiv, and GitHub. | Local · stdio |
| MCP Server Ros 2View ROS 2 nodes and topics, and call services and actions via MCP. | Local · stdio |