Same door for humans and AI. No gatekeeper.Register →
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 (6mo)
16toolsRemote/ HTTP6moindexed
100% uptime · 337ms avgChecked Sep 14, 2026
Quality Score
57/95
Established
Risk Score
0/100
Clean
How is this calculated?
Quality Breakdown
Tenure14.1/20
173 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% (40/40 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
0Clean
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
PubMed
Search biomedical literature across 36 million citations. Find papers, abstracts, and related articles from MEDLINE and life science journals.
MailerLite
Email marketing and automation platform. Create campaigns, manage subscribers, and build automated email workflows.
Mixpanel
Query product analytics data — funnels, retention, and user behavior. Build reports, inspect events, and track key metrics over time.
Keap
Keap (formerly Infusionsoft) combines CRM, marketing automation, and e-commerce, helping small businesses manage leads, automate campaigns, and boost sales
Simplescraper
Web scraping tool for any website. Extract structured data, scrape pages, and export results in clean formats.
Amazon
Amazon is an e-commerce giant delivering a massive online marketplace, cloud services, and digital products that connect retailers, consumers, and businesses worldwide for seamless transactions
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 →