広告掲載
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.

コメント

「データベース」の他のコンテンツ

Database Gateway

centralmind

Universal MCP-Server for your Databases optimized for LLMs and AI-Agents.

531

PostgreSQL Model Context Protocol (PG-MCP) Server

stuzero

540

Expired Domains MCP | Karma.Domains

karma-domains

Connect Karma.Domains to ChatGPT, Claude, Cursor, VS Code, or another MCP client — and find a domain in plain language. The same auctions, expired, backorder, and buy-now data you use in the app, plus saved filters, note

Schemity

tbson

Local database MCP server: your agent sees a migration's impact before it runs, for PostgreSQL, MySQL, SQL Server and SQLite, with no database credentials.

Elasticsearch MCP Server

elastic

685
広告掲載