DuckDB
About
Execute SQL queries and analyze data in DuckDB databases.
Details
- Author
- ktanaka101
- Repository
- ktanaka101/mcp-server-duckdb
- GitHub stars
- 128
- Downloads
- 16,187
- License
- MIT License
- Categories
- AI, Design, Developer Tools, File Management, Security, Infrastructure, Database
Jump to
- Execute any SQL query via a single unified query tool.
- Optional read‑only mode using DuckDB’s native protection.
- Optional persistent connection for TEMP objects and faster queries.
- Auto‑creates database file and parent directories (unless readonly).
- Integrates with MCP for LLM‑driven database interaction.
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
DuckDBCommand (node, npx, python, etc.)uvxArguments-
Argument 1
mcp-server-duckdb -
Argument 2
--db-path -
Argument 3
~/mcp-server-duckdb/data/data.db
Please refer to the README for specific instructions on how to obtain API keys or other required environment variables.
-
Argument 1
- Enable "Start Automatically" if you want the plugin to start when Highlight launches
From the repository
To install DuckDB Server for Claude Desktop automatically via Smithery:
npx -y @smithery/cli install mcp-server-duckdb --client claude
query
Execute any SQL query on the DuckDB database. Input: query (string) - Any valid DuckDB SQL statement. Output: Query results as text (or success message for operations like CREATE/INSERT).
The server implements the following database interaction tool:
- query: Execute any SQL query on the DuckDB database
- Input: query (string) - Any valid DuckDB SQL statement
- Output: Query results as text (or success message for operations like CREATE/INSERT)
> [!NOTE]
> The server provides a single unified query function rather than separate specialized functions, as modern LLMs can generate appropriate SQL for any database operation (SELECT, CREATE TABLE, JOIN, etc.) without requiring separate endpoints.
> [!NOTE]
> When the server is running in readonly mode, DuckDB's native readonly protection is enforced.
> This ensures that the Language Model (LLM) cannot perform any write operations (CREATE, INSERT, UPDATE, DELETE), maintaining data integrity and preventing unintended changes.
Claude Desktop / Cursor
Paste into your MCP client config file to install this server.
{
"mcpServers": {
"duckdb": {
"command": "uvx",
"args": [
"mcp-server-duckdb",
"--db-path",
"~/mcp-server-duckdb/data/data.db"
],
"env": {},
"cwd": "optional"
}
}
}Macos
{
"command": "uvx",
"args": [
"mcp-server-duckdb",
"--db-path",
"~/mcp-server-duckdb/data/data.db"
],
"env": [],
"cwd": "optional"
}Windows
{
"command": "uvx",
"args": [
"mcp-server-duckdb",
"--db-path",
"~/mcp-server-duckdb/data/data.db"
],
"env": [],
"cwd": "optional"
}Linux
{
"command": "uvx",
"args": [
"mcp-server-duckdb",
"--db-path",
"~/mcp-server-duckdb/data/data.db"
],
"env": [],
"cwd": "optional"
}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 tool:
- query: Execute any SQL query on the DuckDB database
- Input: query (string) - Any valid DuckDB SQL statement
- Output: Query results as text (or success message for operations like CREATE/INSERT)
> [!NOTE]
> The server provides a single unified query function rather than separate specialized functions, as modern LLMs can generate appropriate SQL for any database operation (SELECT, CREATE TABLE, JOIN, etc.) without requiring separate endpoints.
> [!NOTE]
> When the server is running in readonly mode, DuckDB's native readonly protection is enforced.
> This ensures that the Language Model (LLM) cannot perform any write operations (CREATE, INSERT, UPDATE, DELETE), 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
- If --readonly is specified and the database file doesn't exist, the server will fail to start with an error
Optional Parameters
- --readonly: Run server in read-only mode (default: false)
- 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.
- --keep-connection: Re-uses a single DuckDB connection mode (default: false)
- Description: When this flag is set, Re-uses a single DuckDB connection for the entire server lifetime. Enables TEMP objects & slightly faster queries, but can hold an exclusive lock on the file.
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
Sign in to leave a review
Use Google, GitHub, or an email account so ratings stay tied to real people.
No reviews posted yet.
