# mcp-server-motherduck MCP server

SQL analytics and data engineering for AI Assistants and IDEs

## Links
- Registry page: https://www.getdrio.com/mcp/io-github-motherduckdb-mcp-server-motherduck
- Repository: https://github.com/motherduckdb/mcp-server-motherduck

## Install
- Command: `uvx mcp-server-motherduck`
- Auth: Not captured

## Setup notes
- Package: Pypi mcp-server-motherduck v1.0.6
- Package argument: --transport (default stdio; choices stdio, http, sse, stream)
- Package argument: --port (default 8000)
- Package argument: --host (default 127.0.0.1)
- Package argument: --db-path (default :memory:)
- Package argument: --motherduck-token (secret)
- Package argument: --read-write
- Package argument: --allow-switch-databases
- Package argument: --motherduck-saas-mode
- Package argument: --init-sql
- Package argument: --home-dir
- Package argument: --max-rows (default 1024)
- Package argument: --max-chars (default 50000)
- Package argument: --query-timeout (default -1)
- Package argument: --ephemeral-connections
- Environment variable: motherduck_token (secret)
- Environment variable: MOTHERDUCK_TOKEN (secret)
- Environment variable: HOME
- Environment variable: AWS_ACCESS_KEY_ID (secret)
- Environment variable: AWS_SECRET_ACCESS_KEY (secret)
- Environment variable: AWS_SESSION_TOKEN (secret)
- Environment variable: AWS_DEFAULT_REGION
- Environment variable: AWS_ENDPOINT

## Tools
Not captured

## Resources
Not captured

## Prompts
Not captured

## Metadata
- Owner: io.github.motherduckdb
- Version: 1.0.6
- Runtime: Pypi
- Transports: STDIO
- License: Not captured
- Language: Not captured
- Stars: Not captured
- Updated: Apr 29, 2026
- Source: https://registry.modelcontextprotocol.io