Advertise
MCP.so
Sign In

mcp-server-motherduck MCP server

@MCP-Mirror

Repository

Basic information

Category

Other

Transports

stdio

Author

MCP-Mirror

About mcp-server-motherduck MCP server

Mirror of

#mcp-server#motherduck#duckdb

mcp-server-motherduck MCP server 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": ""
      }
    }
  }
}

mcp-server-motherduck MCP server tools

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

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

Frequently asked questions

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

Comments

More Other MCP servers

Health by Dr Brad

Dr Brad Stanfield

Health by Dr Brad works out a health plan from your own results: which screening is due at your age, and evidence-based suggestions, each with the reason and the published guideline or study behind it. Your record is one

P

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

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

DeepMark

DeepMark helps teachers deliver rapid, consistent marking with meaningful feedback for every student — in a fraction of the time. What once took a week, now takes one free period.

MaxKB

1Panel-dev

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

22.0K
Advertise