Official server by MotherDuck
MotherDuck / DuckDB MCP server
SQL analytics over DuckDB and MotherDuck.
Install
Pick your agent and copy one line. Remote servers ask you to sign in on first use.
claude mcp add motherduck -- uvx mcp-server-motherduck
# ~/.codex/config.toml [mcp_servers.motherduck] command = "uvx" args = ["mcp-server-motherduck"]
gemini mcp add motherduck uvx mcp-server-motherduck
{
"mcpServers": {
"motherduck": {
"command": "uvx",
"args": [
"mcp-server-motherduck"
]
}
}
}code --add-mcp '{"name":"motherduck","command":"uvx","args":["mcp-server-motherduck"]}'Comparing options? Database MCP servers compared →
What it can do
From MotherDuck's own MCP documentation.
Sign in
Hosted: OAuth for most clients, or Authorization: Bearer with a MotherDuck token. Local: motherduck_token or MOTHERDUCK_TOKEN env var, or --motherduck-token.
Tools
execute_querylist_databaseslist_tableslist_columnsswitch_database_connection
Options
- Local server is read-only by default. --read-write enables writes.
- --allow-switch-databases enables switch_database_connection.
- --max-rows (default 1024) and --max-chars (default 50000) cap results.
- --query-timeout, --init-sql, --db-path (default :memory:), --transport stdio or http.
- --motherduck-saas-mode.
Good to know
- The tool list above is for the local open source server. The hosted server groups tools into core, Dive, Flight and Guide tools without listing names.
- The hosted server is read-write and available in all MotherDuck regions. Query results pass through the remote server.
- Read-only mode against MotherDuck needs a read-scaling token. Regular tokens need --read-write.
- Read-only mode alone is not enough to safely give third parties access to a self-hosted server.
Details
- Registry name
- io.github.motherduckdb/mcp-server-motherduck
- Latest version
- 1.1.0 (updated 2026-10-07)
- Packages
mcp-server-motherduck (pypi)
- Links
- MotherDuck docsSource
More in Databases
Reviewed Oct 21, 2026. Official means published under MotherDuck's namespace in the MCP registry. It is not a security audit.
Built an MCP server? Get it listed everywhere →
Shipping an Android app? Google Play needs 12 testers for 14 days first. Get them with Tester Exchange →