mcp-server-motherduck MCP server

Name: mcp-server-motherduck MCP server
Author: MCP-Mirror

@MCP-Mirror

リポジトリ

mcp-server-motherduck MCP server について

Mirror of

#mcp-server #motherduck #duckdb

基本情報

カテゴリ

その他

トランスポート

stdio

公開者

MCP-Mirror

設定

以下の設定を使って、このサーバーを MCP 対応クライアントに追加してください。

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

ツール

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

FAQ from mcp-server-motherduck

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

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

Nginx UI

0xJacky

Yet another WebUI for Nginx

11.3K

Reactive Resume

amruthpillai

A one-of-a-kind resume builder that keeps your privacy in mind. Completely secure, customizable, portable, open-source and free forever. Try it out today!

39.5K