MCP.so
Sign In

mcp-server-motherduck MCP server

@MCP-Mirror

Repository

About mcp-server-motherduck MCP server

Mirror of

#mcp-server#motherduck#duckdb

Basic information

Category

Other

Transports

stdio

Publisher

MCP-Mirror

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

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

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

Comments

More Other MCP servers

🚀 Model Context Protocol (MCP) Curriculum for Beginners

microsoft

This open-source curriculum introduces the fundamentals of Model Context Protocol (MCP) through real-world, cross-language examples in .NET, Java, TypeScript, JavaScript, Rust and Python. Designed for developers, it focuses on practical techniques for building modular, scalable,

16.7K

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

MCP Toolbox for Databases

googleapis

MCP Toolbox for Databases is an open source MCP server for databases.

15.9K

Website

FunnyWolf

Adversary simulation and Red teaming platform with AI

5.1K

Activepieces

activepieces

AI Agents & MCPs & AI Workflow Automation • (~400 MCP servers for AI agents) • AI Automation / AI Agent with MCPs • AI Workflows & AI Agents • MCPs for AI Agents

23.2K