MotherDuck MCP Server

What it does

The MotherDuck MCP Server lets an MCP-compatible AI agent query schemas and data stored in a MotherDuck cloud warehouse built on DuckDB. Named clients include Claude, ChatGPT, Gemini, and Cursor. Users ask questions in plain English, and the agent can also create visualizations and manage pipelines.

Every query runs in isolated compute and returns traceable SQL, so results can be verified. Compute is isolated with read-only access by default. From an LLM client, the server can also generate native, shareable artifacts for ad hoc analysis, with no separate dashboarding tool required.

It suits business users who want answers without writing SQL, and engineers who want to audit agent-generated queries. The free Lite plan includes 10 GB of storage and 10 hours of Pulse compute per month, with no credit card required. Each organization is scoped to a single cloud region, and MotherDuck is a managed cloud service with no on-premises version.

What it can do

• Query schemas and data in natural language from an MCP-compatible AI agent
• Generate native, shareable visualizations from LLM client prompts
• Return traceable SQL for every answer
• Run queries in isolated, read-only-by-default compute
• Use MotherDuck catalog tools for iterative analysis
• Manage data pipelines from the agent

Works with

• Claude
• ChatGPT
• Gemini
• Cursor

Before you choose

• Each organization is scoped to one cloud region chosen at creation, available across six AWS regions.
• Advanced AI functions are metered in AI Units; Lite and Business plans have a default soft limit of 10 AI Units per day.
• The Lite plan limits internal active users to 3 and service accounts to 2; team-scale use requires the Business plan at $250 per org per month plus usage.

Listed under

• Coding
• MCP and agent tools

Lite is free with 10 GB storage and 10 hours Pulse compute per month, no credit card. Business is $250 per org per month plus usage after a 7-day free trial. Compute is billed per second by instance size; storage is $0.04 per GB per month.

7-day free trial.

Source: motherduck.com/product/pricing, checked 29 Oct 2026. Prices can change; check before you buy.