motherduckdb/mcp-server-motherduckMCPMCP Server

mcp-server-motherduck

Local MCP server for DuckDB and MotherDuck

488stars

84forks

Python

aiduckdbmotherduck

Quality signals

ActiveNo testsNo CIThin docsNo licensePopular

Open Repository Download ZIP

AI summary

Auto-generated overview of what this skill does and when to reach for it.

Local MCP server that lets AI assistants and IDEs run SQL queries against DuckDB files, S3-hosted databases, or MotherDuck without cloud setup.

Use this when

Querying local DuckDB files during development
Running ad-hoc SQL on S3-hosted DuckDB databases
Testing SQL scripts against in-memory DuckDB
Switching between multiple DuckDB databases in one session
Integrating DuckDB with AI assistants like Claude or Cursor

Don't use when

Need a fully-managed remote server
Working with non-SQL databases like MongoDB
Requiring strict filesystem isolation in production

Capabilities

Execute read/write SQL queries against DuckDB files
Connect to in-memory, local file, S3, or MotherDuck databases
Browse database catalogs and list tables/columns
Switch database connections at runtime
Support DuckDB SQL dialect with 1024-row result limits
Toggle read-only or read-write mode via flags

InstallMCPRun via uvx (Python)

Universal installANY TOOL

$ npx skillcity@latest motherduckdb/mcp-server-motherduck

Auto-detects the skill or MCP server in this repo and installs it for Claude Code, Codex, Cursor, Cline, OpenCode, Gemini CLI, Anti-Gravity, OpenClaw and Hermes.

Requires Node.js 18+ (ships with npx).

Or install manually

uvx mcp-server-motherduck

MCP Configuration

Add this to your claude_desktop_config.json

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

Loading README…

Discover the toolingbehind modern intelligence

Discover the toolingbehind modern intelligence

mcp-server-motherduck