MotherDuck
Lets an agent run SQL to read and write data in MotherDuck and DuckDB, and inspect database catalogs. Summary written by AI Index.
The registry’s description: SQL analytics and data engineering for AI Assistants and IDEs
Add to your client
Add the MotherDuck MCP server to Claude Code
Run the command
claude mcp add motherduck -- uvx mcp-server-motherduckFill in the values ↓
Check it’s connected
Add the MotherDuck MCP server to Cursor
Open mcp.json· Where the file is:
~/.cursor/mcp.json,.cursor/mcp.jsonPaste the server entry
{ "mcpServers": { "motherduck": { "command": "uvx", "args": [ "mcp-server-motherduck" ] } } }Fill in the values ↓
Check it’s connected
Add the MotherDuck MCP server to VS Code
Open mcp.json· Where the file is:
.vscode/mcp.jsonPaste the server entry
{ "servers": { "motherduck": { "command": "uvx", "args": [ "mcp-server-motherduck" ] } } }Fill in the values ↓
Check it’s connected
Add the MotherDuck MCP server to Codex
Run the command
codex mcp add motherduck -- uvx mcp-server-motherduckFill in the values ↓
Check it’s connected
Add the MotherDuck MCP server to Devin Desktop
Open mcp_config.json· Where the file is:
~/.config/devin/mcp_config.json,%APPDATA%\devin\mcp_config.jsonPaste the server entry
{ "mcpServers": { "motherduck": { "command": "uvx", "args": [ "mcp-server-motherduck" ] } } }Fill in the values ↓
Check it’s connected
Add the MotherDuck MCP server to Gemini CLI
Open settings.json· Where the file is:
~/.gemini/settings.json,.gemini/settings.jsonPaste the server entry
{ "mcpServers": { "motherduck": { "command": "uvx", "args": [ "mcp-server-motherduck" ] } } }Fill in the values ↓
Check it’s connected
Add the MotherDuck MCP server to GitHub Copilot
Run the command
copilot mcp add motherduck -- uvx mcp-server-motherduckFill in the values ↓
Check it’s connected
Add the MotherDuck MCP server to Cline
Open cline_mcp_settings.json· Where the file is:
~/.cline/data/settings/cline_mcp_settings.jsonPaste the server entry
{ "mcpServers": { "motherduck": { "command": "uvx", "args": [ "mcp-server-motherduck" ] } } }Fill in the values ↓
Check it’s connected
Add the MotherDuck MCP server to Kiro
Open mcp.json· Where the file is:
.kiro/settings/mcp.json,~/.kiro/settings/mcp.jsonPaste the server entry
{ "mcpServers": { "motherduck": { "command": "uvx", "args": [ "mcp-server-motherduck" ] } } }Fill in the values ↓
Check it’s connected
Add the MotherDuck MCP server to Zed
Open settings.json
Paste the server entry
{ "context_servers": { "motherduck": { "command": "uvx", "args": [ "mcp-server-motherduck" ], "env": {} } } }Fill in the values ↓
Check it’s connected
Add the MotherDuck MCP server to OpenCode
Open opencode.json· Where the file is:
~/.config/opencode/opencode.json,opencode.jsonPaste the server entry
{ "$schema": "https://opencode.ai/config.json", "mcp": { "motherduck": { "type": "local", "command": [ "uvx", "mcp-server-motherduck" ], "enabled": true } } }Fill in the values ↓
Check it’s connected
Add the MotherDuck MCP server to JetBrains AI Assistant
Open JetBrains AI Assistant’s MCP config
- Open Settings | Tools | AI Assistant | Model Context Protocol (MCP).
- Choose Add.
Paste the server entry
{ "mcpServers": { "motherduck": { "command": "uvx", "args": [ "mcp-server-motherduck" ] } } }Fill in the values ↓
Check it’s connected
If the file already has servers, add the entry inside the existing object. To check it’s connected, restart or reload the client and look for motherduck in its list of MCP servers. A server that needs sign-in opens it on first use.
What you fill in
Required values appear as <NAME> placeholders in the snippets; add optional ones the same way. Descriptions are the server’s registry entry’s.
<motherduck_token>Environment variable Optional · SecretAccess token for MotherDuck connections (alternative to --motherduck-token)
<MOTHERDUCK_TOKEN>Environment variable Optional · SecretAccess token for MotherDuck connections (alternative to --motherduck-token)
<HOME>Environment variable OptionalUsed by DuckDB for extensions and config. Override with --home-dir if not set.
<AWS_ACCESS_KEY_ID>Environment variable Optional · SecretAWS access key for S3 database connections
<AWS_SECRET_ACCESS_KEY>Environment variable Optional · SecretAWS secret access key for S3 database connections
<AWS_SESSION_TOKEN>Environment variable Optional · SecretAWS session token for temporary credentials
<AWS_DEFAULT_REGION>Environment variable OptionalAWS region for S3 database connections
<AWS_ENDPOINT>Environment variable OptionalAWS endpoint for S3 database connections
Client compatibility
By transport: whether the client’s docs list a transport this server offers. It doesn’t cover sign-in or other requirements.
- Claude Code Transport supported
- Cursor Transport supported
- VS Code Client docs don’t list transports
- Codex Transport supported
- Devin Desktop Transport supported
- Gemini CLI Transport supported
- GitHub Copilot Client docs don’t list transports
- Cline Transport supported
- Kiro Transport supported
- Zed Client docs don’t list transports
- OpenCode Client docs don’t list transports
- JetBrains AI Assistant Transport supported
- Claude Client docs don’t list transports
- ChatGPT No shared transport
Sources
- Official MCP Registry registry.modelcontextprotocol.io · checked Nov 4, 2026
- MotherDuck: vendor documentation motherduck.com · checked Nov 1, 2026
This data comes from the Official MCP Registry.