motherduck-skills

MotherDuck Skills Plugin

MotherDuck Skills is an installable skill catalog that teaches coding agents to work with MotherDuck: choose the right connection path, inspect the live workspace, write DuckDB SQL instead of PostgreSQL-shaped SQL, use Dives and shares, and keep production analytics patterns safe.

18 skills in three layers: utility (connect, explore, query, SQL syntax, REST API), workflow (load, model, share, Dives, DuckLake, security, pricing), and use-case (apps, dashboards, pipelines, migrations, rollouts). See the full catalog.

Quick Install

Pick your harness and paste:

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
Anything else	npx -y skills add motherduckdb/agent-skills --skill '*' --yes --global

Requirements: Git on your PATH, and Node.js 18+ for the Skills CLI route. For live MotherDuck work, authenticate through your normal path (MOTHERDUCK_TOKEN, Postgres endpoint credentials, a native md: DuckDB connection, or MotherDuck MCP) — never paste tokens into prompts or skill files.

Done? Jump to Verify the Installation. Per-harness details and alternatives are below.

Install Details by Harness

Skills CLI

The most portable path for Cursor, VS Code/GitHub Copilot, Codex, Claude Code, custom agents, and project-level installs:

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

Default to a global (--global) install so the skills are available across all projects; drop the flag for a project-scoped install.

Check what got installed:

npx -y skills ls -g
npx -y skills ls -g -a cursor
npx -y skills ls -g -a github-copilot

GitHub Copilot CLI

Use the plugin path when you want the full MotherDuck bundle available inside Copilot CLI.

Inside a Copilot CLI session, add the marketplace the first time:

/plugin marketplace add motherduckdb/agent-skills

Install the plugin:

/plugin install motherduck-skills@motherduck-skills

Update later:

/plugin update motherduck-skills@motherduck-skills

This repository exposes the Copilot-compatible marketplace through .claude-plugin/marketplace.json; Copilot CLI also looks in .claude-plugin/ for plugin marketplaces.

For VS Code agent mode or Copilot cloud agent skills, use a skills install rather than the Copilot CLI plugin install:

npx -y skills add motherduckdb/agent-skills --agent github-copilot --skill '*' --yes --global

GitHub CLI also has a native gh skill flow. It is useful when you want to inspect and install one skill at a time:

gh skill preview motherduckdb/agent-skills motherduck-connect
gh skill install motherduckdb/agent-skills motherduck-connect --agent github-copilot --scope user

To browse the catalog interactively:

gh skill install motherduckdb/agent-skills

GitHub's gh skill support is in public preview, so prefer the Skills CLI for a repeatable "install everything" command.

Copilot skill locations to know:

Scope	Common locations
Project skills	.github/skills, .claude/skills, .agents/skills
Personal skills	~/.copilot/skills, ~/.agents/skills

Claude Code

Add the marketplace the first time:

/plugin marketplace add motherduckdb/agent-skills

Install the plugin:

/plugin install motherduck-skills@motherduck-skills

Update later:

/plugin update motherduck-skills@motherduck-skills

For local plugin development and validation:

claude --plugin-dir ./plugins/motherduck-skills-claude

Codex

Add the marketplace:

codex plugin marketplace add motherduckdb/agent-skills

Then open /plugins in Codex and install MotherDuck Skills from the repo marketplace.

Enable or disable individual skills from /skills after the plugin is installed.

Cursor