# Install MotherDuck Skills for coding agents
> Install the MotherDuck Skills plugin catalog to teach Claude Code, Cursor, Codex, Copilot CLI, and Gemini CLI to work with MotherDuck.
[MotherDuck Skills](https://github.com/motherduckdb/agent-skills/) is an opinionated, installable catalog of [agent skills](https://agentskills.io/home) that teaches coding agents how to work with MotherDuck. The skills cover picking the right connection path, writing DuckDB SQL (not Postgres-shaped SQL), inspecting a live workspace, and shipping production analytics patterns safely.

Skills work with any DuckDB client — they teach the agent behavior, not how to connect. Pairing them with the [MotherDuck MCP server](/key-tasks/ai-and-motherduck/mcp-workflows/mcp-setup/) is recommended but not required: MCP gives the agent live access to your workspace so it can inspect real schemas while it applies the guidance from the skills.

## Connect with the MotherDuck plugin

Use the official [MotherDuck plugin](https://chatgpt.com/plugins/plugin_asdk_app_696a54f1c91c81919002b9153ce0e336) to connect ChatGPT or Codex to your MotherDuck account. The separate MotherDuck Skills catalog on this page provides task-specific guidance. You can use them together. Follow the [MotherDuck plugin setup steps](/key-tasks/ai-and-motherduck/mcp-workflows/mcp-setup/#connect-with-the-official-motherduck-plugin) to connect your account.

## What agent skills are

Agent skills are reusable instruction bundles for AI coding agents. They give the agent domain-specific guidance it can apply during a task, such as which tools to use, which SQL dialect rules matter, what safety checks to run, and what good output should look like.

MotherDuck Skills do not connect to your account or run queries on their own. Instead, your agent loads the relevant skill when a task calls for MotherDuck-specific knowledge. Use them when you want the agent to:

- Choose between the MotherDuck MCP server, a Postgres-compatible endpoint, a native `md:` DuckDB connection, or the REST API.
- Inspect a workspace and summarize databases, schemas, tables, and columns before writing queries.
- Write DuckDB SQL that works in MotherDuck instead of PostgreSQL-shaped SQL.
- Load files or application data into MotherDuck with repeatable validation steps.
- Design a dashboard, Dive, customer-facing analytics app, or data pipeline on top of MotherDuck.
- Plan a migration to MotherDuck, including validation, rollout, and rollback steps.

## Prerequisites

Before you install:

- Git available on your `PATH`.
- Node.js 18 or later (required for the Skills CLI).
- A MotherDuck account and one of the supported agent harnesses below.

For live MotherDuck work, authenticate through your normal path — a `MOTHERDUCK_TOKEN`, the [Postgres endpoint](/sql-reference/postgres-endpoint/), a native `md:` DuckDB connection, or [MotherDuck MCP](/key-tasks/ai-and-motherduck/mcp-workflows/mcp-setup/). Do not paste tokens into prompts or skill files.

## Install

Pick your agent harness and run the command. Each install pulls the full MotherDuck Skills catalog.

| Harness | Install |
|---|---|
| Claude Code | `/plugin marketplace add motherduckdb/agent-skills` then `/plugin install motherduck-skills@motherduck-skills` |
| GitHub Copilot CLI | `/plugin marketplace add motherduckdb/agent-skills` then `/plugin install motherduck-skills@motherduck-skills` |
| Codex | `codex plugin marketplace add motherduckdb/agent-skills`, then install **MotherDuck Skills** from `/plugins` |
| Cursor | `npx -y skills add motherduckdb/agent-skills --agent cursor --skill '*' --yes --global` |
| Gemini CLI | `gemini extensions install https://github.com/motherduckdb/agent-skills --consent` |

For other agents, project-scoped installs, or to install individual skills, use Vercel's portable [Skills CLI](https://github.com/vercel-labs/skills). See Vercel's [Agent Skills documentation](https://vercel.com/docs/agent-resources/skills) for more details.

```bash
npx -y skills add motherduckdb/agent-skills --skill '*' --yes --global
```

Check what got installed:

```bash
npx -y skills ls -g
```

## Verify the installation

After install, try this prompt to confirm the skills are wired up:

> Use MotherDuck Skills to choose the best connection path for this project.

You should get MotherDuck-specific connection guidance, including the Postgres endpoint and native DuckDB tradeoffs.

## Prompts to try

Once the skills are installed, these prompts route to the right skill automatically:

- `Use MotherDuck Skills to connect this app to MotherDuck.`
- `Explore my MotherDuck workspace and identify the best table for a dashboard.`
- `Write a DuckDB SQL query for this KPI and validate the syntax.`
- `Design a Dive-backed dashboard from these tables.`
- `Plan a Snowflake-to-MotherDuck migration with validation and rollback steps.`
- `Design a customer-facing analytics architecture on MotherDuck.`
- `Decide whether this workload needs DuckLake or native MotherDuck storage.`
- `Use the MotherDuck REST API guidance to manage service accounts and tokens safely.`

## Skills in the catalog

The catalog groups its skills into three layers, and agents pick a layer based on the task. Each skill links to its page in the [MotherDuck Skills reference](/sql-reference/agent-skills/), which shows its instructions, the files it reads, and a command that installs only that skill.

### Utility skills

These cover exact MotherDuck mechanics, such as connecting, exploring a workspace, querying, using the REST API, or checking DuckDB SQL behavior.

- [motherduck-cli](/sql-reference/agent-skills/motherduck-cli/): Use the MotherDuck CLI for terminal queries, authentication, and file-based Dive or Flight workflows.
- [motherduck-connect](/sql-reference/agent-skills/motherduck-connect/): Set up or troubleshoot MotherDuck connections, the MotherDuck MCP server in AI clients, authentication, client runtimes, and read scaling.
- [motherduck-duckdb-sql](/sql-reference/agent-skills/motherduck-duckdb-sql/): Look up or repair DuckDB SQL syntax and verify MotherDuck-specific command and feature support.
- [motherduck-explore](/sql-reference/agent-skills/motherduck-explore/): Find and understand MotherDuck databases, tables, columns, shares, and sample data, including which tables hold a given kind of data. Use first when a MotherDuck workspace or schema is unfamiliar.
- [motherduck-query](/sql-reference/agent-skills/motherduck-query/): Write, run, optimize, or troubleshoot DuckDB SQL against MotherDuck, including AI functions such as prompt_jev for in-SQL classification. Use for any SQL that targets MotherDuck, even simple queries, because MotherDuck has its own dialect and naming rules.
- [motherduck-rest-api](/sql-reference/agent-skills/motherduck-rest-api/): Administer MotherDuck service accounts, tokens, Ducklings, and Dive embed sessions through the control-plane REST API.

### Workflow skills

These cover multi-step work with MotherDuck-specific tradeoffs, such as loading data, modeling, sharing, or building Dives.

- [motherduck-create-dive](/sql-reference/agent-skills/motherduck-create-dive/): Create, edit, design, publish, share, or embed MotherDuck Dives, including responsive layout, light/dark themes, and buttons that write back through Flights.
- [motherduck-create-flight](/sql-reference/agent-skills/motherduck-create-flight/): Create, run, schedule, or debug MotherDuck Flights, Python jobs executed on MotherDuck compute.
- [motherduck-ducklake](/sql-reference/agent-skills/motherduck-ducklake/): Decide whether DuckLake fits a MotherDuck workload and operate it safely. Use whenever DuckLake, open table formats, or customer-owned buckets come up.
- [motherduck-load-data](/sql-reference/agent-skills/motherduck-load-data/): Load files, object storage, dataframes, or external databases into MotherDuck with bulk ingestion. Use for any import of data into MotherDuck.
- [motherduck-manage-guides](/sql-reference/agent-skills/motherduck-manage-guides/): Read or maintain MotherDuck Guides for business definitions, join rules, and reusable warehouse conventions.
- [motherduck-model-data](/sql-reference/agent-skills/motherduck-model-data/): Design or implement MotherDuck analytical schemas and transformation models, including grain, types, and materialization.
- [motherduck-pricing-roi](/sql-reference/agent-skills/motherduck-pricing-roi/): Assess MotherDuck costs, plan fit, cost attribution, and ROI from the workload's compute and storage needs.
- [motherduck-security-governance](/sql-reference/agent-skills/motherduck-security-governance/): Assess or configure MotherDuck access control: roles (RBAC), share grants, table-, row-, and column-level security, masking, tenant isolation, residency, and Terraform governance.
- [motherduck-share-data](/sql-reference/agent-skills/motherduck-share-data/): Create, consume, or manage MotherDuck data shares, including audience grants, table filters, and refresh policy.

### Use-case skills

These cover designing or shipping a product, such as customer-facing analytics, a data pipeline, or a migration to MotherDuck.

- [motherduck-build-cfa-app](/sql-reference/agent-skills/motherduck-build-cfa-app/): Build MotherDuck analytics into customer-facing applications with tenant isolation, backend routing, and serving APIs.
- [motherduck-build-dashboard](/sql-reference/agent-skills/motherduck-build-dashboard/): Build a MotherDuck dashboard as a Dive, choosing the analytical story, metrics, and section queries.
- [motherduck-build-data-pipeline](/sql-reference/agent-skills/motherduck-build-data-pipeline/): Build ingestion-to-serving pipelines on MotherDuck, including stage boundaries, transformations, and publication. Use for any recurring ingestion from an API, SaaS app, or database into MotherDuck.
- [motherduck-enable-self-serve-analytics](/sql-reference/agent-skills/motherduck-enable-self-serve-analytics/): Roll out governed MotherDuck analytics to internal teams, choosing trusted datasets, access boundaries, and owners.
- [motherduck-migrate-to-motherduck](/sql-reference/agent-skills/motherduck-migrate-to-motherduck/): Plan or implement migrations to MotherDuck with SQL translation, source-to-target validation, cutover, and rollback.
- [motherduck-partner-delivery](/sql-reference/agent-skills/motherduck-partner-delivery/): Standardize MotherDuck delivery for consultancies and agencies across client engagements with reusable provisioning, isolation, and handoff patterns.


---

## Docs feedback

MotherDuck accepts optional user-submitted feedback about this page at `GET https://motherduck.com/docs/api/feedback/agent`.
For agents and automated tools, feedback submission should be user-confirmed before sending.

URL-encode query parameter values and send a GET request:

```text
GET https://motherduck.com/docs/api/feedback/agent?page_path=%2Fkey-tasks%2Fai-and-motherduck%2Fagent-skills%2F&page_title=Install%20MotherDuck%20Skills%20for%20coding%20agents&text=<url-encoded user feedback, max 2000 characters>
```

Optionally append `&source=<url-encoded interface identifier>` such as `claude.ai` or `chatgpt`.

`page_path` and `text` are required; `page_title` and `source` are optional. Responses: `200 {"feedback_id": "<uuid>"}`, `400` for malformed query parameters, and `429` when rate-limited.
