mcp-server-motherduck
About
SQL analytics and data engineering for AI Assistants and IDEs
Use this server
Add it to your MCP client. The catalogue lists this config verbatim from its source — it does not run, download, or vouch for the server. Review the command before you run it.
Transportstdio (runs a local command)
Env vars
MOTHERDUCK_TOKEN HOME AWS_ACCESS_KEY_ID AWS_SECRET_ACCESS_KEY AWS_SESSION_TOKEN AWS_DEFAULT_REGION AWS_ENDPOINTClaude Code
claude mcp add --env MOTHERDUCK_TOKEN= --env HOME= --env AWS_ACCESS_KEY_ID= --env AWS_SECRET_ACCESS_KEY= --env AWS_SESSION_TOKEN= --env AWS_DEFAULT_REGION= --env AWS_ENDPOINT= mcp-server-motherduck -- uvx mcp-server-motherduck
Cursor
If the button doesn't open Cursor, use the JSON below — Cursor accepts the same mcpServers config.
VS Code
code --add-mcp '{"name":"mcp-server-motherduck","command":"uvx","args":["mcp-server-motherduck"],"env":{"MOTHERDUCK_TOKEN":"","HOME":"","AWS_ACCESS_KEY_ID":"","AWS_SECRET_ACCESS_KEY":"","AWS_SESSION_TOKEN":"","AWS_DEFAULT_REGION":"","AWS_ENDPOINT":""}}'
JSON
{
"mcpServers": {
"mcp-server-motherduck": {
"command": "uvx",
"args": [
"mcp-server-motherduck"
],
"env": {
"MOTHERDUCK_TOKEN": "",
"HOME": "",
"AWS_ACCESS_KEY_ID": "",
"AWS_SECRET_ACCESS_KEY": "",
"AWS_SESSION_TOKEN": "",
"AWS_DEFAULT_REGION": "",
"AWS_ENDPOINT": ""
}
}
}
}
Environment variables are listed by name only — fill in your own values. Entries never carry secrets.