MotherDuck DuckDB MCP Server

Example Use Cases

• 1

  Execute SQL analytics over local DuckDB files or in-memory databases directly from an IDE or assistant.

• 2

  Query cloud-hosted MotherDuck databases or S3-backed DuckDB files using token-based authentication, with options for read-only and SaaS modes for security.

• 3

  Integrate interactive data exploration into developer tools (Cursor, VS Code, Claude) and share/query databases without managing infrastructure.

Description

This MCP server provides a hybrid execution layer allowing queries against local DuckDB, S3-hosted DuckDB files, or MotherDuck cloud databases using standard SQL. It supports token-based access to MotherDuck, read-only and SaaS modes for secure deployments, and integrates with developer tools like Cursor, VS Code, and Claude. The project is open-source (MIT) and designed for serverless, short-lived connections to enable concurrent access and simple embedding into agent workflows. It also includes utilities for S3 access and guidance for secure configuration and read-scaling tokens.