# Does DuckDB have an MCP server?

**Sort of — Community only.** DuckDB does not maintain an official MCP server. Community-built servers exist.

> The most-used DuckDB MCP server is maintained by MotherDuck, a separate commercial company, not by DuckDB Labs or the DuckDB Foundation.

## Facts

- Verdict: Community only (Sort of)
- Access: Local server — Runs on your machine over stdio, launched by your MCP client.
- Repository: [motherduckdb/mcp-server-motherduck](https://github.com/motherduckdb/mcp-server-motherduck) — ★ 525, last push 2026-09-19, MIT
- Maintainer: MotherDuck
- Language: Python
- Category: [Databases](https://mcpyet.com/category/databases/)
- Verified against vendor docs: 2026-09-29
- GitHub data refreshed: 2026-09-29 (re-checked every 6 hours)

## What it does

> Local MCP server for DuckDB and MotherDuck
> — how [motherduckdb/mcp-server-motherduck](https://github.com/motherduckdb/mcp-server-motherduck) describes itself

## The receipts

- **Top community server:** [motherduckdb/mcp-server-motherduck](https://github.com/motherduckdb/mcp-server-motherduck) — ★ 525, pushed 2026-09-19, MIT (active)

## How to connect it

Runs on your machine over stdio, launched by your MCP client.

### Claude Code

```sh
claude mcp add duckdb -- npx -y <package-from-readme>
```

Swap in the exact package and flags from the repo README — most servers need an API key passed as an environment variable. Add `--scope user` to make it available in every project.

### Claude Desktop

Open **Settings → Developer → Edit Config** and add the server to `claude_desktop_config.json`, then restart Claude Desktop:

```json
{
  "mcpServers": {
    "duckdb": {
      "command": "npx",
      "args": [
        "-y",
        "<package-from-readme>"
      ],
      "env": {
        "API_KEY": "…"
      }
    }
  }
}
```

### Cursor

Add to `.cursor/mcp.json` in your project, or `~/.cursor/mcp.json` for every project:

```json
{
  "mcpServers": {
    "duckdb": {
      "command": "npx",
      "args": [
        "-y",
        "<package-from-readme>"
      ],
      "env": {
        "API_KEY": "…"
      }
    }
  }
}
```

### VS Code

Add to `.vscode/mcp.json`, then pick the server from Copilot's agent-mode tools menu:

```json
{
  "servers": {
    "duckdb": {
      "type": "stdio",
      "command": "npx",
      "args": [
        "-y",
        "<package-from-readme>"
      ]
    }
  }
}
```

### ChatGPT

ChatGPT connects to **remote servers only**, and this one runs on your machine. Either expose it through an MCP gateway that gives it a public URL, or use a client with native local support (Claude or Cursor).

## Before you connect this

A community server is unaudited third-party code that will hold your DuckDB API credentials and see whatever data they unlock. Independent research puts SSRF vulnerabilities in roughly a third of public MCP servers, and 41% ship with no authentication at all.

- Read the source before running it — especially any network calls it makes.
- Check who maintains it and whether commits are recent (this one: last push 2026-09-19).
- Issue a scoped, revocable API key rather than an account-wide token.
- Prefer read-only credentials until you trust it with writes.

## How we know

I found no MCP server in the duckdb GitHub org, the DuckDB docs or the MCP Registry under a DuckDB namespace. duckdb.org only lists the third-party duckdb_mcp community extension. The strongest dedicated server is motherduckdb/mcp-server-motherduck (~525 stars, actively maintained), which queries local DuckDB files as well as MotherDuck.

- GitHub data refreshed 2026-09-29, then every 6 hours.
- Vendor docs verified on 2026-09-29.
- Corrections: hello@mcpyet.com.

## Also in Databases

- [Snowflake](https://mcpyet.com/mcp/snowflake.md) — Official (Yes)
- [Firebase](https://mcpyet.com/mcp/firebase.md) — Official (Yes)
- [Supabase](https://mcpyet.com/mcp/supabase.md) — Official (Yes)
- [PostgreSQL](https://mcpyet.com/mcp/postgres.md) — Community only (Sort of)
- [BigQuery](https://mcpyet.com/mcp/bigquery.md) — Official (Yes)
- [ClickHouse](https://mcpyet.com/mcp/clickhouse.md) — Official (Yes)

---

Source: https://mcpyet.com/mcp/duckdb/ — data refreshed 2026-09-29