{"type":"mcp_server","name":"mcp-server-motherduck","description":"This repository provides an MCP server that integrates MotherDuck and local DuckDB, enabling SQL analytics for Claude. It features hybrid execution, cloud storage integration, and serverless architecture, allowing users to","category":"Database","language":"Python","stars":497,"forks":7,"owner":"motherduckdb","github_url":"https://github.com/motherduckdb/mcp-server-motherduck","homepage":null,"setup":"## Setup\n\n1.  Have a MotherDuck account (sign up at [motherduck.com](https://motherduck.com)).\n2.  Have a MotherDuck access token.\n3.  Install `uv` using `pip install uv` or `brew install uv`.\n4.  Install Claude Desktop from [claude.ai/download](https://claude.ai/download) if using Claude Desktop.\n5.  Open the Claude Desktop configuration file (Settings -> Developer -> Edit Config).\n6.  Add the MCP server configuration to `claude_desktop_config.json`:\n\n```json\n\"mcpServers\": {\n  \"mcp-server-motherduck\": {\n    \"command\": \"uvx\",\n    \"args\": [\n      \"mcp-server-motherduck\",\n      \"--db-path\",\n      \"md:\",\n      \"--motherduck-token\",\n      \"<YOUR_MOTHERDUCK_TOKEN_HERE>\",\n    ],\n  }\n}\n```\n\n**Important Notes**:\n\n*   Replace `YOUR_MOTHERDUCK_TOKEN_HERE` with your actual MotherDuck token.\n*   The `HOME` environment variable is required for DuckDB to function properly.","tools":"## Available Tools\n\n1.  Hybrid execution (query data from both cloud-based MotherDuck and local DuckDB)\n2.  Cloud storage integration (access data stored in Amazon S3 or other cloud storage thanks to MotherDuck's integrations)\n3.  Data sharing (create and share databases)\n4.  SQL analytics (use DuckDB's SQL dialect to query any size of data directly from Claude)\n5.  Serverless architecture (run analytics without needing to configure instances or clusters)\n6.  `duckdb-motherduck-initial-prompt` (A prompt to initialize a connection to DuckDB or MotherDuck and start working with it)\n7.  `query` (Execute a SQL query on the MotherDuck/DuckDB database)","faq":null,"created_at":"2024-12-12T23:37:11+00:00","updated_at":"2025-03-28T20:39:24+00:00","source_url":"https://model-context-protocol.com/servers/mcp-server-motherduck-sql-analytics","related_articles":[]}