drio
Open app

mcp-server-duckdb

Source

A Model Context Protocol (MCP) server implementation for DuckDB, providing database interaction capabilities

Catalog onlyCatalog onlySTDIO

Overview

The mcp-server-duckdb is a Model Context Protocol (MCP) server implementation for DuckDB, designed to enable seamless database interaction through MCP tools. It supports various database operations, such as querying, creating tables, and inspecting schemas.

To use the server, set it up by configuring the database path, and request operations using the selected MCP tools. It can run in read-only mode to enhance security.

  • Support for executing SELECT, INSERT, UPDATE, and DELETE queries. - Ability to create new database tables and inspect table schemas. - Option to run in read-only mode to prevent data modifications.
  1. Efficient data analysis and manipulation via DuckDB.
  2. Safeguarding data integrity in read-only environments.
  3. Integration with other tools and workflows utilizing MCP.

Add to your AI client

Use these steps to connect mcp-server-duckdb in Cursor, Claude, VS Code, and other MCP-compatible apps. The same JSON appears in the Use with menu above for one-click copy.

Cursor

Add this to your .cursor/mcp.json file in your project root, then restart Cursor.

.cursor/mcp.json

{
  "mcpServers": {
    "mcp-server-duckdb-ktanaka101": {
      "command": "npx",
      "args": [
        "-y",
        "@modelcontextprotocol/server-mcp-server-duckdb-ktanaka101"
      ]
    }
  }
}

Claude Desktop

Add this server entry to the mcpServers object in your Claude Desktop config, then restart the app.

~/Library/Application Support/Claude/claude_desktop_config.json (macOS) or %APPDATA%\Claude\claude_desktop_config.json (Windows)

{
  "mcpServers": {
    "mcp-server-duckdb-ktanaka101": {
      "command": "npx",
      "args": [
        "-y",
        "@modelcontextprotocol/server-mcp-server-duckdb-ktanaka101"
      ]
    }
  }
}

Claude Code

Add this to your project's .mcp.json file. Claude Code will detect it automatically.

.mcp.json (project root)

{
  "mcpServers": {
    "mcp-server-duckdb-ktanaka101": {
      "command": "npx",
      "args": [
        "-y",
        "@modelcontextprotocol/server-mcp-server-duckdb-ktanaka101"
      ]
    }
  }
}

VS Code (Copilot)

Add this to your .vscode/mcp.json file. Requires the GitHub Copilot extension with MCP support enabled.

.vscode/mcp.json

{
  "servers": {
    "mcp-server-duckdb-ktanaka101": {
      "type": "stdio",
      "command": "npx",
      "args": [
        "-y",
        "@modelcontextprotocol/server-mcp-server-duckdb-ktanaka101"
      ]
    }
  }
}

Windsurf

Add this to your Windsurf MCP config file, then restart Windsurf.

~/.codeium/windsurf/mcp_config.json

{
  "mcpServers": {
    "mcp-server-duckdb-ktanaka101": {
      "command": "npx",
      "args": [
        "-y",
        "@modelcontextprotocol/server-mcp-server-duckdb-ktanaka101"
      ]
    }
  }
}

Cline

Open Cline settings, navigate to MCP Servers, and add this server configuration.

Cline MCP Settings (via UI)

{
  "mcpServers": {
    "mcp-server-duckdb-ktanaka101": {
      "command": "npx",
      "args": [
        "-y",
        "@modelcontextprotocol/server-mcp-server-duckdb-ktanaka101"
      ]
    }
  }
}

FAQ

What is DuckDB used for?

DuckDB is an in-process SQL OLAP database management system that supports high-performance analytics.

Is this server suitable for real-time analytics?

Yes, the server facilitates real-time querying capabilities typical of DuckDB.

How can I run the server?

You can run the server by configuring the command in the appropriate configuration files of supported platforms.

Database