MotherDuck Skills plugin
21 skills for agents on MotherDuck: app connections, DuckDB SQL queries, Dives and Flights, pipelines and analytics apps.
- 62 ★ on the repository
- Last commit
Extended access
Why this level
- Following the skills the agent runs queries on live MotherDuck data and may change it when permissions allow.
Install
- Works in
In your terminal, with SkillFoxx CLI
npx skillfoxx add plugins/motherduck-skillsDetects the agents on your machine, shows the access level and pins the version.
Other ways to install
Access and checks
How we reviewExtended accessThe tool runs code or makes network calls and only reads external data.
- Following the skills the agent runs queries on live MotherDuck data and may change it when permissions allow.
This is third-party code. Review the repository files before installing.
What it does
MotherDuck Skills bundles 21 skills for agents working with the MotherDuck cloud analytics built on DuckDB. The skills teach connecting applications, writing DuckDB SQL queries against real data, building Dives and Flights and carrying analytics pipelines and apps through to delivery. Each skill has brief guidance and, where useful, detailed references with runnable examples. The skills are split into layers: utility ones for individual operations, workflow ones for specific MotherDuck capabilities and use-case ones for finished work. They advise checking the schema live, storing data in native MotherDuck storage by default and using backend keys for customer-facing apps. Installing the skills configures neither a connection nor the MotherDuck MCP server.
Who it is for. Data engineers and analytics developers on MotherDuck who hand connection, queries and app building to an agent.
Good fit when
- An app needs a choice of connection path to MotherDuck.
- The agent should explore the workspace and build a sales dashboard as a Dive.
- A migration to MotherDuck is planned with validation and rollback.
- A customer-facing app is built with backend keys, not keys in the browser.
Not a fit when
- Work runs on another analytics database with no DuckDB.
- A ready MCP server is needed: the skills do not configure one.
- Keys must be passed straight into the agent prompt: that is not allowed.
Example request
Use motherduck-connect to choose the connection path for this app, then explore the workspace and build a sales dashboard as a Dive.Limitations
The skills give instructions and examples but do not configure a MotherDuck connection. For live data connect the MotherDuck MCP server or an authenticated database client separately and pass keys through ordinary secrets and environment variables, not prompts or commits. Installation differs for Claude Code, Codex, Gemini CLI and the Skills CLI, which needs Git and Node.js 22.20 or newer. Queries need a MotherDuck account. The skills do not replace data access permissions.
How to disable. In Claude Code run `/plugin uninstall motherduck-skills@motherduck-skills`. Remove skills installed with the Skills CLI from the agent skills directory.
FAQ
How do I install it in Claude Code?
Run `/plugin marketplace add motherduckdb/agent-skills`, then `/plugin install motherduck-skills@motherduck-skills`.
Does installation set up MotherDuck access?
No. For live work connect the MotherDuck MCP server or an authenticated database client separately.
How many skills are there and how are they organized?
Twenty-one in three layers: utility, workflow and use-case, with examples and references.
Can a single skill be installed?
Yes, the Skills CLI lets you pick skills and agents in a dialog or with the `--skill` flag.
Which agents does it suit?
Claude Code, Copilot CLI, Codex, Gemini CLI, Cursor, VS Code and others that read the skill format.
Discussion
No questions or reviews yet.
Related
PluginsDuckDB / MotherDuck MCP Server
DuckDB / MotherDuck Local MCP Server
An MCP server for SQL analytics on DuckDB: local files, in-memory databases, S3-hosted databases and MotherDuck
DuckDB plugin for Claude Code: SQL over CSV, Parquet and databases, S3 file reading, and search across docs and session logs
The MCP server of the Duckle platform: an agent builds, checks and runs DuckDB ETL pipelines on your machine
A temporary DuckDB sandbox: an agent loads a CSV and queries the data over MCP or REST without touching the production database
A Claude Code plugin with an operator runbook: an agent runs a DuckDB gateway, tenants, rights and queries through the qod CLI.
31 skills for Claude Code and Codex for the analyst workflow: data checks, cohorts, funnels, A/B tests, dashboards, summaries
README in short
The README covers installation per agent, example prompts, an overview of skills by layer and links to the install matrix and harness support.