mcp-server-motherduck MCP server

@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": ""
      }
    }
  }
}

工具

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

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

评论

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

MCP Registry

modelcontextprotocol

A community driven registry service for Model Context Protocol (MCP) servers.

ghidraMCP

MCP Server for Ghidra

Maestro

Painless E2E Automation for Mobile and Web

Codelf

A search tool helps dev to solve the naming things problem.

Awesome Mlops

A curated list of references for MLOps