mcp-server-duckdb
by ktanaka101
Server Configuration
Describes the environment variables required to run the server.
| Name | Required | Description | Default |
|---|---|---|---|
| db-path | Yes | Path to the DuckDB database file. The server will automatically create the database file and parent directories if they don't exist. |
Schema
Prompts
Interactive templates invoked by user choice
| Name | Description |
|---|---|
No prompts | |
Resources
Contextual data attached and managed by the client
| Name | Description |
|---|---|
No resources | |
Tools
Functions exposed to the LLM to take actions
| Name | Description |
|---|---|
| read-query | Execute a SELECT query on the DuckDB database |
| list-tables | List all tables in the DuckDB database |
| describe-table | Get the schema information for a specific table |
| write-query | Execute an INSERT, UPDATE, or DELETE query on the DuckDB database |
| create-table | Create a new table in the DuckDB database |