MotherDuck MCP
Explore MotherDuck database schemas, query data, and manage Dives, Flights, and Guides through MotherDuck’s official hosted MCP server. Includes SQL writes, scheduled Python jobs, sharing, and deletion tools.
45 actionsAPI key
What your bot can do in MotherDuck MCP
Looks up
- Ask docs questionAsk a question about DuckDB or MotherDuck.
- Dive queryExecute a read-only DuckDB query on behalf of a dive.
- Get dive guideLoad instructions for creating MotherDuck dives.
- Get flightFetch a flight by UUID.
- Get flight guideLoad instructions for authoring, scheduling, running, and troubleshooting MotherDuck flights.
- Get flight logsFetch the plain-text logs (stdout + stderr) of a flight run plus the matching Run record (status, exit_code, timing).
- Get flight runFetch a single run of a flight by its sequential run number (from list_flight_runs).
- Get guideLoad a guide by uuid.
- Get query guideCall this before writing SQL to answer a data question.
- List columnsList all columns of a table or view with their types and comments.
Show 14 more
- List databasesList all databases in your MotherDuck account.
- List divesList all dives in MotherDuck.
- List flight runsList executions of a flight, newest first.
- List flight versionsList the immutable versions of a flight, newest first.
- List flightsList MotherDuck flights.
- List guidesBrowse this organization's curated guides — markdown documents that capture organization and personal context about the data in MotherDuck.
- List macrosList all macros (table and scalar macros) in a MotherDuck database, with their schema and parameters.
- List sharesList all database shares that have been shared with you.
- List tablesList all tables and views in a MotherDuck database with comments.
- List viewsList all views in a MotherDuck database, with their schema, comment, and column count.
- QueryBefore writing SQL to answer a data question, call get_query_guide first — it returns this organization's query guidance and an overview…
- Read diveRead a specific dive by ID, including its full JSX/React component code.
- Search catalogSearch the catalog for databases, schemas, tables, columns, and shares using fuzzy matching.
- View diveOpen and render a MotherDuck Dive as a live MCP app with interactive charts.
Takes action
- Cancel flight runCancel an in-flight run of a flight.
- Create flightCreate a new MotherDuck flight.
- Create guideCreate a new guide — a markdown document that agents read to answer this org's data questions correctly (metric definitions, join/filter…
- Delete diveDelete a dive by ID.
- Delete flightPermanently delete a flight, its versions, schedule, and run history.
- Delete guideSoft-delete a guide while preserving its version history.
- Edit dive contentEdit a dive's content by applying one or more text replacements, then save to MotherDuck.
- Edit flight sourceEdit a flight's source_code by applying one or more text replacements, then save as a new FlightVersion.
- Edit guide contentEdit a guide's markdown body by applying one or more text replacements, then save as a new version.
- Get short lived tokenReturns a short-lived token and connection details for the MotherDuck database endpoint.
Show 11 more
- Log dive viewer eventLog a dive viewer event for analytics.
- Mint dive state referenceMint a server-stored reference for a useDiveState bag and return its id.
- Query rwExecute a DuckDB SQL query that modifies data, schema, or connection state.
- Run flightTrigger an on-demand execution of a flight using its current version.
- Save diveSave a new dive to MotherDuck.
- Set guide accessSet a guide's visibility to 'user' (private to the owner) or 'organization' (visible to the whole org).
- Share dive dataShare the data for a dive with your organization.
- Update diveUpdate an existing dive's title, description, or content.
- Update flightUpdate a flight.
- Update guideAppend a new version to an existing guide, identified by uuid.
- Update guide metadataChange a guide's title, description, or topic without appending a content version.
