How to connect MotherDuck MCP to Claude

Ask a question about DuckDB or MotherDuck.

Cancel an in-flight run of a flight.

Create a new MotherDuck flight.

Create a new guide — a markdown document that agents read to answer this org's data questions correctly (metric definitions, join/filter conventions, pitfalls).

Delete a dive by ID.

Permanently delete a flight, its versions, schedule, and run history.

Soft-delete a guide while preserving its version history.

Execute a read-only DuckDB query on behalf of a dive.

Edit a dive's content by applying one or more text replacements, then save to MotherDuck.

Edit a flight's source_code by applying one or more text replacements, then save as a new FlightVersion.

Edit a guide's markdown body by applying one or more text replacements, then save as a new version.

Load instructions for creating MotherDuck dives.

Fetch a flight by UUID.

Load instructions for authoring, scheduling, running, and troubleshooting MotherDuck flights.

Fetch the plain-text logs (stdout + stderr) of a flight run plus the matching `Run` record (status, exit_code, timing).

Fetch a single run of a flight by its sequential run number (from list_flight_runs).

Load a guide by uuid.

Call this before writing SQL to answer a data question.

Returns a short-lived token and connection details for the MotherDuck database endpoint.

List all columns of a table or view with their types and comments.

List all databases in your MotherDuck account.

List all dives in MotherDuck.

List executions of a flight, newest first.

List MotherDuck flights.

List the immutable versions of a flight, newest first.

Browse this organization's curated guides — markdown documents that capture organization and personal context about the data in MotherDuck.

List all macros (table and scalar macros) in a MotherDuck database, with their schema and parameters.

List all database shares that have been shared with you.

List all tables and views in a MotherDuck database with comments.

List all views in a MotherDuck database, with their schema, comment, and column count.

Log a dive viewer event for analytics.

Mint a server-stored reference for a `useDiveState` bag and return its id.

Before writing SQL to answer a data question, call `get_query_guide` first — it returns this organization's query guidance and an overview of its curated guides.

Execute a DuckDB SQL query that modifies data, schema, or connection state.

Read a specific dive by ID, including its full JSX/React component code.

Trigger an on-demand execution of a flight using its current version.

Save a new dive to MotherDuck.

Search the catalog for databases, schemas, tables, columns, and shares using fuzzy matching.

Set a guide's visibility to 'user' (private to the owner) or 'organization' (visible to the whole org).

Share the data for a dive with your organization.

Update an existing dive's title, description, or content.

Update a flight.

Append a new version to an existing guide, identified by `uuid`.

Change a guide's title, description, or topic without appending a content version.

Open and render a MotherDuck Dive as a live MCP app with interactive charts.