LOCAL ANALYTICS / MotherDuck
DuckDB / MotherDuck Local MCP
Runs analytical SQL against a chosen DuckDB file or MotherDuck connection from a local MCP process.
“Supports connecting to local DuckDB files, in-memory databases, S3-hosted databases, and MotherDuck.”
01 / THE REASONING
Why this made the selection.
- Documents file, in-memory and MotherDuck modes separately, including their different write behavior.
- The local-file mode can use temporary connections to avoid holding the database file lock.
02 / THE REVIEW RECORD
What we actually inspected.
Source review has boundaries.
A clear record is more useful than a “safe” badge.
Material inspected
- README.md (installation, capability and permission sections)
- pyproject.toml
- src/mcp_server_motherduck/server.py
- src/mcp_server_motherduck/__init__.py
- LICENSE
Our findings
- The CLI converts --read-write into the read_only argument and rejects read-only in-memory startup.
- The CLI’s http transport is Streamable HTTP; old stream/sse aliases are converted to HTTP.
Not established by this review
- Server startup, authentication and tool execution were not tested.
The review applies to the material and revision named here. A newer upstream release can change its behavior.
03 / PUT IT TO WORK
Connect a server deliberately.
- Use the documented uvx client configuration with an absolute path to an existing DuckDB file.
- For MotherDuck, choose the appropriate token type and configure its connection separately; review the production-hardening guidance.
Before you start
- uv/Python and a DuckDB file, or a MotherDuck account with an appropriate token.
04 / FOLLOW THE EVIDENCE
The source trail.
Our notes are separate from the original resource.
Check upstream before adopting a new version.
- Official documentation ↗Checked
https://github.com/motherduckdb/mcp-server-motherduck/blob/275d2e7d2ba4f5b48ce8ad3f01a9aeea8bd08616/README.md
Supports: summary, whySelected, bestFor, limitations, install, access, compatibility, transports
- Applicable source licence ↗Checked
https://github.com/motherduckdb/mcp-server-motherduck/blob/275d2e7d2ba4f5b48ce8ad3f01a9aeea8bd08616/LICENSE
Supports: license
https://github.com/motherduckdb/mcp-server-motherduck/blob/275d2e7d2ba4f5b48ce8ad3f01a9aeea8bd08616/pyproject.toml
Supports: language, review
https://github.com/motherduckdb/mcp-server-motherduck/blob/275d2e7d2ba4f5b48ce8ad3f01a9aeea8bd08616/src/mcp_server_motherduck/server.py
Supports: language, review
https://github.com/motherduckdb/mcp-server-motherduck/blob/275d2e7d2ba4f5b48ce8ad3f01a9aeea8bd08616/src/mcp_server_motherduck/__init__.py
Supports: language, review