MotherDuck MCP ServerUnclaimed

MotherDuck's MCP server lets AI assistants such as Claude, ChatGPT and Cursor query and explore MotherDuck databases over the Model Context Protocol. The remote server is fully managed and read-write, and most clients connect to its single hosted URL through OAuth.

With it, an agent can run read-only and read-write SQL, explore schemas, tables and columns, attach and detach shares, and ask questions about DuckDB and MotherDuck documentation. It can also create and manage Dives, which are interactive data visualisations, and create, schedule and monitor Flights, which are scheduled Python jobs that run on MotherDuck compute. Guides are markdown documents that hold an organisation's metric definitions and join conventions, so agents can write more accurate SQL.

The server is aimed at data teams, software engineers and founders who want to work with their MotherDuck data through an AI assistant. The docs describe how to restrict an assistant to read-only access. Teams that need a self-hosted option or work with local DuckDB databases can use the open-source local MCP server, mcp-server-motherduck, instead.

Query results pass through the remote server. Data is processed in the organisation's MotherDuck region, so clients with strict residency requirements should run within that region.

The MCP server is listed on the pricing page as part of the plans rather than as a separate product. The Lite plan starts at $0, and the Business plan costs $250 per organisation per month plus usage.