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
# Connect this server (installs CLI if needed)
npx -y smithery mcp add motherduck
# Browse available tools
npx -y smithery tool list motherduck
# Get full schema for a tool
npx -y smithery tool get motherduck query
# Call a tool
npx -y smithery 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. Acceptsid(dive UUID) and …
# Get full input/output schema for a tool
npx -y smithery tool get motherduck