M
Data & Analytics45 toolsBrowser login (OAuth), no API keys
MotherDuck integration for AI agents
Explore MotherDuck database schemas, query data, and manage Dives, Flights, and Guides through MotherDuck’s official hosted MCP server.
Use it from your agent
One ClawLink account serves every agent you run. Pick the guide for yours, or connect MotherDuck once and call the same tools from all of them.
Setup
Connect MotherDuck through ClawLink's hosted setup.
- Auth: Browser login (OAuth), no API keys. The credential stays on the ClawLink server; your agent holds only a ClawLink key you can revoke.
- Where: the ClawLink dashboard, or ask your agent to connect it.
What your agent can do
MotherDuck exposes 45 tools through ClawLink. The 30 most used are listed here; your agent sees all of them.
| Tool | What it does | Kind |
|---|---|---|
motherduck_mcp_ask_docs_question | Ask a question about DuckDB or MotherDuck | Read |
motherduck_mcp_dive_query | Execute a read-only DuckDB query on behalf of a dive | Read |
motherduck_mcp_get_dive_guide | Load instructions for creating MotherDuck dives | Read |
motherduck_mcp_get_flight | Fetch a flight by UUID | Read |
motherduck_mcp_get_flight_guide | Load instructions for authoring, scheduling, running, and troubleshooting MotherDuck flights | Read |
motherduck_mcp_get_flight_logs | Fetch the plain-text logs (stdout + stderr) of a flight run plus the matching `Run` record | Read |
motherduck_mcp_get_flight_run | Fetch a single run of a flight by its sequential run number (from list_flight_runs) | Read |
motherduck_mcp_get_guide | Load a guide by uuid | Read |
motherduck_mcp_get_query_guide | Call this before writing SQL to answer a data question | Read |
motherduck_mcp_list_columns | List all columns of a table or view with their types and comments | Read |
motherduck_mcp_list_databases | List all databases in your MotherDuck account | Read |
motherduck_mcp_list_dives | List all dives in MotherDuck | Read |
motherduck_mcp_list_flight_runs | List executions of a flight, newest first | Read |
motherduck_mcp_list_flight_versions | List the immutable versions of a flight, newest first | Read |
motherduck_mcp_list_flights | List MotherDuck flights | Read |
motherduck_mcp_list_guides | Browse this organization's curated guides — markdown documents that capture organization and | Read |
motherduck_mcp_list_macros | List all macros (table and scalar macros) in a MotherDuck database, with their schema and | Read |
motherduck_mcp_list_shares | List all database shares that have been shared with you | Read |
motherduck_mcp_list_tables | List all tables and views in a MotherDuck database with comments | Read |
motherduck_mcp_list_views | List all views in a MotherDuck database, with their schema, comment, and column count | Read |
motherduck_mcp_query | Before writing SQL to answer a data question, call `get_query_guide` first — it returns this | Read |
motherduck_mcp_read_dive | Read a specific dive by ID, including its full JSX/React component code | Read |
motherduck_mcp_search_catalog | Search the catalog for databases, schemas, tables, columns, and shares using fuzzy matching | Read |
motherduck_mcp_view_dive | Open and render a MotherDuck Dive as a live MCP app with interactive charts | Read |
motherduck_mcp_cancel_flight_run | Cancel an in-flight run of a flight | Read |
motherduck_mcp_create_guide | Create a new guide — a markdown document that agents read to answer this org's data questions | Read |
motherduck_mcp_edit_dive_content | Edit a dive's content by applying one or more text replacements, then save to MotherDuck | Read |
motherduck_mcp_edit_guide_content | Edit a guide's markdown body by applying one or more text replacements, then save as a new | Read |
motherduck_mcp_get_short_lived_token | Returns a short-lived token and connection details for the MotherDuck database endpoint | Read |
motherduck_mcp_log_dive_viewer_event | Log a dive viewer event for analytics | Read |