# MotherDuck (verified)

Query and analyze data with DuckDB in the cloud. Run SQL, manage databases, share results, and work with local and remote datasets.

## Quick Start

```bash
# Connect this server (installs CLI if needed)
npx -y @smithery/cli@latest mcp add motherduck

# Browse available tools
npx -y @smithery/cli@latest tool list motherduck

# Get full schema for a tool
npx -y @smithery/cli@latest tool get motherduck query

# Call a tool
npx -y @smithery/cli@latest tool call motherduck query '{}'
```

## Direct MCP Connection

Endpoint: `https://motherduck.run.tools`

## Tools (16)

- `query` — Execute read-only DuckDB query against MotherDuck databases. For cross-database queries, use fully qualified names: dat…
- `query_rw` — Execute a DuckDB SQL query that modifies data, schema, or connection state.
- `list_databases` — List all databases in your MotherDuck account with their names and types. Optionally filter by keywords to search in da…
- `list_tables` — List all tables and views in a MotherDuck database with their comments. Optionally filter by keywords to search in tabl…
- `list_columns` — List all columns of a table or view with their types and comments.
- `search_catalog` — Search the catalog for databases, schemas, tables, columns, shares using fuzzy matching. Returns matching objects with …
- `ask_docs_question` — Ask a question about DuckDB or MotherDuck. Returns answers from official documentation.
- `list_shares` — List all database shares that have been shared with you. Returns share names and URLs. To attach a share, use the query…
- `list_dives` — List all dives in MotherDuck. Dives are interactive React data apps that query live data. Returns metadata including cu…
- `save_dive` — Save a new dive to MotherDuck. Returns a URL the user can click to view the dive. Call get_dive_guide first and iterate…
- `update_dive` — Update an existing dive's title, description, or content. Returns a URL the user can click to view the updated dive. At…
- `read_dive` — Read a specific dive by ID, including its full JSX/React component code. Optionally specify a version number to retriev…
- `delete_dive` — Delete a dive by ID. This action is permanent and cannot be undone.
- `get_dive_guide` — Load instructions for creating MotherDuck dives. You MUST call this tool first — before generating any chart, visualiza…
- `share_dive_data` — Share the data for a dive with your organization. Creates org-scoped shares for owned databases used in the dive, and u…
- `edit_dive_content` — Edit a dive's content by applying one or more text replacements, then save to MotherDuck. Accepts `id` (dive UUID) and …

```bash
# Get full input/output schema for a tool
npx -y @smithery/cli@latest tool get motherduck <tool-name>
```