Data · 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
data
Transport
stdio (local process)
Package
PyPI
Published
2026-08-19
Updated
2026-08-19
Publisher
motherduckdb (GitHub)
Namespace
Namespace verified by the MCP Registry via GitHub (github.com/motherduckdb) · how
Repository
github.com/motherduckdb/mcp-server-motherduck
Source
Registry API entry

Packages

RegistryPackageVersionTransportEnvironment variables
PyPImcp-server-motherduck1.0.8stdiomotherduck_token (secret), MOTHERDUCK_TOKEN (secret), HOME, AWS_ACCESS_KEY_ID (secret), AWS_SECRET_ACCESS_KEY (secret), AWS_SESSION_TOKEN (secret), AWS_DEFAULT_REGION, AWS_ENDPOINT

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 data servers

All 4,815 →
ServerRunsEndpoint or package
MCP Server Agent AnalyticsTrack AI agent fleet performance, costs, anomalies, and trends.Local · stdionpm: mcp-server-agent-analytics
MCP Server ClawhubClawHub.ai skill catalog: search, browse, inspect, and download skills (token publish).Local · stdionpm: @aiwerk/mcp-server-clawhub
MCP Server EspnReal-time ESPN sports data: live scores, standings, boxscores, odds & stats for 25+ leagues.Remote · SSELive check: sign-in requiredmrbridge--espn-mcp-server.apify.actor
MCP Server McdevMcdev MCP: wiki search,.mcdevrc help, journey checklists, metadata types via mcdev.Local · stdionpm: mcp-server-mcdev
MCP Server TflCommunity-built server providing real-time London transport data via the TfL Unified API.Local · stdioOCI image (Docker): ghcr.io/oneill9/mcp-server-tfl:1.4.0
MCP StashboxSearch scenes, performers, studios and tags across the public stash-box catalogues.Local · stdionpm: mcp-stashbox
MCP Talent Agency LookupMatch an influencer to their talent agency, or an agency to its public creator roster.Local · stdionpm: @mambalabsdev/mcp-talent-agency-lookup
MCP TedTED MCP Server: Real-time EU public tenders access. https://www.lexsocket.ai/.Remote · HTTPLive check: ✗ no handshakemcp.lexsocket.ai