mcp-server-motherduck

# MotherDuck's DuckDB MCP Server An MCP server implementation that interacts with DuckDB and MotherDuck databases, providing SQL analytics capabilities to AI Assistants and IDEs. [<img src="https://cursor.com/deeplink/mcp-install-dark.svg" alt="Install in Cursor">](https://cursor.com/en/install-mcp?name=DuckDB&config=eyJjb21tYW5kIjoidXZ4IG1jcC1zZXJ2ZXItbW90aGVyZHVjayAtLWRiLXBhdGggOm1lbW9yeToiLCJlbnYiOnsibW90aGVyZHVja190b2tlbiI6IiJ9fQ%3D%3D) ## Resources - [Close the Loop: Faster Data Pipelines with MCP, DuckDB & AI (Blogpost)](https://motherduck.com/blog/faster-data-pipelines-with-mcp-duckdb-ai/) - [Faster Data Pipelines development with MCP and DuckDB (YouTube)](https://www.youtube.com/watch?v=yG1mv8ZRxcU) ## Features - **Hybrid execution**: query data from local DuckDB or/and cloud-based MotherDuck databases - **Cloud storage integration**: access data stored in Amazon S3 or other cloud storage thanks to MotherDuck's integrations - **Data sharing**: create and share databases - **SQL analytics**: use DuckDB's SQL dialect to query any size of data directly from your AI Assistant or IDE - **Serverless architecture**: run analytics without needing to configure instances or clusters ## Components ### Prompts The server provides one prompt: - `duckdb-motherduck-initial-prompt`: A prompt to initialize a connection to DuckDB or MotherDuck and start working with it ### Tools The server offers one tool: - `query`: Execute a SQL query on the DuckDB or MotherDuck database - **Inputs**: - `query` (string, required): The SQL query to execute All interactions with both DuckDB and MotherDuck are done through writing SQL queries. **Result Limiting**: Query results are automatically limited to prevent using up too much context: - Maximum 1024 rows by default (configurable with `--max-rows`) - Maximum 50,000 characters by default (configurable with `--max-chars`) - Truncated responses include a note about truncation ## Command Line Parameters The MCP server supports the following parameters: | Parameter | Type | Default | Description | |-----------|------|---------|----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------| | `--transport` | Choice | `stdio` | Transport type. Options: `stdio`, `sse`, `stream` | | `--port` | Integer | `8000` | Port to listen on for sse and stream transport mode | | `--host` | String | `127.0.0.1` | Host to bind the MCP server for sse and stream transport mode | | `--db-path` | String | `md:` | Path to local DuckDB database file, MotherDuck database, or S3 URL (e.g., `s3://bucket/path/to/db.duckdb`) | | `--motherduck-token` | String | `None` | Access token to use for MotherDuck database connections (uses `motherduck_token` env var by default) | | `--read-only` | Flag | `False` | Flag for connecting to DuckDB or MotherDuck in read-only mode. For DuckDB it uses short-lived connections to enable concurrent access | | `--home-dir` | String | `None` | Home directory for DuckDB (uses `HOME` env var by default) | | `--saas-mode` | Flag | `False` | Flag for connecting to MotherDuck in [SaaS mode](https://motherduck.com/docs/key-tasks/authenticating-and-connecting-to-motherduck/authenticating-to-motherduck/#authentication-using-saas-mode). (disables filesystem and write permissions for local DuckDB) | | `--json-response` | Flag | `False` | Enable JS