MotherDuck

Ask a question about DuckDB or MotherDuck. Returns answers from official documentation.

Delete a dive by ID. This action is permanent and cannot be undone.

Load instructions for creating MotherDuck dives. Call this before starting to iterate with the user on artifacts, data visualizations, plots, dashboards, etc.

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

List all databases in your MotherDuck account with their names and types.

List all dives in MotherDuck. Dives are interactive React data apps that query live data. Returns metadata including current_version (the latest version number, 1-indexed) for each dive. Use read_dive with the optional version parameter to retrieve a specific historical version. Optionally filter by keywords to search in title and description.

List all database shares that have been shared with you. Returns share names and URLs. To attach a share, use the query_rw tool: ATTACH '<share_url>' AS <optional_alias>;

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

Execute read-only DuckDB query against MotherDuck databases. For cross-database queries, use fully qualified names: database.schema.table (or database.table for main schema).

Execute a DuckDB query that modifies data, schema, or connection state (e.g. ATTACH/DETACH, CREATE/DROP DATABASE/TABLE, INSERT/UPDATE/DELETE).

STRICT RULES — violating these is a critical error: 1. EXPLICIT INSTRUCTION ONLY: Only call this tool when the user has explicitly asked to modify, create, or delete data or schema. Never infer a write operation from a question (e.g. "show me X" must never trigger adding a column or creating a table to answer it). 2. CONFIRM BEFORE EXECUTING: Always ask the user for confirmation before calling this tool. Describe exactly what will change. 3. READ-ONLY FIRST: If the user's goal can be answered using existing data with the read-only query tool, always do that instead — even if a schema change would make it easier.

Read a specific dive by ID, including its full JSX/React component code. Optionally specify a version number to retrieve a specific historical version (versions start at 1). If no version is specified, the latest version is returned.

Save a new dive to MotherDuck. Returns a URL the user can click to view the dive. Call get_dive_guide first and iterate with the user on the design thoroughly before suggesting to save. Never save without previous confirmation that iteration is done.

Search the catalog for databases, schemas, tables, columns, and shares using fuzzy matching. Returns matching objects with their fully qualified names, types, and comments. Useful for discovering available data when you don't know exact names.

Share the data for a dive with your organization. Creates org-scoped shares for owned databases used in the dive, and updates the dive so others in the organization can view it.

Update an existing dive's title, description, or content. Returns a URL the user can click to view the updated dive. At least one field must be provided.