mcp-server-duckdb
About
mcp-server-duckdb is a Model Context Protocol (MCP) server that enables database interaction with DuckDB through MCP tools. It is designed for local analysis and allows LLMs to perform operations like querying, table creation, and schema inspection.
Details
- Author
- MCP-Mirror
- Downloads
- 595
- Categories
- Database
Jump to
- Read and write SQL queries (SELECT, INSERT, UPDATE, DELETE)
- Create tables with CREATE TABLE statements
- List all tables in the database
- Describe table schemas via information_schema
- Optional read‑only mode to prevent modifications
- Automatic creation of database file and parent directories
Setting up with Highlight
This MCP is not yet compatible with Highlight’s one-click setup. However, you can still use it with Highlight by following these steps:
- Download and install Highlight from highlightai.com/download
- Navigate to the plugins tab and select "Add Custom Plugin"
-
Configure the plugin with the settings below
Plugin Name
mcp-server-duckdbCommand (node, npx, python, etc.)Please refer to the README for specific instructions on how to obtain API keys or other required environment variables.
- Enable "Start Automatically" if you want the plugin to start when Highlight launches
From the repository
Install via Smithery (npx -y @smithery/cli install mcp-server-duckdb --client claude) or configure manually in the Claude Desktop configuration file. The required parameter is db-path (path to the DuckDB database file). Optionally set --readonly for read-only mode.
Claude Desktop / Cursor
Paste into your MCP client config file to install this server.
{
"mcpServers": {
"mcp-server-duckdb": {
"ktanaka101_mcp-server-duckdb": {
"command": "npx",
"args": [
"-y",
"@smithery/cli",
"install",
"mcp-server-duckdb",
"--client",
"claude"
]
}
}
}
}McpServers
{
"ktanaka101_mcp-server-duckdb": {
"command": "npx",
"args": [
"-y",
"@smithery/cli",
"install",
"mcp-server-duckdb",
"--client",
"claude"
]
}
}mcp-server-duckdb
A Model Context Protocol (MCP) server implementation for DuckDB, providing database interaction capabilities through MCP tools.
It would be interesting to have LLM analyze it. DuckDB is suitable for local analysis.
<a href="https://glama.ai/mcp/servers/fwggl49w22"></a>
Overview
This server enables interaction with a DuckDB database through the Model Context Protocol, allowing for database operations like querying, table creation, and schema inspection.
Components
Resources
Currently, no custom resources are implemented.
Prompts
Currently, no custom prompts are implemented.
Tools
The server implements the following database interaction tools:
- read-query: Execute SELECT queries to read data from the database
- Input: query (string) - Must be a SELECT statement
- Output: Query results as text
- write-query: Execute INSERT, UPDATE, or DELETE queries to modify data
- Input: query (string) - Must be a non-SELECT statement
- Output: Query results as text
- create-table: Create new tables in the database
- Input: query (string) - Must be a CREATE TABLE statement
- Output: Success confirmation message
- list-tables: List all tables in the database
- Input: None required
- Output: List of tables from information_schema
- describe-table: Get schema information for a specific table
- Input: table_name (string) - Name of the table to describe
- Output: Table schema information
Note: When the server is running in readonly mode, the following tools are disabled to prevent any write operations:
- write-query
- create-table
This ensures that the Language Model (LLM) cannot perform any modifications to the database, maintaining data integrity and preventing unintended changes.
Configuration
Required Parameters
- db-path (string): Path to the DuckDB database file
- The server will automatically create the database file and parent directories if they don't exist
Optional Parameters
- --readonly: Run server in read-only mode
- Description: When this flag is set, the server operates in read-only mode. This means:
- The DuckDB database will be opened with read_only=True, preventing any write operations.
- If the specified database file does not exist, it will not be created.
- Security Benefit: Prevents the Language Model (LLM) from performing any write operations, ensuring that the database remains unaltered.
- Reference: For more details on read-only connections in DuckDB, see the DuckDB Python API documentation.
Installation
Installing via Smithery
To install DuckDB Server for Claude Desktop automatically via Smithery:
npx -y @smithery/cli install mcp-server-duckdb --client claude
Claude Desktop Integration
Configure the MCP server in Claude Desktop's configuration file:
MacOS
Location:~/Library/Application Support/Claude/claude_desktop_config.json
Windows
Location:%APPDATA%/Claude/claude_desktop_config.json
{
"mcpServers": {
"duckdb": {
"command": "uvx",
"args": [
"mcp-server-duckdb",
"--db-path",
"~/mcp-server-duckdb/data/data.db"
]
}
}
}
- Note:
~/mcp-server-duckdb/data/data.dbshould be replaced with the actual path to the DuckDB database file.
Development
Prerequisites
- Python with uv package manager
- DuckDB Python package
- MCP server dependencies
Debugging
Debugging MCP servers can be challenging due to their stdio-based communication. We recommend using the MCP Inspector for the best debugging experience.
Using MCP Inspector
1. Install the inspector using npm:
npx @modelcontextprotocol/inspector uv --directory ~/mcp-server-duckdb run mcp-server-duckdb
2. Open the provided URL in your browser to access the debugging interface
The inspector provides visibility into:
- Request/response communication
- Tool execution
- Server state
- Error messages
Sign in to leave a review
Use Google, GitHub, or an email account so ratings stay tied to real people.
No reviews posted yet.
