MotherDuck MCP: Documentation
Updated:
Connection
uvx mcp-server-motherduck --db-path :memory: for a local in-memory database or file (no auth needed); --db-path md:<database> with a motherduck_token env var for a MotherDuck cloud database. The --read-write flag allows writes (read-only by default). Requires Python and uv.
Tools
4 tools: execute_query — run SQL in DuckDB dialect; list_databases — list connected databases (local and MotherDuck); list_tables — tables and views, filterable by database/schema; switch_database_connection — switch to another database without restarting (requires the --allow-switch-databases flag).
Agent flow
"Analyze this local Parquet file", "switch to the sales_prod cloud database and show its tables", "calculate month-over-month sales in a single SQL query".
Important
The server is built and maintained by MotherDuck, which also runs the eponymous cloud service — hence it's marked as a community integration here, not as an official project of the DuckDB engine itself, which has no single vendor.
Pricing
The MCP server is free, open source. Local DuckDB is always free; MotherDuck is freemium, with a free starter tier and paid plans based on data volume and compute.