广告合作
MCP.so
登录

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 工具

3

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

常见问题

1

What command is used to start the server?

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

2

How do I authenticate with MotherDuck?

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

3

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`.

4

What environment variables must be set?

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

5

What tools does the server provide?

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

评论

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

Blender

ahujasid

Open-source MCP to use Blender with any LLM

23.6K

Maestro

mobile-dev-inc

Painless E2E Automation for Mobile and Web

14.8K

Soar Flight Booking MCP

Soar Flight Booking MCP is a remote MCP server available at https://mcp.soar.flights.

Glasswarp

Glasswarp

See and control a real Windows PC you own — from any MCP client, locally or remotely. Observe (UIA + screenshots), click/type/drag/scroll, launch apps, owner Live View. BYOH: your machine, your key.

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
广告合作