Skip to content
MotherDuck / DuckDB

MotherDuck / DuckDBMCP Server

by MotherDuck
Added to Onei
v1.0.7
Repository Docs
Databases & Data

Summary

Run DuckDB analytics locally or in MotherDuck's cloud — query files and warehouses with the same SQL.

Features

  • Analytical SQL over local DuckDB files or MotherDuck cloud
  • Query Parquet, CSV, and JSON directly without loading
  • Read-only mode for safe exploration

Installation

Set up this MCP server in your favorite AI agent — copy a ready-made configuration below.

Any MCP-compatible agent

Most agents (Claude, Cursor, Windsurf, VS Code, and more) read a standard mcpServers configuration.

  1. Open your agent's MCP configuration file.
  2. Merge the snippet below into it.
  3. Restart the agent — the "MotherDuck / DuckDB" tools will be available.
{
  "mcpServers": {
    "motherduck": {
      "command": "uvx",
      "args": [
        "mcp-server-motherduck",
        "--db-path",
        "md:"
      ]
    }
  }
}

Description

The MotherDuck MCP server gives an assistant a full analytical SQL engine, working against local DuckDB databases, MotherDuck's cloud warehouse, or files on disk and in object storage.

What makes DuckDB a good fit here

You can query a Parquet, CSV, or JSON file directly — no import step, no schema definition. That means an assistant can answer questions about a data file the moment it exists, which removes most of the friction from ad-hoc analysis.

Capabilities
  • SQL execution with DuckDB's full analytical feature set — window functions, CTEs, complex joins
  • File querying across local paths and S3 and other object stores
  • MotherDuck cloud for shared, persistent warehouses
  • Hybrid execution, combining local files with cloud tables in one query
  • Read-only mode for exploration you do not want writing anything
Setup

uvx mcp-server-motherduck --db-path md: for the cloud service with a MotherDuck token, or a local file path for pure DuckDB use.

Related MCP Servers

MCP: Tableau MCP

by Tableau

Featured

Tableau's own MCP server — query published data sources, explore workbooks and views, and render live vizzes inside an AI client.

Databases & Data

MCP: Data Commons MCP Server

by Data Commons

Query public statistics — health, economic, demographic and climate indicators from hundreds of official sources — through the Data Commons knowledge graph, hosted or self-run.

Databases & Data

MCP: dbt

by dbt Labs

dbt Labs' official MCP server — explore project metadata, run dbt commands, and query the Semantic Layer.

Databases & Data
Browse all MCP servers →