mcp-server-motherduck
SQL analytics and data engineering for AI Assistants and IDEs
Install and compare this MCP server
Use this profile to copy client config, check auth requirements, review tools and resources, and compare related MCP servers before adding it to an AI client.
- Install
- uvx mcp-server-motherduck
- Clients
- Claude, Cursor, VS Code, Codex
- Transport
- STDIO
- Auth
- Not captured
- Capabilities
- 0 tools, 0 resources, 0 prompts
- Related
- onsense, Bowmark, nable
Want MCP integration examples?
Get practical integration notes and launch examples for MCP servers like mcp-server-motherduck.
Install
Connection
- Transport
- STDIO
- Command
uvx mcp-server-motherduck- Environment
{ "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" }
Claude Desktop
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"
}
}
}
}Config location
- macOS
~/Library/Application Support/Claude/claude_desktop_config.json- Windows
%APPDATA%\Claude\claude_desktop_config.json
Auth
Package transportNo remote HTTP endpoint is advertised. Use the package or stdio setup shown in Install.
Tools & Resources
No public tools, resources, or prompts captured yet. Use Auth when this server requires credentials.
Tools
No tools captured yet.
Resources
No resources captured yet.
Prompts
No prompts captured yet.
Questions
What is mcp-server-motherduck?+
mcp-server-motherduck is an MCP server for SQL analytics and data engineering for AI Assistants and IDEs. It supports STDIO transport.
How do I install mcp-server-motherduck?+
Use the generated config in Install. This server runs with uvx mcp-server-motherduck; add any required environment variables before starting your client.
How do I add mcp-server-motherduck to Claude Desktop?+
Choose the Claude Desktop tab in Install and copy the config for uvx mcp-server-motherduck. Add required environment variables before starting Claude Desktop.
How do I add mcp-server-motherduck to Claude Code?+
Choose the Claude Code tab in Install and copy the config for uvx mcp-server-motherduck. Add required environment variables before starting Claude Code.
How do I use mcp-server-motherduck with Codex?+
Choose the Codex tab in Install and copy the config for uvx mcp-server-motherduck. Add required environment variables before starting Codex.
How do I add mcp-server-motherduck to Cursor or VS Code?+
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.
What endpoint and transport does mcp-server-motherduck use?+
mcp-server-motherduck uses STDIO transport. Use the package or command config in Install.
What tools and resources does mcp-server-motherduck expose?+
mcp-server-motherduck inventory is listed when the MCP endpoint exposes tools, resources, or prompts. Some servers require auth first.
Does mcp-server-motherduck require authentication?+
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.
Related MCPs
onsenseAndroid phone camera, sensors & files for any MCP client — local, no cloud, no ADB.BowmarkDo things on live websites: prices, availability, quotes, bookings, anything behind a form or login.nableSee where your cloud and AI bills go, and spend less. Local-first, in your terminal or editor.HPSILab Quant FinanceQuant finance tools: stock analysis, options IV, Monte Carlo, AI prediction, risk scan, backtests.DataCharterLocal-first, contract-governed data explorer with read-only, PII-masked query tools for AI agents.InferraAuditable rule-based decisions with RAG explanations: a Rete engine decides, an LLM explains why.
Profile notes
- Package: Pypi mcp-server-motherduck v1.0.7
- Package argument: --transport (default stdio; choices stdio, http, sse, stream)
- Package argument: --port (default 8000)
- Package argument: --host (default 127.0.0.1)
- Package argument: --db-path (default :memory:)
- Package argument: --motherduck-token (secret)
- Package argument: --read-write
- Package argument: --allow-switch-databases
- Package argument: --motherduck-saas-mode
- Package argument: --init-sql
- Package argument: --home-dir
- Package argument: --max-rows (default 1024)
- Package argument: --max-chars (default 50000)
- Package argument: --query-timeout (default -1)
- Package argument: --ephemeral-connections
- Environment variable: motherduck_token (secret)
- Environment variable: MOTHERDUCK_TOKEN (secret)
- Environment variable: HOME
- Environment variable: AWS_ACCESS_KEY_ID (secret)
- Environment variable: AWS_SECRET_ACCESS_KEY (secret)
- Environment variable: AWS_SESSION_TOKEN (secret)
- Environment variable: AWS_DEFAULT_REGION
- Environment variable: AWS_ENDPOINT
Packages
| Package | Registry | Version | Inputs |
|---|---|---|---|
mcp-server-motherduckstdio | pypi | 1.0.7 | 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 |
Details
- Version
- 1.0.7
- Updated
- Jun 9, 2026