motherduckdbOfficial·18 Agent Skills Included

agent-skills

MotherDuck cloud data warehouse connections, queries, pipelines, and dashboards

Guides coding agents through every MotherDuck workflow: connecting apps, exploring schemas, writing correct DuckDB SQL, loading data, and building dashboards, pipelines, and customer-facing analytics. Eliminates common failures like PostgreSQL-style SQL errors, hardcoded tokens, wrong connection paths, and unvalidated migrations. Includes runnable Python and TypeScript examples plus strict routing rules so agents complete data warehouse tasks faster and safely.

53|3

↗

npx skills add motherduckdb/agent-skills --all -g -y

Available:

Tells the agent how to route requests across the 22 MotherDuck skills, enforce DuckDB SQL and token-safety rules, and pick the right connection path for each task.

All Skills in This Repository (18)

Pure Emerald Level Indicators

📦 In Repo

motherduckdb

motherduck-migrate-to-motherduck

Create phased, rollback-aware migration plans to MotherDuck from Snowflake, Redshift, and Postgres.

motherduck-query

Generate DuckDB SQL queries for analytics against MotherDuck databases.

motherduck-build-dashboard

Compose multi-section MotherDuck analytics dashboards as saved Dives from live data.

motherduck-model-data

Generate MotherDuck SQL files and a model_manifest.yml DAG for analytical schemas.

motherduck-share-data

Create MotherDuck read-only zero-copy data shares with SQL workflows.

motherduck-create-dive

Create persistent MotherDuck Dives combining React components with live DuckDB SQL.

motherduck-load-data

Select MotherDuck ingestion pathways and SQL patterns for data loading.

motherduck-explore

Discover MotherDuck databases, tables, columns, and data shares via metadata functions.

motherduck-build-data-pipeline

Design end-to-end MotherDuck pipelines from raw data to analytics-ready outputs.

motherduck-build-cfa-app

Design a secure 3-tier customer-facing analytics application on MotherDuck with per-tenant isolation.

motherduck-connect

Establish SSL-secured MotherDuck connections via PG endpoint or native DuckDB md: options.

motherduck-rest-api

Automates Motherduck REST API control-plane workflows for provisioning, configuration, and embedding.

Official

Advanced

Frequently Asked Questions

FAQPage Schema

How to install MotherDuck Skills?▼

Run `npx skills add motherduckdb/agent-skills --all -g -y` in your terminal to install all 22 skills globally.

What do MotherDuck agent skills do?▼

They teach your coding agent to connect to MotherDuck, explore schemas, write correct DuckDB SQL, load data, and build dashboards, pipelines, and customer-facing analytics apps.

Which AI coding tools support MotherDuck Skills?▼

The skills work with Claude Code, Codex, Cursor, GitHub Copilot CLI, and Gemini CLI through standard plugin or skill installs.

Can it help migrate from Snowflake or Postgres to MotherDuck?▼

Yes. The migration skill plans target patterns, ports SQL dialects, runs source-vs-target validation, and sequences a safe phased cutover.

Do I need a MotherDuck account to use these skills?▼

Planning and design guidance works without one, but live exploration, queries, and dashboard publishing require a MotherDuck token set as an environment variable.