motherduckdb/agent-skills

36 resources in this repository

🎯36Skills

🎯Skills36

Guides execution of DuckDB SQL queries against MotherDuck databases, covering analytics, aggregations, CTEs, window functions, QUALIFY, and performance optimization with best practices for grain preservation and early filtering.

motherduck-query

🎯motherduck-build-dashboard🎯Skill

A skill that builds multi-section live analytics dashboards as MotherDuck Dives, composing KPI rows, trend charts, and breakdown views into a single saved and shareable workspace artifact backed by validated DuckDB SQL queries.

motherduck-build-dashboard

🎯motherduck-duckdb-sql🎯Skill

Part of the MotherDuck Skills Plugin — a three-layer skill catalog (utility, workflow, use-case) teaching AI agents how to connect, query, and build with MotherDuck and DuckDB SQL, including data loading, sharing, Dives, DuckLake, and production analytics patterns.

motherduck-duckdb-sql

🎯motherduck-security-governance🎯Skill

A skill that explains MotherDuck's security, governance, and access-control patterns for teams evaluating its compliance and deployment requirements, covering data residency, service accounts, isolation boundaries, sharing, and RBAC. Guides users through identifying credential locations, defining isolation scope, and validating security posture against publicly documented guarantees.

motherduck-security-governance

🎯motherduck-ducklake🎯Skill

Helps decide when DuckLake is the right storage pattern on MotherDuck instead of native storage, covering fully managed, BYOB, and own-compute modes along with data inlining, compaction, and object-storage layout considerations.

motherduck-ducklake

🎯motherduck-build-data-pipeline🎯Skill

Designs end-to-end MotherDuck data pipelines covering raw ingestion, staging, and analytics boundaries, with bulk ingestion paths, transformation sequencing, idempotent stage rebuilds, and DuckLake integration when needed.

motherduck-build-data-pipeline

🎯motherduck-enable-self-serve-analytics🎯Skill

Orchestrates self-serve analytics rollout on MotherDuck by guiding teams through dataset curation, Dive/share publishing, ownership boundaries, and governed access expansion from a first audience to broader adoption.

motherduck-enable-self-serve-analytics

🎯motherduck-build-cfa-app🎯Skill

Guides the design of MotherDuck-backed customer-facing analytics applications, handling tenant isolation, backend routing, service-account boundaries, read scaling, and Hypertenancy-style patterns for embedded or product analytics.

motherduck-build-cfa-app

🎯motherduck-share-data🎯Skill

Creates and manages MotherDuck data shares for zero-copy, read-only database distribution with configurable access control, visibility, and update modes for internal or external recipients.

motherduck-share-data

🎯motherduck-connect🎯Skill

Guides database connectivity setup to MotherDuck via the Postgres endpoint, native DuckDB API, or JDBC, covering connection strings, authentication, SSL configuration, and runtime selection for ad-hoc and pipeline workloads.

motherduck-connect

🎯motherduck-explore🎯Skill

A skill for discovering and exploring databases, tables, columns, and data shares in a MotherDuck account, including previewing table contents and understanding schemas before moving into analytical SQL or modeling work. It follows a top-down exploration workflow from databases to tables to columns to sample rows.

motherduck-explore

🎯motherduck-create-dive🎯Skill

A skill for creating, editing, managing, sharing, and embedding MotherDuck Dives — live React and SQL data applications built conversationally inside MotherDuck workspaces. It handles the full Dive lifecycle from authoring and local preview to team sharing, version history, and embedding.

motherduck-create-dive

🎯motherduck-load-data🎯Skill

Guides efficient data loading into MotherDuck from local files, object storage, HTTPS, dataframes, or external databases, with best practices for CTAS, bulk loading, secrets management, and Postgres-endpoint tradeoffs.

motherduck-load-data

🎯motherduck-model-data🎯Skill

A skill for designing and building database schemas and data models in MotherDuck, producing a file-based project scaffold organized into raw, staging, and analytics lifecycle stages along with a manifest defining the model DAG. Use it when creating tables, defining relationships, or restructuring data for analytical workloads.

motherduck-model-data

🎯motherduck-pricing-roi🎯Skill

A workflow skill that helps evaluate MotherDuck pricing and ROI tradeoffs by mapping workload shape to cost buckets, framing savings in terms of systems replaced and complexity removed, and verifying current plan details against the live pricing page.

motherduck-pricing-roi

🎯motherduck-partner-delivery🎯Skill

Provides a repeatable MotherDuck delivery pattern for consultancies and partners managing multiple clients, standardizing database isolation, provisioning, regional deployment, and sharing boundaries with client-specific exceptions.

motherduck-partner-delivery

🎯motherduck-migrate-to-motherduck🎯Skill

Plans and executes migrations from Snowflake, Redshift, PostgreSQL, or other analytics stacks onto MotherDuck, covering target pattern selection, cutover sequencing, source-vs-target validation, and rollback paths.

motherduck-migrate-to-motherduck

🎯motherduck-rest-api🎯Skill

Manages MotherDuck REST API control-plane operations including service-account provisioning, access-token lifecycle, Duckling instance configuration, active account inspection, and Dive embed sessions.

motherduck-rest-api

🎯motherduck-create-flight🎯Skill

Skill

motherduck-create-flight

🎯build-data-pipeline🎯Skill

Skill

Skill

Skill