MotherDuck

Provides a dedicated MCP server to connect to MotherDuck or local DuckDB, browse schemas, and execute queries.

other

0

GitHub Stars

other

Language

7 months ago

First Indexed

3 months ago

Catalog Refreshed

Documentation & install

Readme and setup notes from the catalogue, plus a client-ready config you can copy for your MCP host.

Installation

Add the following to your MCP client configuration file.

Configuration

View docs

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

This MCP server enables you to connect to either a local DuckDB instance or MotherDuck and run queries, browse schemas, and initialize connections from a single, consistent interface. It is designed to boost your workflow by letting you manage data sources directly through the MCP client.

How to use

You interact with the MotherDuck MCP server by connecting through an MCP client. Use the available tools to initialize a connection, inspect schemas, and run queries against your DuckDB or MotherDuck databases. The server exposes three core capabilities: initialize a connection to a local DuckDB or MotherDuck, read table schemas from a specific database, and execute queries on the connected database.

initialize-connection: Establish a connection to either a local DuckDB or MotherDuck and retrieve the list of databases you can work with.
read-schemas: Retrieve the schemas for tables within a chosen DuckDB/MotherDuck database to understand column types and structures.
execute-query: Run a SQL query against the connected MotherDuck (DuckDB) database and return results.

How to install

Prerequisites: ensure you have the runtime environment required by the MCP server available on your machine. You should have the MCP runtime (uvx) installed and accessible from your command line.

Prepare the MCP server configuration snippet that defines how to start the server and what environment variables to provide.
Start the MCP server using the exact command and arguments shown in the configuration snippet.
Set any required environment variables before launching the MCP server to ensure proper authentication and runtime behavior.

Configuration and usage notes

The server supports a single MCP entry for local runtime usage. You configure it using a standard MCP JSON structure, specifying the command to run, its arguments, and any environment variables that are required.

Available tools

initialize-connection

Create a connection to either a local DuckDB or MotherDuck and retrieve available databases

read-schemas

Get table schemas from a specific DuckDB/MotherDuck database

execute-query

Execute a query on the MotherDuck (DuckDB) database