mcp-server-duckdb

Name: mcp-server-duckdb
Author: ktanaka101

@ktanaka101

代码仓库

关于 mcp-server-duckdb

A Model Context Protocol (MCP) server implementation for DuckDB, providing database interaction capabilities

#mcp #duckdb #mcp-server

基本信息

分类

数据库

许可证

MIT

运行时

python

传输方式

stdio

发布者

ktanaka101

配置

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

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

工具

Execute any SQL query on the DuckDB database

概览

What is mcp-server-duckdb?

A Model Context Protocol (MCP) server that enables interaction with a DuckDB database through MCP tools, allowing LLMs to execute SQL queries, manage tables, and inspect schemas. It is designed for local data analysis.

How to use mcp-server-duckdb?

Install via Smithery or configure in Claude Desktop’s JSON file using uvx mcp-server-duckdb --db-path <path>. Optionally add --readonly or --keep-connection flags. The server accepts a single required parameter db-path and two optional flags.

Key features of mcp-server-duckdb

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.

Use cases of mcp-server-duckdb

LLM‑powered exploratory analysis on local DuckDB files.
Automated table creation, schema inspection, and data insertion.
Read‑only query access for security‑sensitive environments.
Seamless integration with AI assistants for database operations.

FAQ from mcp-server-duckdb

How does read‑only mode differ from read‑write?

In read‑only mode the DuckDB database is opened with read_only=True, preventing any write operations (CREATE, INSERT, UPDATE, DELETE) and refusing to create missing database files. Read‑write mode allows full SQL and auto‑creates missing files.

What are the runtime requirements?

Python with the uv package manager, the DuckDB Python package, and MCP server dependencies.

Where is the database file stored?

The path is specified by the user via the --db-path argument. The server creates the file and any needed parent directories unless --readonly is used and the file does not exist.

Does the server offer separate tools for different operations?

No, it provides a single unified query tool. The LLM generates appropriate SQL for any operation (SELECT, CREATE, INSERT, etc.) without requiring separate endpoints.

What transport does the server use?

It uses stdio-based communication, typical of MCP servers. Debugging is recommended with the MCP Inspector, which can be launched via npx @modelcontextprotocol/inspector.

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

Chroma MCP Server

chroma-core

A Model Context Protocol (MCP) server implementation that provides database capabilities for Chroma

569

mcp_mysql_server

wenb1n-dev

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

245