Ktanaka101 MCP Server Duckdb

🚀 mcp-server-duckdb

An implementation of the Model Context Protocol (MCP) server for DuckDB, enabling database interaction through MCP tools. DuckDB is well - suited for local analysis.

🚀 Quick Start

This server interacts with the DuckDB database through the Model Context Protocol (MCP), supporting operations such as executing queries, creating tables, and viewing table structures.

✨ Features

Resources

Currently, there is no custom resource implementation.

Prompts

Currently, there is no custom prompt implementation.

Tools

The server implements the following database interaction tools:

• read-query: Execute a SELECT query to read data

  • Input: query (string) - Must be a SELECT statement
  • Output: Query result text

• write-query: Execute an INSERT, UPDATE, or DELETE query to modify data

  • Input: query (string) - Must be a non - SELECT statement
  • Output: Query result text

• create-table: Create a new table

  • Input: query (string) - Must be a CREATE TABLE statement
  • Output: Success confirmation message

• list-tables: List all tables in the database

  • Input: None
  • Output: A list of tables obtained from information_schema

• describe-table: Get the schema information of a specific table

  • Input: table_name (string) - The name of the table to describe
  • Output: Table schema information

⚠️ Important Note

When the server runs in read - only mode, the following tools are disabled to prevent any write operations:

• write-query
• create-table

This ensures that the Large Language Model (LLM) cannot perform any database modification operations, thus maintaining data integrity and preventing accidental changes.

🔧 Technical Details

Required Parameters

• db-path (string): The path to the DuckDB database file
  • The server will automatically create the database file and its parent directory if they do not exist.

Optional Parameters

• --readonly: Run the server in read - only mode
  • Description: When this flag is set, the server will run 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 Advantage: It prevents the Large Language Model (LLM) from performing any write operations, ensuring that the database remains unchanged.
  • Note: read_only is the correct term in DuckDB.

📦 Installation

Install using Smithery:

# Example command

Configure in Claude Desktop:

Add the following content to the configuration file:

# Example path settings

📚 Documentation

Prerequisites

• Ensure that the necessary tools and dependencies are installed.

Debugging Tips

Use MCP Inspector for debugging. This tool provides the following features:

• Visualization of request/response communication
• Tracking of tool execution
• Monitoring of server status
• Display of error messages