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

「その他」の他のコンテンツ

Lemon.io

lemon-io

Request dedicated senior developers to work on your project, write job descriptions, and prep technical interviews — all without leaving your Claude chat. Just describe what you need, and Lemon.io MCP does the rest. 1–3

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.

MaxKB

1Panel-dev

🔥 MaxKB is an open-source platform for building enterprise-grade agents. 强大易用的开源企业级智能体平台。

22.0K

Volley.sh

Volley

A good sequence diagram can solve almost any communication problem in engineering. Volley lets your agent write them as plain text, with the real request and response payloads on every arrow. It checks its own syntax wi

PickFu MCP

PickFu MCP is a Model Context Protocol (MCP) server that connects AI assistants, developers, marketers, product managers, and AI agents to PickFu's consumer research platform. It enables users to create surveys, conduct