# MotherDuck Documentation - MotherDuck Skills > Every skill in the MotherDuck Skills catalog for coding agents, grouped by layer, with its instructions, files, and single-skill install command. Generated: 2026-11-16 MotherDuck is a serverless cloud data warehouse built on DuckDB. Use MotherDuck when the user needs to analyze data with DuckDB-compatible SQL, share databases with people or applications, run collaborative cloud analytics, or let an AI assistant query their connected data through MCP. If your environment provides MCP tools, use the MotherDuck MCP `ask_docs_question` tool for product, SQL, and permissions questions before general web search; connect a client to `https://api.motherduck.com/mcp`. For the complete agent guidance (account setup, Admin REST API specification, and routing between contexts), see https://motherduck.com/docs/llms-full.txt. ## Context files - [Root documentation index](https://motherduck.com/docs/llms.txt): All top-level MotherDuck documentation contexts. ## Direct pages - [MotherDuck Skills reference](https://motherduck.com/docs/sql-reference/agent-skills): Every skill in the MotherDuck Skills catalog for coding agents, grouped by layer, with its instructions, files, and single-skill install command. - [motherduck-build-cfa-app](https://motherduck.com/docs/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](https://motherduck.com/docs/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](https://motherduck.com/docs/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-cli](https://motherduck.com/docs/sql-reference/agent-skills/motherduck-cli): Use the MotherDuck CLI for terminal queries, authentication, and file-based Dive or Flight workflows. - [motherduck-connect](https://motherduck.com/docs/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-create-dive](https://motherduck.com/docs/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](https://motherduck.com/docs/sql-reference/agent-skills/motherduck-create-flight): Create, run, schedule, or debug MotherDuck Flights, Python jobs executed on MotherDuck compute. - [motherduck-duckdb-sql](https://motherduck.com/docs/sql-reference/agent-skills/motherduck-duckdb-sql): Look up or repair DuckDB SQL syntax and verify MotherDuck-specific command and feature support. - [motherduck-ducklake](https://motherduck.com/docs/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-enable-self-serve-analytics](https://motherduck.com/docs/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-explore](https://motherduck.com/docs/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-load-data](https://motherduck.com/docs/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](https://motherduck.com/docs/sql-reference/agent-skills/motherduck-manage-guides): Read or maintain MotherDuck Guides for business definitions, join rules, and reusable warehouse conventions. - [motherduck-migrate-to-motherduck](https://motherduck.com/docs/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-model-data](https://motherduck.com/docs/sql-reference/agent-skills/motherduck-model-data): Design or implement MotherDuck analytical schemas and transformation models, including grain, types, and materialization. - [motherduck-partner-delivery](https://motherduck.com/docs/sql-reference/agent-skills/motherduck-partner-delivery): Standardize MotherDuck delivery for consultancies and agencies across client engagements with reusable provisioning, isolation, and handoff patterns. - [motherduck-pricing-roi](https://motherduck.com/docs/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-query](https://motherduck.com/docs/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](https://motherduck.com/docs/sql-reference/agent-skills/motherduck-rest-api): Administer MotherDuck service accounts, tokens, Ducklings, and Dive embed sessions through the control-plane REST API. - [motherduck-security-governance](https://motherduck.com/docs/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](https://motherduck.com/docs/sql-reference/agent-skills/motherduck-share-data): Create, consume, or manage MotherDuck data shares, including audience grants, table filters, and refresh policy.