官方说明10 个来源MCP 服务8 天前
ktanaka101/mcp-server-duckdb
🐍 🏠 - DuckDB database integration with schema inspection and query capabilities
在 GitHub 查看 ↗直链 · 无中转页
配置模板（请按你的客户端调整）
claude mcp add mcp-server-duckdb -- npx -y mcp-server-duckdb
这是根据仓库名生成的可粘贴骨架，命令行参数与包名请以该项目 README 为准。
- ★ 数取值
- 178 ★ · ktanaka101/mcp-server-duckdb · 取自 GitHub 搜索 API · （2026-10-16 20:00:20 核对）
- 来源明细
- 收录自 punkpeye/awesome-mcp-servers 榜单（我们从中收集的条目之一） · 条目类型：MCP 服务
- 收录与活跃
- 收录于 2026-10-09 · 最近见到 2026-10-16 · 共见到 32 次 · 被 10 个来源列出
- 评分构成
- 综合分 1,003 · 178 ★ · 10 个来源 · mcp
常见问题（答案都来自我们的记录）
怎么安装？
我们【没有】从该仓库取到安装命令（我们的 install 覆盖率只有约 4%）。请看它的 README 或 releases 页。
它适合谁 / 用来做什么？
我们把它归在这些标签下: MCP 服务。标签来自条目自身，不是我们强加的分类。
谁维护它、还在更新吗？
仓库
ktanaka101/mcp-server-duckdb；我们收录于 2026-10-09；最近见到 2026-10-16。这里没有"官方认证"或"质量评级"——我们只记录来源与时间。第三方质量标记
mcp-server-duckdb
以下摘录自该仓库的 README（片段） · 在 GitHub 读完整 README →
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.
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:
It would be interesting to have LLM analyze it. DuckDB is suitable for local analysis.
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:
- 来源
- awesome · https://github.com/ktanaka101/mcp-server-duckdb
- 按领域浏览
- MCP 服务
- Traction
- 178 ★
- 收录于
- 昨天
更多MCP 服务
所属领域与标签
每个标签都能点进去看同类的全部条目。数字是当前库里的真实条数。