MotherDuck

Analyze your data with natural language

Connect AI assistants to your MotherDuck data warehouse. Explore and analyze data, create elegant visualizations, and share with colleagues using natural language–no SQL skills required. Works with messy, real-world data without requiring a semantic model or pre-configuration. The server provides safe, read-only access to your databases: your AI assistant acts like a data analyst, iterating through exploration, validation, and analysis to surface useful answers for any type of user.

Install

1Add the server to Claude Code

claude mcp add --transport http motherduck https://api.motherduck.com/mcp

2Sign in

Run /mcp in Claude Code and complete the login flow for this server.

These instructions target Claude Code. Check the publisher's documentation for support in other Claude surfaces; a valid server URL alone does not establish compatibility.

JSON.mcp.json for a shared project

Commit this file so everyone on the project gets the same server.

{
  "mcpServers": {
    "motherduck": {
      "type": "http",
      "url": "https://api.motherduck.com/mcp"
    }
  }
}

Tools

list_databases
list_shares
list_tables
list_columns
search_catalog
query
ask_docs_question

Discussion

0