mcp-server-motherduck MCP server

@MCP-Mirror

About mcp-server-motherduck MCP server

Mirror of

Config

Add this server to your MCP-compatible client using the configuration below.

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

Tools

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

Overview

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

Frequently asked questions

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

Comments

Basic information

More Other MCP servers

Blender

ahujasid

Open-source MCP to use Blender with any LLM

23.6K

Unity MCP ✨

justinpbarnett

Unity MCP acts as a bridge between AI assistants and your Unity Editor. Give your LLM tools to manage assets, control scenes, edit scripts, and automate tasks within Unity.

12.2K