SQL analytics and data engineering for AI Assistants and IDEs
uvx mcp-server-motherduck{
"motherduck_token": "YOUR_SECRET_VALUE",
"MOTHERDUCK_TOKEN": "YOUR_SECRET_VALUE",
"HOME": "YOUR_VALUE_HERE",
"AWS_ACCESS_KEY_ID": "YOUR_SECRET_VALUE",
"AWS_SECRET_ACCESS_KEY": "YOUR_SECRET_VALUE",
"AWS_SESSION_TOKEN": "YOUR_SECRET_VALUE",
"AWS_DEFAULT_REGION": "YOUR_VALUE_HERE",
"AWS_ENDPOINT": "YOUR_VALUE_HERE"
}Add this server entry to the mcpServers object in your Claude Desktop config, then restart the app.
{
"mcpServers": {
"io-github-motherduckdb-mcp-server-motherduck": {
"command": "uvx",
"args": [
"mcp-server-motherduck"
],
"env": {
"motherduck_token": "YOUR_SECRET_VALUE",
"MOTHERDUCK_TOKEN": "YOUR_SECRET_VALUE",
"HOME": "YOUR_VALUE_HERE",
"AWS_ACCESS_KEY_ID": "YOUR_SECRET_VALUE",
"AWS_SECRET_ACCESS_KEY": "YOUR_SECRET_VALUE",
"AWS_SESSION_TOKEN": "YOUR_SECRET_VALUE",
"AWS_DEFAULT_REGION": "YOUR_VALUE_HERE",
"AWS_ENDPOINT": "YOUR_VALUE_HERE"
}
}
}
}~/Library/Application Support/Claude/claude_desktop_config.json%APPDATA%\Claude\claude_desktop_config.jsonNo remote HTTP endpoint is advertised. Use the package or stdio setup shown in Install.
mcp-server-motherduck is an MCP server for SQL analytics and data engineering for AI Assistants and IDEs. It supports STDIO transport.
Use the generated config in Install. This server runs with uvx mcp-server-motherduck; add any required environment variables before starting your client.
Choose the Claude Desktop tab in Install and copy the config for uvx mcp-server-motherduck. Add required environment variables before starting Claude Desktop.
Choose the Claude Code tab in Install and copy the config for uvx mcp-server-motherduck. Add required environment variables before starting Claude Code.
Choose the Codex tab in Install and copy the config for uvx mcp-server-motherduck. Add required environment variables before starting Codex.
Choose the Cursor or VS Code tab in Install and copy the config for uvx mcp-server-motherduck. Add required environment variables before starting Cursor or VS Code.
mcp-server-motherduck uses STDIO transport. Use the package or command config in Install.
mcp-server-motherduck inventory is listed when the MCP endpoint exposes tools, resources, or prompts. Some servers require auth first.
mcp-server-motherduck does not advertise a verified auth requirement. If discovery fails, it may still need provider login, an API key, a bearer token, or a session header.
| Package | Registry | Version | Inputs |
|---|---|---|---|
mcp-server-motherduckstdio | pypi | 1.0.6 | Argument: --transport Argument: --port Argument: --host Argument: --db-path Argument: --motherduck-token Argument: --read-write Argument: --allow-switch-databases Argument: --motherduck-saas-mode Argument: --init-sql Argument: --home-dir Argument: --max-rows Argument: --max-chars Argument: --query-timeout Argument: --ephemeral-connections Env: motherduck_token secret Env: MOTHERDUCK_TOKEN secret Env: HOME Env: AWS_ACCESS_KEY_ID secret Env: AWS_SECRET_ACCESS_KEY secret Env: AWS_SESSION_TOKEN secret Env: AWS_DEFAULT_REGION Env: AWS_ENDPOINT |