motherduckdb/mcp-server-motherduck

DuckDB / MotherDuck 로컬 MCP 서버

AI 어시스턴트 및 IDE를 위한 SQL 분석 및 데이터 엔지니어링.

---

DuckDB의 강력한 분석 SQL 엔진을 사용해 AI 비서를 데이터에 연결하세요. 로컬 DuckDB 파일, 인메모리 데이터베이스, S3 호스팅 데이터베이스, MotherDuck 연결을 지원합니다. SQL 읽기 및 쓰기 쿼리 실행, 데이터베이스 카탈로그 탐색, 다양한 데이터베이스 연결 전환을 실시간으로 지원합니다.

MotherDuck용 완전 관리형 원격 MCP 서버를 찾고 계신가요? → MotherDuck 원격 MCP 문서로 가기

원격 vs 로컬 MCP

퀵 스타트

전제 조건: pip install uv 또는 [[T2]를 통해 uv 설치하세요.

메모리 내 DuckDB에 연결 (개발자 모드)

DuckDB / MotherDuck Local MCP Server

SQL analytics and data engineering for AI Assistants and IDEs.

---

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 read- and write-queries, browsing database catalogs, and switching between different database connections on-the-fly.

Looking for a fully-managed remote MCP server for MotherDuck? → Go to the MotherDuck Remote MCP docs

Remote vs Local MCP

Quick Start

Prerequisites: Install uv via pip install uv or brew install uv

Connecting to In-Memory DuckDB (Dev Mode)

{
  "mcpServers": {
    "DuckDB (in-memory, r/w)": {
      "command": "uvx",
      "args": ["mcp-server-motherduck", "--db-path", ":memory:", "--read-write", "--allow-switch-databases"]
    }
  }
}

Full flexibility with no guardrails — read-write access and the ability to switch to any database (local files, S3, or MotherDuck) at runtime.

Connecting to a Local DuckDB File in Read-Only Mode

{
  "mcpServers": {
    "DuckDB (read-only)": {
      "command": "uvx",
      "args": ["mcp-server-motherduck", "--db-path", "/absolute/path/to/your.duckdb"]
    }
  }
}

Connects to a specific DuckDB file in read-only mode. Won’t hold on to the file lock, so convenient to use alongside a write connection to the same DuckDB file. You can also connect to remote DuckDB files on S3 using s3://bucket/path.duckdb — see Environment Variables for S3 authentication. If you’re considering third-party access to the MCP, see Securing for Production.

Connecting to MotherDuck in Read-Write Mode

{
  "mcpServers": {
    "MotherDuck (local, r/w)": {
      "command": "uvx",
      "args": ["mcp-server-motherduck", "--db-path", "md:", "--read-write"],
      "env": {
        "motherduck_token": ""
      }
    }
  }
}

See Command Line Parameters for more options, Securing for Production for deployment guidance, and Troubleshooting if you encounter issues.

Client Setup

| Client | Config Location | One-Click Install |