mcp-server-duckdb

Name: mcp-server-duckdb
Author: MCP-Mirror

@MCP-Mirror

リポジトリ

mcp-server-duckdb について

Mirror of

#mcp-server #duckdb #database-interaction

基本情報

カテゴリ

データベース

トランスポート

stdio

公開者

MCP-Mirror

設定

以下の設定を使って、このサーバーを MCP 対応クライアントに追加してください。

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

ツール

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

FAQ from mcp-server-duckdb

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.

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.

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.

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

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.

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

Snowflake MCP Server

isaacwasserman

185

MCP Server for MySQL based on NodeJS

benborla

A Model Context Protocol server that provides read-only access to MySQL databases. This server enables LLMs to inspect database schemas and execute read-only queries.

1.9K