Official MotherDuck MCP server for DuckDB and MotherDuck. Connects to in-memory, local file, S3 or MotherDuck (md:) databases and runs DuckDB SQL, with optional read-write and database switching.
Also available as
Connect
- 1Add the server to Codex
codex mcp add motherduck-duckdb --env motherduck_token=YOUR_motherduck_token -- uvx mcp-server-motherduck --db-path :memory: --read-write --allow-switch-databases
Configs are generated from the publisher's documented endpoint. Check their docs for plan requirements and scopes. New to this? Read the step-by-step tutorial.
Tools 5
execute_querylist_databaseslist_tableslist_columnsswitch_database_connectionThings to ask
- “Query this Parquet file on S3 and summarize it”
- “List tables in my MotherDuck database”
- “Show the columns of the sales table”
- “Create a table from this CSV”