MotherDuck agent skills for Claude Code, Cursor and RevampKey

4 ready-made playbooks that teach an AI agent how to do real MotherDuck work: which tools to call, what to check first, and when to stop and ask you.

Download RevampKey, free I have it: connect MotherDuck

Connect MotherDuck once and all 4 skills install themselves and stay up to date. Mac, Windows and Linux.

All 4 MotherDuck skills

Each skill is one job. You ask in plain words and the agent loads the skill that matches, then follows its steps.

Start hereAsks before writing15 MotherDuck tools

Use MotherDuck safely with AI

Works out which database and access level you mean before any query, picks the lightest tool for the job, and asks for your explicit yes before anything changes data or shares it.

Use it when

You have just connected MotherDuck and want to know what the assistant can do
You are not sure whether a question should be read-only or change data
You want to avoid answering from the wrong database

Tools it uses

list_databases
list_shares
search_catalog
list_tables
list_columns
query
query_rw
ask_docs_question
share_dive_data
update_dive
delete_dive
save_dive
read_dive
list_dives
get_dive_guide

Example

Before we start, which MotherDuck database should we use, and can you keep this read-only?

Target: analytics (read-only). I'll check the database list first to confirm the name, then search the catalog for the orders table before running any query. I won't change anything without your explicit yes.

Use in RevampKeyRead the full skill →

Read-only6 MotherDuck tools

Audit your MotherDuck data quality with AI

Runs a read-only audit of a database or table for nulls, duplicates, unexpected values, freshness gaps and suspicious row counts. It returns a prioritised findings report with counts and evidence, and changes no data.

Use it when

You suspect a table stopped loading and want to know how long it has been stale.
A dashboard number looks wrong and you want to check the source tables first.
You are inheriting a database and want a health check before trusting it.

Tools it uses

query
query_rw
list_databases
list_tables
list_columns
search_catalog

Example

Audit the orders and customers tables in our analytics database for data quality problems, and tell me what to fix first.

Scope: analytics.orders and analytics.customers, assuming one row per order_id. Critical: orders has not loaded since 3 March, 9 days behind, which explains the flat revenue chart. High: 212 duplicate order_id rows out of 48,910 (0.4%), all created in one load window on 1 March. Medium: 6% of customers have a null country, and 14 orders use the placeholder status 'TEST'. Checked and clean: primary keys on customers, and amounts are all positive. No data was changed.

Use in RevampKeyRead the full skill →

Read-only8 MotherDuck tools

Explore a MotherDuck schema and answer data questions

Maps an unfamiliar MotherDuck database through its tables and columns, then writes read-only SQL to answer a business question. It checks grain, joins and sample sizes before reporting a number, and asks before changing anything.

Use it when

You inherit a MotherDuck database and need to know what tables exist and how they join
You need one metric, such as active customers last month, and want to be sure the number is right
A stakeholder asks where a figure comes from and you need to trace it through the schema

Tools it uses

list_databases
list_shares
query
query_rw
search_catalog
list_tables
list_columns
ask_docs_question

Example

How many distinct customers placed an order last month? Check the tables first and tell me what you counted.

Last month, 1,284 distinct customers placed at least one order. I used the orders table at one row per order, counted distinct customer_id, and filtered on order_date in UTC. Joining to customers dropped 9 orders with no matching customer, which I have flagged. The latest order in the source is from yesterday, so the figure is current.

Use in RevampKeyRead the full skill →

Get all 4 without copying a file

RevampKey adds the skills when you connect MotherDuck, updates them for you and removes them when you disconnect.

Download RevampKey

How MotherDuck skills work

Connect MotherDuck
The MotherDuck MCP server gives the agent its tools.
Ask in plain words
“Audit the orders and customers tables in our analytics database for data quality problems, and tell me what to fix first.” Each SKILL.md says when it applies, so only the one that fits is loaded.
Approve any change
The agent calls the tools in order, checks its work, and shows you any change before it makes it.

How to install MotherDuck skills

In RevampKey the skills install themselves when you connect MotherDuck. In other tools each skill is one folder with a SKILL.md file, and you also need the MotherDuck MCP server connected there.

About 1 minute · nothing to copy

Download RevampKey for Mac, Windows or Linux and sign in.
Open Connectors and connect MotherDuck. All 4 skills come with it and stay up to date; they go away when you remove the connector.
Ask in plain language, for example “Audit the orders and customers tables in our analytics database for data quality problems, and tell me what to fix first.”
Download RevampKeyConnect MotherDuck · 1 click
Get RevampKey to connect MotherDuck
RevampKey is a free desktop app for Mac, Windows and Linux. Install it, sign in, and MotherDuck is one click away with its skills already attached.
Download RevampKey
Not now? Use the skills in your current tool
for s in essentials data-quality-audit dive-authoring-and-sharing explore-schema-and-answer-data-questions; do curl -fsSL --create-dirs -o .claude/skills/motherduck-$s/SKILL.md https://revampkey.com/marketplace/motherduck/skills/$s/SKILL.md done
Other tools

