mcp-server-motherduck

motherduckdb/mcp-server-motherduck

★ 439 stars Python Database Updated 3mo ago

Local MCP server for DuckDB and MotherDuck

View on GitHub → Try with Claude — $10 free →

Quick Install

Copy the config for your editor. Some servers may need additional setup — check the README.

Add to claude_desktop_config.json:

{
  "mcpServers": {
    "mcp-server-motherduc": {
      "command": "uvx",
      "args": [
        "mcp-server-motherduck"
      ]
    }
  }
}

Or install with pip: pip install mcp-server-motherduck

README Excerpt

<p align="center"> <img src="src/mcp_server_motherduck/assets/duck_feet_square.png" alt="MotherDuck / DuckDB Local MCP Server" width="120"> </p> <h1 align="center">DuckDB / MotherDuck Local MCP Server</h1> <p align="center"> SQL analytics and data engineering for AI Assistants and IDEs. </p> --- Connect AI assistants to your data using DuckDB's powerful analytical SQL engine. Supports connecting to local DuckDB files, in-memory databases, S3-hosted databases, and MotherDuck. Allows executing SQL

Tools (16)

AWS_ACCESS_KEY_IDAWS_DEFAULT_REGIONAWS_SECRET_ACCESS_KEYAWS_SESSION_TOKENFalseHOMENoneTrueexecute_querylist_columnslist_databaseslist_tablespathsqlstdiotable

Topics

aiduckdbmotherduck

📊

Working with market or time-series data?

The Polymarket Historical Dataset — 18.5M+ price snapshots across 18,600+ prediction markets (CSV + SQLite). Built for backtesting & ML.

View dataset →

mcp-server-motherduck

Quick Install

README Excerpt

Tools (16)

Topics

Related Database Servers