广告合作
MCP.so
登录

MCP Server Duckdb

@MCP-Mirror

代码仓库

基本信息

分类

数据库

传输方式

stdio

作者

MCP-Mirror

关于 MCP Server Duckdb

Mirror of

#mcp-server#duckdb#database-interaction

MCP Server Duckdb 配置

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

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

MCP Server Duckdb 工具

5

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

常见问题

1

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.

2

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.

3

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`.

4

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).

5

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

Dbhub

bytebase

Zero-dependency, token-efficient database MCP server for Postgres, MySQL, SQL Server, MariaDB, SQLite.

3.1K

MCP DB Wizard

srmadscience

Oracle MCP server with no run-sql tool: It generates tools for each of the PL/SQL procedures, tables and approved SQL you choose. The server doesn't expose a SQL prompt, and can't reveal how it's connected to Oracle.

1

Sail MCP Server for Spark SQL

lakehq

Drop-in Apache Spark replacement written in Rust, unifying batch processing, stream processing, and compute-intensive AI workloads.

3.1K

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

PostgreSQL

modelcontextprotocol

Model Context Protocol Servers

88.1K
广告合作