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

EverArt

modelcontextprotocol

Model Context Protocol Servers

88.1K

Maestro

mobile-dev-inc

Painless E2E Automation for Mobile and Web

14.8K

Sequential Thinking

modelcontextprotocol

Model Context Protocol Servers

88.2K

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

Hindsight

vectorize-io

Hindsight: Agent Memory That Learns

50.4K
Advertise