mcp-server-duckdb

@MCP-Mirror

About mcp-server-duckdb

Mirror of

#mcp-server #duckdb #database-interaction

Config

Add this server to your MCP-compatible client using the configuration below.

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

Tools

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

Overview

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.

Frequently asked questions

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