DuckDB & MotherDuck MCP Server

DuckDB & MotherDuck MCP Server

This Model Context Protocol server exposes DuckDB — the fast in-process analytical database — and the MotherDuck cloud warehouse to AI agents through a single SQL tool. It is ideal for ad-hoc data analysis where an agent needs to query Parquet, CSV, or JSON without spinning up heavy infrastructure.

Key features

• One query tool that runs arbitrary DuckDB SQL against local files or MotherDuck cloud databases
• Directly reads Parquet, CSV, and JSON with DuckDB's zero-copy, columnar engine
• Supports in-memory mode for throwaway analysis or a persistent .duckdb file
• Optional MotherDuck token to attach shared cloud warehouses and hybrid local/cloud queries
• Lightweight Python implementation installable via uvx, easy to add to any MCP client

Because DuckDB speaks standard SQL and handles gigabyte-scale files on a laptop, this server turns an agent into a capable, low-friction data analyst.

Curated mirror of the open-source mcp-server-motherduck (MIT). Get it from the source.