MotherDuck MCP integration
AI utilities connector, available on Zeplik
MotherDuck MCP is available as an integration on Zeplik, the AI assistant that works across every model in one chat. Connect MotherDuck MCP and Zeplik can act on your AI for you: Explore MotherDuck database schemas, query data, and manage Dives, Flights, and Guides through MotherDuck's official hosted MCP server. Includes SQL. You stay in the conversation while the assistant does the work in MotherDuck MCP directly.
Zeplik exposes 24 read actions and 21 write actions for MotherDuck MCP. Read actions run automatically; write actions stay off until you enable write access in Settings, so nothing is changed in MotherDuck MCP without your consent.
Try MotherDuck MCP on Zeplik
Pick a prompt to open it in the Zeplik app. If you are not signed in yet, your prompt is waiting for you the moment you do.
What Zeplik can do with MotherDuck MCP
Read from MotherDuck MCP (24)
Runs automatically in any conversation.
Get dive guide
Load instructions for creating MotherDuck dives. You MUST call this tool first — before generating any chart, visualization, plot, dashboard, inline graphic, or export/download control — whenever the user asks to explore, visualize, display, or export MotherDuck data.
Get flight
Fetch a flight by UUID. Returns metadata plus a version snapshot (source code, requirements, config, secret names, token name). Omit `version` to get the current version; pass a 1-indexed version number to inspect history.
Get flight guide
Load instructions for authoring, scheduling, running, and troubleshooting MotherDuck flights. Call this tool first whenever the user asks about creating, updating, or operating a MotherDuck flight.
Get flight logs
Fetch the plain-text logs (stdout + stderr) of a flight run plus the matching `Run` record (status, exit_code, timing). Returns the last 200 lines by default; page with `limit`, `offset` and `order`. Pass `max_bytes` to cap the response size — the response is truncated to fit and the truncation is reported via `truncated: true`.
Get flight run
Fetch a single run of a flight by its sequential run number (from list_flight_runs). Returns the same shape as a list_flight_runs entry: status (PENDING/RUNNING/SUCCEEDED/FAILED/CANCELLED), timing metadata, and the effective `config` the run executed with. Use this to poll one run's status instead of re-listing.
Get guide
Load a guide by uuid. Guides are curated markdown documents about this organization's data (metric definitions, conventions, pitfalls). Find a guide's uuid with `list_guides` or via `get_query_guide` (start there before writing SQL), `get_dive_guide`, or `get_flight_guide`.
Get query guide
Call this before writing SQL to answer a data question. Returns this organization's query guidance: what guides exist (curated markdown documents about the data — metric definitions, join/filter conventions, pitfalls), how to navigate them, and an overview of the available guide topics.
Get short lived token
Returns a short-lived token and connection details for the MotherDuck database endpoint.
List columns
List all columns of a table or view with their types and comments.
List databases
List all databases in your MotherDuck account. Shows each database's alias, type, and its `url` — a fully qualified MotherDuck database name (e.g. `md:my_db`) or share URL (e.g. in guide references). Optionally filter by keywords.
List dives
List all dives in MotherDuck. Dives are interactive React data apps that query live data. Returns metadata including current_version and status. Each dive has a governance status: 'endorsed' (admin-approved org source of truth — prefer these), 'ready' (author-reviewed), 'draft' (work in progress; the default for new dives), or 'archived' (retired; excluded unless include_archived is true). Results are ordered endorsed, ready, draft, then archived, most recently updated first. Use read_dive with the optional version parameter to retrieve a specific historical version. Optionally filter by keywords.
List flight runs
List executions of a flight, newest first. Each run has a sequential number, status (PENDING/RUNNING/SUCCEEDED/FAILED/CANCELLED), timing metadata, and the effective `config` it ran with (the flight version's config merged with any per-run overrides).
and 12 more.
Act in MotherDuck MCP (21)
Runs only after you enable write access.
Ask docs question
Ask a question about DuckDB or MotherDuck. Returns answers from official documentation.
Cancel flight run
Cancel an in-flight run of a flight. Identified by the flight UUID and the sequential run number (from list_flight_runs). Returns `canceled: true` on a successful transition; calling on an already-terminal run or one that doesn't exist returns a tool error.
Create flight
Create a new MotherDuck flight. Read the flight guide before you create your first flight. A flight is a Python entrypoint (`source_code`) plus an optional `requirements_txt` that runs on MotherDuck compute. Optionally provide an `access_token_name` so the flight can connect to MotherDuck at runtime; omit it to use the default MotherDuck Flights access token. Optionally provide a 5-field cron expression to run on a schedule, an optional `max_runtime_sec` to cap how long a run may take, and an optional `instance_type` (F4, F16 or F32) to pick the runner size. Use flights for ELT/ETL pipelines, loading external data into MotherDuck, refreshing materialized views, or any recurring Python job that reads/writes MotherDuck data.
Create guide
Create a new guide — a markdown document that agents read to answer this org's data questions correctly (metric definitions, join/filter conventions, pitfalls). Group related guides with a lowercase kebab-case `topic` (e.g. 'revenue-billing' or 'core/metrics'); omit it for a guide without a topic. Visibility is controlled by `access`: 'user' (private, default) or 'organization' (org-wide, permission-gated). Personal dive/flight style guides belong under topic 'dives' / 'flights' with access 'user'. Attach `references` to the 1–5 objects the guide is authoritative about.
Delete dive
Delete a dive by ID. This action is permanent and cannot be undone.
Delete flight
Permanently delete a flight, its versions, schedule, and run history. This action cannot be undone.
Delete guide
Soft-delete a guide while preserving its version history. Identify it by `uuid`.
Dive query
Execute a read-only DuckDB query on behalf of a dive. This tool is used by the dive viewer and is not intended for direct use by the AI assistant.
Edit dive content
Edit a dive's content by applying one or more text replacements, then save to MotherDuck. Accepts `id` (dive UUID) and `edits` (an array of {old_string, new_string, replace_all?} objects). Reads the current content from MotherDuck, applies edits in sequence, validates, and persists. Example: {id: '...', edits: [{old_string: 'foo', new_string: 'bar'}]}. old_string must be unique unless replace_all is true. No prior read_dive call is needed.
Edit flight source
Edit a flight's source_code by applying one or more text replacements, then save as a new FlightVersion. Accepts `id` (flight UUID) and `edits` (an array of {old_string, new_string, replace_all?} objects). Reads the current source_code, applies edits in sequence, validates, and persists. Example: {id: '...', edits: [{old_string: 'foo', new_string: 'bar'}]}. old_string must be unique unless replace_all is true. No prior get_flight call is needed.
Edit guide content
Edit a guide's markdown body by applying one or more text replacements, then save as a new version. Identify the guide by `uuid`. Reads the stored guide, applies edits in sequence, and persists. Example: {uuid: '<guide uuid>', edits: [{old_string: 'foo', new_string: 'bar'}]}. old_string must be unique unless replace_all is true. No prior get_guide call is needed.
Log dive viewer event
Log a dive viewer event for analytics. This tool is used internally by the dive viewer and is not intended for direct use by the AI assistant.
and 9 more.
How to connect MotherDuck MCP
Sign in to Zeplik
Create a free Zeplik account or sign in. New accounts start with free credits, so you can try MotherDuck MCP immediately.
Connect MotherDuck MCP
Open Settings and go to Connectors, then press Connect on MotherDuck MCP. You can also connect from the MotherDuck MCP page in the app.
Approve access to MotherDuck MCP
Approve access on MotherDuck MCP's secure consent screen. You are returned to Zeplik and can start giving instructions that use MotherDuck MCP.
Frequently asked questions
- Can I use MotherDuck MCP with Zeplik?
- Yes. MotherDuck MCP is available as an integration on Zeplik. Connect it once and the AI assistant can work with your MotherDuck MCP account inside any conversation.
- What can Zeplik do with MotherDuck MCP?
- Once connected, Zeplik has 24 read and 21 write actions for MotherDuck MCP. Explore MotherDuck database schemas, query data, and manage Dives, Flights, and Guides through MotherDuck's official hosted MCP server. Includes SQL.
- How do I connect MotherDuck MCP to Zeplik?
- You connect MotherDuck MCP with a secure one-click sign-in (OAuth): press Connect in Settings under Connectors and approve access on MotherDuck MCP's consent screen.
- Does Zeplik change things in MotherDuck MCP without asking?
- No. Zeplik reads from MotherDuck MCP by default. Any action that changes data in MotherDuck MCP requires write access, which stays off until you enable it in Settings under Connectors.
- How much does connecting MotherDuck MCP cost?
- Connecting MotherDuck MCP is free. You only spend Zeplik credits when the assistant runs, and new accounts start with free credits.
Related ai utilities integrations
- MuAPIGenerate images and discover supported models through MuAPI's OpenAI-compatible API.
- NamSorNamSor classifies, parses, and enriches personal names to infer attributes such as gender, country of origin, ethnicity, and cultural context.
- NanonetsNanonets provides an AI-driven Intelligent Document Processing API that transforms unstructured documents into structured data, enabling efficient.
- Nanonets OCRNanonets OCR extracts structured data from documents using trained, model-based OCR workflows.
- NeedleNeedle provides retrieval-augmented generation (RAG) tools that enable semantic search across your data, facilitating the development of AI agents.
- NgramNgram creates AI-generated videos and images, manages rendering jobs, and delivers completion events through webhooks.
More on Zeplik
Connect MotherDuck MCP to your AI assistant
Every model, one chat. Bring MotherDuck MCP into Zeplik and let the assistant do the work.