MCP server

MotherDuck / DuckDB MCP Server

Run DuckDB SQL locally or against MotherDuck, over files, S3 or a cloud warehouse.

Save Visit website ↗

Add it to your client

Official

Install

uvx mcp-server-motherduck --db-path md:

mcpServers

{
  "mcpServers": {
    "motherduck-mcp": {
      "command": "uvx",
      "args": [
        "mcp-server-motherduck",
        "--db-path",
        "md:"
      ]
    }
  }
}

Transport: both
Runtime: Python
Auth: Required
Tools: 5
License: MIT

Tools

execute_querylist_databaseslist_tableslist_columnsswitch_database_connection

One server covers both ends of DuckDB: an in-memory or on-disk local database and a MotherDuck cloud account, picked with a database path argument. Beyond executing SQL it can enumerate databases, tables and columns, which lets a model read the shape of the data before writing a query against it. The connection can be switched mid-session, so a local file and a hosted warehouse are reachable from the same session. A token is required only for MotherDuck; local DuckDB files and S3 paths work without one.

Comments(0)

No comments yet — be the first.

Similar MCP servers

Meilisearch MCP

MCP server

Operates a Meilisearch instance, not just its search endpoint.

DatabasesSearch Engines & Web

ClickHouse MCP Server

MCP server

Run read-only SQL against ClickHouse and browse its databases and tables.

Data & AnalyticsDatabases

DuckDB MCP Server

MCP server

A single-tool DuckDB server for local analytical queries.

Data & AnalyticsDatabases