MCP Server Duckdb

@ktanaka101

代码仓库

基本信息

分类

数据库

许可证

MIT

传输方式

stdio

作者

ktanaka101

关于 MCP Server Duckdb

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

#mcp #duckdb #mcp-server

MCP Server Duckdb 配置

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

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

MCP Server Duckdb 工具

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.

常见问题

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 服务器

Fund Momentum MCP Server

schneidavie

Fund Momentum MCP Server — VC intelligence for AI assistants. 1000+ active VC funds, live investor signals, AI-powered startup matching.

MySQL MCP Server

designcomputer

A Model Context Protocol (MCP) server that enables secure interaction with MySQL databases

1.3K

Lawstronaut

Lawstronaut-FZCO

Access millions of official legal and regulatory source documents from 155+ jurisdictions via MCP. Lawstronaut supports AI agents with structured legal research, legal data, laws, regulations, cases, guidance, official s

Postgres Mcp

crystaldba

Postgres MCP Pro provides configurable read/write access and performance analysis for you and your AI agents.

3.0K

golfdata.online - Verified Golf Clubs

golfdata.online

Verified golf club data for AI agents: holes, par, address, phone, booking links, facilities, visitor rules and green fees for golf clubs in Spain (Canary Islands and mainland), expanding across Europe. Every fact comes