mcp-server-motherduck

SQL analytics and data engineering for AI Assistants and IDEs

stdioofficialapplication

Package Details

mcp-server-motherduck

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

Transportstdio

Package Arguments

Named

--transport

Transport type for MCP server. Use 'http' for HTTP Streamable transport.

--port

Port to listen on for HTTP transport

--host

Host to bind the MCP server

--db-path

Database path: ':memory:' for in-memory, 'md:' for MotherDuck, or file/S3 path

--motherduck-token

Access token for MotherDuck connections

--read-write

Enable write access (server runs in read-only mode by default)

--allow-switch-databases

Enable the switch_database_connection tool to change databases at runtime

--motherduck-saas-mode

Enable SaaS mode for MotherDuck (disables local filesystem access)

--init-sql

SQL file path or SQL string to execute on startup

--home-dir

Home directory for DuckDB

--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 (-1 to disable)

--ephemeral-connections

Use temporary connections for read-only local DuckDB files (default: true)

Environment Variables

motherduck_token

Secret

Access token for MotherDuck connections (alternative to --motherduck-token)

MOTHERDUCK_TOKEN

Secret

Access token for MotherDuck connections (alternative to --motherduck-token)

HOME

Used by DuckDB for extensions and config. Override with --home-dir if not set.

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

AWS_DEFAULT_REGION

AWS region for S3 database connections