MotherDuck Now Speaks Postgres! Our pg_endpoint is now live!Demo - April 21

Skip to main content

MotherDuck MCP server

MotherDuck offers a remote MCP server (fully managed, read-write) and a local MCP server (fully customizable, self-hosted) that let AI assistants query and explore your MotherDuck databases using the Model Context Protocol (MCP).

For step-by-step setup instructions for all supported clients (Claude, ChatGPT, Cursor, Claude Code, and others), see Connect to the MotherDuck MCP Server.

Server capabilities​

With the remote MCP server, your agent can:

  • Execute read-only and read-write SQL against your databases
  • Explore database schemas, tables, and columns
  • Attach and detach shares
  • Ask questions about DuckDB and MotherDuck documentation
  • Create and manage Dives (interactive data visualizations)

For clients that support MCP instructions, the remote MCP server provides detailed query guidelines to help AI assistants write effective DuckDB SQL. Learn more about using the MotherDuck MCP server.

Regional availability​

The remote MCP server is available in all MotherDuck regions. Requests are routed to the MCP server closest to where the client runs:

  • Desktop clients (Cursor, Claude Code): Routed based on your physical location
  • Web-based agents (Claude.ai, ChatGPT): Routed based on the agent provider's server location

Your data is always processed in your MotherDuck organization's region. However, query results transit through the remote MCP server. If you have strict data residency requirements, ensure your MCP client runs within your region.

Restricting to read-only access​

The remote MCP server exposes both read-only and read-write tools. To restrict your AI assistant to read-only access, see Restricting to read-only access.

Local MCP server​

For local DuckDB databases, custom configurations, or self-hosted scenarios, use the local MCP server (mcp-server-motherduck). For a comparison of remote vs local and when to use each, see the setup guide.

📦 Local MCP Server GitHub Repository – Self-host the open-source MCP server for DuckDB and MotherDuck