Does DuckDB have an MCP server?
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.
- Access
- Local server
- Repository
- motherduckdb/mcp-server-motherduck
- Maintainer
- MotherDuck
- License
- MIT
- Language
- Python
- Stars
- 525
- Last commit
- 11d ago
- Category
- Databases
Local MCP server for DuckDB and MotherDuck
Local MCP server for DuckDB and MotherDuck
Runs on your machine over stdio, launched by your MCP client.
Add it from the terminal, then restart your session:
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.
Open Settings → Developer → Edit Config and add the server to claude_desktop_config.json:
{
"mcpServers": {
"duckdb": {
"command": "npx",
"args": [
"-y",
"<package-from-readme>"
],
"env": {
"API_KEY": "…"
}
}
}
}Restart Claude Desktop after saving.
Add to .cursor/mcp.json in your project, or ~/.cursor/mcp.json for
every project:
{
"mcpServers": {
"duckdb": {
"command": "npx",
"args": [
"-y",
"<package-from-readme>"
],
"env": {
"API_KEY": "…"
}
}
}
}A green dot in Settings → MCP means it connected.
Add to .vscode/mcp.json:
{
"servers": {
"duckdb": {
"type": "stdio",
"command": "npx",
"args": [
"-y",
"<package-from-readme>"
]
}
}
}Then pick the server from the tools menu in Copilot's agent mode.
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: 11d ago).
- Issue a scoped, revocable API key rather than an account-wide token.
- Prefer read-only credentials until you trust it with writes.
Does DuckDB have an official MCP server?
No. DuckDB does not maintain one. Third-party developers have built community servers, the most established being motherduckdb/mcp-server-motherduck, but they are not endorsed or supported by DuckDB.
How do I connect DuckDB to Claude?
Run the server locally and register it in Claude's MCP config. In Claude Code that's a single "claude mcp add" command; in Claude Desktop you add it to claude_desktop_config.json.
Is it safe to use a community DuckDB MCP server?
Treat it like any dependency that gets your API keys. Community MCP servers are unaudited third-party code: independent research has found roughly a third of public MCP servers carry SSRF vulnerabilities and 41% ship with no authentication. Read the source, check the maintainer and commit recency, and scope the credentials you hand it.
How is this verdict verified?
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 metadata is refreshed every six hours.
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
Work at DuckDB? The moment you ship an official server this page flips to Official — send us the link.