io.github.motherduckdb

mcp-server-motherduck

Fast analytics and data processing with DuckDB and MotherDuck

self-hostedofficialapplication

Package Details

Transportstdio

Arguments

Package Arguments
--transportTransport type for MCP server
--portPort to listen on for sse and stream transport mode
--db-pathPath to local DuckDB database file or MotherDuck database
--motherduck-tokenAccess token to use for MotherDuck database connections
--read-onlyFlag for connecting to DuckDB or MotherDuck in read-only mode
--home-dirHome directory for DuckDB
--saas-modeFlag for connecting to MotherDuck in SaaS mode (disables filesystem and write permissions for local DuckDB)
--json-responseEnable JSON responses for HTTP stream (only supported for stream transport)

Environment Variables

motherduck_token
Secret

Access token to use for MotherDuck database connections

HOME

Home directory for DuckDB (used as default if --home-dir not specified)