- Home
- MCP servers
- DuckDB / MotherDuck Local MCP Server
DuckDB / MotherDuck Local MCP Server
Run analytical SQL on local DuckDB files, in-memory data or MotherDuck
What it is
A local server that hands an agent DuckDB's SQL engine. It can open DuckDB files, in-memory databases, databases on S3 or a MotherDuck account, browse catalogs and switch connections mid-session. Handy for ad-hoc analysis of CSV and Parquet files.
Good for
- Analyse CSV or Parquet files with SQL
- Query a local DuckDB database
- Run queries against MotherDuck
Install or run
claude mcp add --scope user duckdb --transport stdio -- uvx mcp-server-motherduck --db-path :memory: --read-write --allow-switch-databasesCommand as given in the project README. Read the repository before you run anything on your machine.
What you need
uv; a MotherDuck token only when connecting to MotherDuck
Sources
- https://github.com/motherduckdb/mcp-server-motherduck (project README, read 10 Nov 2026)
- https://api.github.com/repos/motherduckdb/mcp-server-motherduck (GitHub API, read 13 Nov 2026)
The summary is ours, written from the README. Spotted an error? See how we work.