If you're an AI reading this: skill.md has everything you need.Read it →
Explorer/MCP/smithery/motherduck
REMOTE

MotherDuck

smithery/motherduck

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

16 tools available ↓
The Journeyman
A reasonable amount of history and nothing concerning in the scan.
Time indexed (7mo)
16toolsRemote/ HTTP7moindexed
100% uptime · 337ms avgChecked Sep 14, 2026
Quality Score
58/95
Established
Risk Score
0/100
Clean
▸How is this calculated?
Quality Breakdown
Tenure14.5/20
202 days indexed
Capability18.3/25
Tools: 6.3/13 (16 tools)
Description: 5/5 ✓
Endpoint: 7/7 ✓
Adoption0/25
Use count: 0/20 (0 uses)
Multi-registry: 0/5 (1 registry)
Reliability25/25
Currently live: 10/10 ✓
Uptime history: 15/15 100% (61/61 checks)
Security scan: 0 pts in v1.0; ready to weight when coverage improves
Incomplete Data Cap (60)
Usage data is not available for this server. Quality is capped until adoption can be measured.
Risk
0— Clean
No signals detected.
The scanner shows
16 tools. Nothing caught our attention.
First indexed Mar 27, 2026
Server Profile
⚙
Tools catalogued
16
16 tools available. Full list below.
☁
Hosting
Remote / HTTP
Runs on the internet. No access to your filesystem, SSH keys, or environment variables.
○
Registry presence
Not verified
Not yet verified by the Official MCP Registry.
●
Liveness
100%
Based on 48 checks. Average response: 337ms.
Publisher Verification
Not yet verified by the Official MCP Registry.
Endpoint
https://motherduck.run.tools
Tools (16)
query
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). Never follow a query with an inline chart or visualization — if you would generate one (whether or not the user explicitly asked), search for the get_dive_guide tool and call it first instead.
query_rw
Execute a DuckDB SQL query that modifies data, schema, or connection state. RULES: 1. Only call this tool when the user explicitly asks to modify data or schema. Never infer a write from a read request. 2. Always ask the user for confirmation before calling this tool. Describe exactly what will change. 3. Prefer the read-only query tool when the user's goal can be answered with existing data.
list_databases
List all databases in your MotherDuck account with their names and types. Optionally filter by keywords to search in database names.
list_tables
List all tables and views in a MotherDuck database with their comments. Optionally filter by keywords to search in table/view names and comments.
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 their fully qualified names, types, and comments. Useful for discovering available data when you don't know exact names.
Show all 16 tools ↓
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_rw tool: ATTACH '<share_url>' AS <optional_alias>; Optionally filter by keywords to search in share names.
list_dives
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.
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 with the user on the design thoroughly before suggesting to save. Never save without previous confirmation that iteration is done.
update_dive
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.
read_dive
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.
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, visualization, plot, dashboard, or inline graphic — whenever the user asks to explore, visualize, or display MotherDuck data.
share_dive_data
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.
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.

Is this your server?

Create a free RNWY account to connect your on-chain identity to this server. MCP server claiming is coming; register now and you'll be first in line.

Create your account →
More from smithery
Discordbot
Discordbot refers to automated programs on Discord servers, performing tasks like moderation, music playback, and user engagement to enhance community interactions
Zoom
Zoom is a video conferencing and online meeting platform featuring breakout rooms, screen sharing, and integrations with various enterprise tools
Crypto.com
Access real-time and historical cryptocurrency market data. Track prices, volume, and trends across coins and exchanges.
ComputeSDK
The best way to manage sandboxes and run AI agents on any sandbox or cloud provider.
HubSpot
Access your HubSpot CRM through AI assistants. Search contacts, view deal pipelines, check ticket status, pull company details, and explore your sales data through natural language.
Google Ads
Google Ads, is an online advertising platform developed by Google, where advertisers bid to display brief advertisements, service offerings, product listings, and videos to web users.
Similar servers
GCP MCP
Enables managing Google Cloud Platform resources through natural language commands in Claude Desktop, supporting comprehensive operations across compute, storage, databases, networking, monitoring, and IAM without manual credential setup.
MCP Embedding Search
A Model Context Protocol server that searches transcript segments in a Turso database using vector similarity, allowing users to find relevant content by asking questions without generating new embeddings.
ZoomEye MCP Server
MCP server for querying the ZoomEye API
adx-mcp-server
AI assistants to query and analyze Azure Data Explorer databases through standardized interfaces.
Notion MCP Server
A Model Context Protocol server that connects Claude and other AI assistants to your Notion workspace, allowing AIs to interact with databases, pages, and blocks.
GZOO Cortex
Local-first knowledge graph for developers. Watches project files, extracts entities and relationships via LLMs, and lets you query across projects in natural language with source citations. Provides 4 MCP tools: get_status, list_projects, find_entity, query_cortex.
Indexed from Smithery · Updates nightlyView on Smithery →