mcp-server-motherduck MCP server

@MCP-Mirror

代码仓库

基本信息

分类

其他

传输方式

stdio

作者

MCP-Mirror

关于 mcp-server-motherduck MCP server

Mirror of

#mcp-server#motherduck#duckdb

mcp-server-motherduck MCP server 配置

使用下面的配置,将此服务器添加到你的 MCP 客户端。

{
  "mcpServers": {
    "mcp-server-motherduck": {
      "command": "uvx",
      "args": [
        "mcp-server-motherduck"
      ],
      "env": {
        "motherduck_token": "",
        "HOME": ""
      }
    }
  }
}

mcp-server-motherduck MCP server 工具

Create a connection to either a local DuckDB or MotherDuck and retrieve available databases

Get table schemas from a specific DuckDB/MotherDuck database

Execute a query on the MotherDuck (DuckDB) database

概览

What is mcp-server-motherduck?

An MCP server for MotherDuck and local DuckDB. It enables AI assistants to initialize a connection, read database schemas, and execute SQL queries on DuckDB or MotherDuck instances.

How to use mcp-server-motherduck?

Configure the server in Claude Desktop by adding the JSON snippet to claude_desktop_config.json. The server is run via uvx mcp-server-motherduck. When using MotherDuck, set the motherduck_token environment variable; also set the HOME variable to your home folder (required by DuckDB).

Key features of mcp-server-motherduck

Three tools: initialize‑connection, read‑schemas, execute‑query
One prompt: duckdb‑motherduck‑initial‑prompt
Initialize a DuckDB (local) or MotherDuck connection
Read table schemas from a specified database
Execute arbitrary SQL queries on the connected database

Use cases of mcp-server-motherduck

Connecting an AI assistant to a local DuckDB for data analysis
Querying a MotherDuck cloud database through natural language
Exploring database schemas before running analytical queries
Automating database initialization and querying in conversational workflows

常见问题

What command is used to start the server?

The server is started with `uvx mcp-server-motherduck`.

How do I authenticate with MotherDuck?

Set the `motherduck_token` environment variable in the server’s configuration. (See MotherDuck documentation for obtaining the token.)

Where is the Claude Desktop configuration file located?

On macOS: `~/Library/Application Support/Claude/claude_desktop_config.json`. On Windows: `%APPDATA%/Claude/claude_desktop_config.json`.

What environment variables must be set?

You must set `HOME` to your home folder (required by DuckDB). When using MotherDuck, also set `motherduck_token`.

What tools does the server provide?

Three tools: `initialize-connection` (takes type), `read-schemas` (takes database_name), and `execute-query` (takes query).

其他分类下的更多 MCP 服务器

YOUB

Connect your AI assistant to your own YOUB endurance training account. Read recorded activities with full analysis, planned sessions, race goals, wellness (HRV, sleep, resting HR) and your athletic profile. Create or mov

FastMCP v2 🚀

jlowin

🚀 The fast, Pythonic way to build MCP servers and clients.

26.0K

Klarix Intelligence Engine

Klarix

B2B competitive intelligence, live sales battlecards, 5-axis ICP prospect fit scoring, and tech stack teardowns over MCP and REST with cited public-web evidence.

Activepieces

activepieces

AI Agents & MCPs & AI Workflow Automation • (~400 MCP servers for AI agents) • AI Automation / AI Agent with MCPs • AI Workflows & AI Agents • MCPs for AI Agents

23.2K

Screenpipe

screenpipe

YC (S26) | Open Computer History | Continuously record your company computer work, map your workflows, help you find work worth automating, and power your agents' context

22.0K