MCP server
DuckDB MCP server
Query local DuckDB files or MotherDuck cloud databases with SQL.
★ 534pushed 2026-10-07MIT
Run in a terminal. Everything after -- is the command that starts the server. docs
claude mcp add --transport stdio motherduck-duckdb -- uvx mcp-server-motherduck
Claude Desktop only: Settings > Developer > Edit Config opens claude_desktop_config.json. Add this, save and restart the app. docs
{
"mcpServers": {
"motherduck-duckdb": {
"command": "uvx",
"args": [
"mcp-server-motherduck"
]
}
}
}Add to ~/.cursor/mcp.json (all projects) or .cursor/mcp.json (this project), or use the install button. docs
{
"mcpServers": {
"motherduck-duckdb": {
"command": "uvx",
"args": [
"mcp-server-motherduck"
]
}
}
}Add to .vscode/mcp.json (note the "servers" key and the type), or use the install button. Command Palette > "MCP: Open User Configuration" for all workspaces. docs
{
"servers": {
"motherduck-duckdb": {
"type": "stdio",
"command": "uvx",
"args": [
"mcp-server-motherduck"
]
}
}
}Run codex mcp add motherduck-duckdb -- uvx mcp-server-motherduck, or add this to ~/.codex/config.toml. docs
[mcp_servers.motherduck-duckdb] command = "uvx" args = ["mcp-server-motherduck"]
Run in a terminal (-s user adds it for all projects; the default is this project). docs
gemini mcp add -s user motherduck-duckdb uvx mcp-server-motherduck
Run in a terminal; it writes ~/.copilot/mcp-config.json. docs
copilot mcp add motherduck-duckdb -- uvx mcp-server-motherduck
Add to mcp_config.json: ~/.config/devin/mcp_config.json on macOS and Linux (older installs: ~/.codeium/windsurf/mcp_config.json), %APPDATA%\devin\ on Windows. docs
{
"mcpServers": {
"motherduck-duckdb": {
"command": "uvx",
"args": [
"mcp-server-motherduck"
]
}
}
}Add to Zed's settings.json (or Settings > AI > MCP Servers > Add Server). Remote servers without an Authorization header sign in with OAuth. docs
{
"context_servers": {
"motherduck-duckdb": {
"command": "uvx",
"args": [
"mcp-server-motherduck"
]
}
}
}Add to opencode.json in the project (or ~/.config/opencode/opencode.json). docs
{
"$schema": "https://opencode.ai/config.json",
"mcp": {
"motherduck-duckdb": {
"type": "local",
"command": [
"uvx",
"mcp-server-motherduck"
],
"enabled": true
}
}
}Add to ~/.kiro/settings/mcp.json (all projects) or .kiro/settings/mcp.json (this project). docs
{
"mcpServers": {
"motherduck-duckdb": {
"command": "uvx",
"args": [
"mcp-server-motherduck"
]
}
}
}MCP Servers > Configure > Configure MCP Servers opens cline_mcp_settings.json; add this entry. docs
{
"mcpServers": {
"motherduck-duckdb": {
"command": "uvx",
"args": [
"mcp-server-motherduck"
]
}
}
}FAQ
Is there an official DuckDB MCP server?+
Yes: MotherDuck / DuckDB, maintained by MotherDuck.
How do I connect DuckDB to Claude?+
In Claude Code, run the claude mcp add command shown above. In Claude Desktop, add the server to claude_desktop_config.json (Settings > Developer > Edit Config) and restart the app.
How do I use the DuckDB MCP server in Cursor or VS Code?+
Open the Cursor or VS Code tab on the server above: it has the exact mcp.json entry and a one-click install link. The same server also works in Claude Code, Claude Desktop / claude.ai, ChatGPT, Cursor, VS Code and Codex.
Is it safe to give an AI agent access to DuckDB?+
Start with the official server, a read-only or test account and approval prompts on for anything that writes. Content the agent reads from DuckDB (tickets, messages, pages) can carry prompt-injection instructions, so don't auto-approve actions.
All database MCP servers · Agent skills · How MCP setup works in each client
MCP servers for similar apps: AlloyDB · Azure SQL · BigQuery · Chroma · ClickHouse · Cloud SQL · CockroachDB · Confluent · Convex · Couchbase · Databricks · Dataplex · dbt · Elasticsearch · Firebase · Firestore · Fivetran · Kafka · MariaDB · Metabase · Milvus · MongoDB · MotherDuck · MySQL