mcp-server-duckdb

Name: mcp-server-duckdb
Author: MCP-Mirror

@MCP-Mirror

代码仓库

关于 mcp-server-duckdb

Mirror of

#mcp-server #duckdb #database-interaction

基本信息

分类

数据库

传输方式

stdio

发布者

MCP-Mirror

配置

使用下面的配置,将此服务器添加到你的 MCP 客户端。

{
  "mcpServers": {
    "ktanaka101_mcp-server-duckdb": {
      "command": "npx",
      "args": [
        "-y",
        "@smithery/cli",
        "install",
        "mcp-server-duckdb",
        "--client",
        "claude"
      ]
    }
  }
}

工具

Execute SELECT queries to read data from the database

Execute INSERT, UPDATE, or DELETE queries to modify data

Create new tables in the database

List all tables in the database

Get schema information for a specific table

概览

What is mcp-server-duckdb?

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.

How to use mcp-server-duckdb?

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.

Key features of mcp-server-duckdb

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

Use cases of mcp-server-duckdb

Let an LLM analyze a local DuckDB database
Inspect table schemas and list tables without manual SQL
Safely query and modify data through natural language interfaces
Run read‑only analyses on sensitive data while preventing writes

FAQ from mcp-server-duckdb

What tools does mcp-server-duckdb provide?

It provides five tools: read-query, write-query, create-table, list-tables, and describe-table. Write-query and create-table are disabled in read‑only mode.

How do I run mcp-server-duckdb in read‑only mode?

Add the --readonly flag when starting the server. This opens the DuckDB database with read_only=True and prevents the LLM from performing any write operations.

What are the installation and runtime dependencies?

Python with the uv package manager, DuckDB Python package, and MCP server dependencies. Installation can be done via Smithery or manual configuration with uvx.

Where is the DuckDB database file stored?

The database path is specified by the db-path parameter in the configuration. The server automatically creates the file and parent directories if they don’t exist (unless in read‑only mode, where it does not create missing files).

What transport does mcp-server-duckdb use?

The server uses stdio-based communication, as typical for MCP servers. Debugging is supported via the MCP Inspector tool.

数据库分类下的更多 MCP 服务器

mcp_mysql_server

xwb602625136

Model Context Protocol (MCP) server that supports secure interaction with MySQL databases and has anomaly analysis capabilities.更加牛逼！更加好用！不仅止于mysql的增删改查功能；还包含了数据库异常分析能力；且便于开发者们进行个性化的工具扩展

245