Back to MCP Servers
🔌

ktanaka101/mcp-server-duckdb

MIT

🐍 🏠 - DuckDB database integration with schema inspection and query capabilities

PythonDatabases

Install

npx -y -y @smithery/cli

claude_desktop_config.json

claude_desktop_config.json
{
  "mcpServers": {
    "ktanaka101-mcp-server-duckdb": {
      "command": "npx",
      "args": [
        "-y",
        "-y",
        "@smithery/cli"
      ]
    }
  }
}

Add this to your Claude Desktop config file. Find it at ~/Library/Application Support/Claude/claude_desktop_config.json on macOS.

What this does

ktanaka101/mcp-server-duckdb exposes a set of tools to Claude over the Model Context Protocol. After you add it to claude_desktop_config.json (snippet above) and restart Claude Desktop, those tools become callable inside any conversation. That makes it useful when you want Claude to reach into your databases without copy-pasting context every turn.

Common use cases

  • Query structured data without writing SQL by hand
  • Let Claude read table schemas before answering data questions
  • Run read-only operational reports or sanity checks during incidents