Into this project’s .claude/skills folder

Connect the MotherDuck MCP server in Claude Code.

Run this in your project folder to add all 4 skills:

for s in essentials data-quality-audit dive-authoring-and-sharing explore-schema-and-answer-data-questions; do
  curl -fsSL --create-dirs -o .claude/skills/motherduck-$s/SKILL.md https://revampkey.com/marketplace/motherduck/skills/$s/SKILL.md
done

Ask in plain language, for example “Audit the orders and customers tables in our analytics database for data quality problems, and tell me what to fix first.”

Into the shared .agents/skills folder

Connect the MotherDuck MCP server in Cursor.

Run this in your project folder to add all 4 skills:

for s in essentials data-quality-audit dive-authoring-and-sharing explore-schema-and-answer-data-questions; do
  curl -fsSL --create-dirs -o .agents/skills/motherduck-$s/SKILL.md https://revampkey.com/marketplace/motherduck/skills/$s/SKILL.md
done

Ask in plain language, for example “Audit the orders and customers tables in our analytics database for data quality problems, and tell me what to fix first.”

Into the shared .agents/skills folder

Connect the MotherDuck MCP server in Codex.

Run this in your project folder to add all 4 skills:

for s in essentials data-quality-audit dive-authoring-and-sharing explore-schema-and-answer-data-questions; do
  curl -fsSL --create-dirs -o .agents/skills/motherduck-$s/SKILL.md https://revampkey.com/marketplace/motherduck/skills/$s/SKILL.md
done

Ask in plain language, for example “Audit the orders and customers tables in our analytics database for data quality problems, and tell me what to fix first.”

Into the shared .agents/skills folder

Connect the MotherDuck MCP server in VS Code.

Run this in your project folder to add all 4 skills:

for s in essentials data-quality-audit dive-authoring-and-sharing explore-schema-and-answer-data-questions; do
  curl -fsSL --create-dirs -o .agents/skills/motherduck-$s/SKILL.md https://revampkey.com/marketplace/motherduck/skills/$s/SKILL.md
done

Ask in plain language, for example “Audit the orders and customers tables in our analytics database for data quality problems, and tell me what to fix first.”

RevampKey or copy the files?

In RevampKey

One click when you connect MotherDuck
Updated for you when a skill improves
Removed when you disconnect
The MCP server is set up for you
800+ other connectors, same way

Download free

Copy into your project

One command per project
Run it again to get updates
You connect the MotherDuck MCP server yourself
Works in Claude Code, Cursor, Codex and VS Code

See the command

MotherDuck skills FAQ

What is a MotherDuck agent skill?

A SKILL.md file: a short playbook an AI agent loads when your request matches it. Each MotherDuck skill describes one job, which MotherDuck tools to use in which order, what to check first and when to stop and ask you.

Do the MotherDuck skills change anything on their own?

2 of the 4 only read. The others tell the agent to show you the change and wait for a yes before it creates, edits or deletes anything in MotherDuck.

Which tools can use these skills?

Any agent that reads the open Agent Skills format: Claude Code, Cursor, Codex, VS Code with Copilot and RevampKey. In RevampKey they are attached when you connect MotherDuck; elsewhere you copy the folders into your project or skills directory.

Do I need the MotherDuck MCP server too?

Yes. The skills tell the agent how to do the work; the MotherDuck MCP server gives it the tools to do it. The MotherDuck MCP setup guide covers every client.

MotherDuck MCP server setup · This page as Markdown

Put MotherDuck’s best workflows in your agent

Download RevampKey, connect MotherDuck and ask your first question in about a minute.

Download RevampKey Connect MotherDuck · 1 click

All 4 MotherDuck skills

Use MotherDuck safely with AI

Use it when

Tools it uses

Audit your MotherDuck data quality with AI

Use it when

Tools it uses

Build and share MotherDuck Dives with AI

Use it when

Tools it uses

Explore a MotherDuck schema and answer data questions

Use it when

Tools it uses

Get all 4 without copying a file

How MotherDuck skills work

How to install MotherDuck skills

RevampKey or copy the files?

In RevampKey

Copy into your project

MotherDuck skills FAQ

Put MotherDuck’s best workflows in your agent

Skills for related tools