mcp-server-motherduck

motherduckdb/mcp-server-motherduck
★ 439 stars Python 🗄️ Database Updated 1mo ago
Local MCP server for DuckDB and MotherDuck
View on GitHub →

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