motherduckdb/mcp-server-motherduck
Local MCP server for DuckDB and MotherDuck
Platform-specific configuration:
{
"mcpServers": {
"mcp-server-motherduck": {
"command": "npx",
"args": [
"-y",
"mcp-server-motherduck"
]
}
}
}Add the config above to .claude/settings.json under the mcpServers key.
<p align="center"> </p>
<h1 align="center">DuckDB / MotherDuck Local MCP Server</h1>
<p align="center"> SQL analytics and data engineering for AI Assistants and IDEs. </p>
---
Connect AI assistants to your data using DuckDB's powerful analytical SQL engine. Supports connecting to local DuckDB files, in-memory databases, S3-hosted databases, and MotherDuck. Allows executing SQL read- and write-queries, browsing database catalogs, and switching between different database connections on-the-fly.
Looking for a fully-managed remote MCP server for MotherDuck? → Go to the MotherDuck Remote MCP docs
| | [Remote MCP](https://motherduck.com/docs/sql-reference/mcp/) | Local MCP (this repo) | |---|---|---| | Hosting | Hosted by MotherDuck | Runs locally/self-hosted | | Setup | Zero-setup | Requires local installation | | Access | Read-write supported | Read-write supported | | Local filesystem | - | Query across local and remote databases, ingest data from / export data to local filesystem |
> 📝 Migrating from v0.x? > - Read-only by default: The server now runs in read-only mode by default. Add --read-write to enable write access. See Securing for Production. > - Default database changed: --db-path default changed from md: to :memory:. Add --db-path md: explicitly for MotherDuck. > - MotherDuck read-only requires read-scaling token: MotherDuck connections in read-only mode require a read-scaling token. Regular tokens require --read-write.
Prerequisites: Install uv via pip install uv or brew install uv
Loading reviews...