mcp-server-motherduck
Official
by motherduckdb
Server Configuration
Describes the environment variables required to run the server.
| Name | Required | Description | Default |
|---|---|---|---|
| HOME | Yes | The home directory path needed by DuckDB | |
| motherduck_token | No | Your MotherDuck access token |
Schema
Prompts
Interactive templates invoked by user choice
| Name | Description |
|---|---|
| duckdb-motherduck-initial-prompt | A prompt to initialize a connection to duckdb or motherduck and start working with it |
Resources
Contextual data attached and managed by the client
| Name | Description |
|---|---|
No resources | |
Tools
Functions exposed to the LLM to take actions
| Name | Description |
|---|---|
| initialize-connection | Create a connection to either a local DuckDB or MotherDuck and retrieve available databases |
| read-schemas | Get table schemas from a specific DuckDB/MotherDuck database |
| execute-query | Execute a query on the MotherDuck (DuckDB) database |