MCP server for executing SQL queries on DuckDB and MotherDuck databases. Provides tools for querying, managing, and analyzing data. Connects to DuckDB and MotherDuck databases. Used by developers for data analysis, reporting, and building data-driven applications.
MCP server for executing SQL queries on DuckDB and MotherDuck databases. Provides tools for querying, managing, and analyzing data. Connects to DuckDB and MotherDuck databases. Used by developers for data analysis, reporting, and building data-driven applications.
pip install mcp-server-motherduckAdd this configuration to your claude_desktop_config.json:
{
"mcpServers": {
"motherduckdb-mcp-server-motherduck-github": {
"command": "uvx",
"args": [
"pip install mcp-server-motherduck"
]
}
}
}Restart Claude Desktop, then ask:
"What tools do you have available from motherduck?"
API Key Required
This server requires an API key from motherduck. Add it to your environment or config.
| Variable | Required | Description |
|---|---|---|
| MOTHERDUCK_API_KEY | Yes | Your motherduck API key |
"What resources are available in motherduck?"
Claude will query available resources and return a list of what you can access.
"Show me details about [specific item] in motherduck"
Claude will fetch and display detailed information about the requested item.
"Create a new [item] in motherduck with [details]"
Claude will use the appropriate tool to create the resource and confirm success.
We build custom MCP integrations for B2B companies. From simple connections to complex multi-tool setups.