mcp-server-motherduck

Fast analytics and data processing with DuckDB and MotherDuck

stdioofficialservice

Package Details

mcp-server-motherduck

0.8.0•https://pypi.org/project/mcp-server-motherduck

Transportstdio

Package Arguments

Named

--transport

Transport type for MCP server

--port

Port to listen on for sse and stream transport mode

--host

Host to bind the MCP server for sse and stream transport mode

--db-path

Path to local DuckDB database file or MotherDuck database

--motherduck-token

Access token to use for MotherDuck database connections

--read-only

Flag for connecting to DuckDB or MotherDuck in read-only mode

--home-dir

Home directory for DuckDB

--saas-mode

Flag for connecting to MotherDuck in SaaS mode (disables filesystem and write permissions for local DuckDB)

--json-response

Enable JSON responses for HTTP stream (only supported for stream transport)

--max-rows

Maximum number of rows to return from queries

--max-chars

Maximum number of characters in query results

--query-timeout

Query execution timeout in seconds. Set to -1 to disable timeout

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)

AWS_ACCESS_KEY_ID

Secret

AWS access key for S3 database connections

AWS_SECRET_ACCESS_KEY

Secret

AWS secret access key for S3 database connections

AWS_SESSION_TOKEN

Secret

AWS session token for temporary credentials (IAM roles, AWS SSO, EC2 instance profiles)

AWS_DEFAULT_REGION

AWS region for S3 database connections