{"type":"mcp_server","name":"mcp-server-duckdb","description":"This repository provides a Model Context Protocol (MCP) server for DuckDB, enabling database interaction through a unified SQL query tool. It supports querying, table creation, and schema inspection while offering readonly protection.","category":"Database","language":"Python","stars":177,"forks":5,"owner":"ktanaka101","github_url":"https://github.com/ktanaka101/mcp-server-duckdb","homepage":null,"setup":"## Setup\n\n### Installing via Smithery\n\nTo install DuckDB Server for Claude Desktop automatically via [Smithery](https://smithery.ai/server/mcp-server-duckdb):\n\n```bash\nnpx -y @smithery/cli install mcp-server-duckdb --client claude\n```\n\n### Claude Desktop Integration\n\nConfigure the MCP server in Claude Desktop's configuration file:\n\n#### MacOS\nLocation: `~/Library/Application Support/Claude/claude_desktop_config.json`\n\n#### Windows\nLocation: `%APPDATA%/Claude/claude_desktop_config.json`\n\n```json\n{\n  \"mcpServers\": {\n    \"duckdb\": {\n      \"command\": \"uvx\",\n      \"args\": [\n        \"mcp-server-duckdb\",\n        \"--db-path\",\n        \"~/mcp-server-duckdb/data/data.db\"\n      ]\n    }\n  }\n}\n```\n\n* Note: `~/mcp-server-duckdb/data/data.db` should be replaced with the actual path to the DuckDB database file.","tools":"## Available Tools\n\n1.  **query** (Execute any SQL query on the DuckDB database; input is a SQL query string, output is query results as text or success message.)\n2.  **Configuration with db-path** (Specifies the path to the DuckDB database file, creating it if it doesn't exist.)\n3.  **Read-only mode** (Operates the server in read-only mode, preventing write operations and ensuring data integrity.)","faq":null,"created_at":"2024-11-30T14:25:37+00:00","updated_at":"2025-03-28T14:58:17+00:00","source_url":"https://model-context-protocol.com/servers/mcp-server-duckdb-database-interaction-sql","related_articles":[]}