mcp-server-duckdb

Overview

mcp-server-duckdb is a Python-based implementation that provides database interaction capabilities through the Model Context Protocol. It enables users to execute any valid DuckDB SQL query via a unified query function, offering flexibility for various database operations including SELECT, CREATE TABLE, JOIN, and more. The server supports both read-only and write modes, with configurable parameters for database path and connection handling. While it lacks custom resources and prompts currently, it provides core database functionality suitable for local data analysis with LLM integration.

Try asking AI

After installing, here are 5 things you can ask your AI assistant:

• queryquery: string

  Execute any SQL query on the DuckDB database

  Try:What are the top 10 customers by revenue?Try:Create a new table with sales dataTry:Show me all products in the inventory

Comparable tools

Installation

npx -y @smithery/cli install mcp-server-duckdb --client claude

{
  "mcpServers": {
    "duckdb": {
      "command": "uvx",
      "args": [
        "mcp-server-duckdb",
        "--db-path",
        "~/mcp-server-duckdb/data/data.db"
      ]
    }
  }
}

FAQ

Can I use this server with other LLM clients besides Claude?

Yes, the MCP protocol is client-agnostic. While the example shows Claude Desktop integration, it should work with any MCP-compliant client.

How do I enable write operations on the database?

By default, write operations are allowed. To disable them, use the `--readonly` flag when starting the server.

Compare mcp-server-duckdb with