fabric-collection

Skills for Fabric

Agent Skills for Microsoft Fabric

AI agent skills for Microsoft Fabric developers, data engineers, admins, and consumers.

Optimized for GitHub Copilot CLI, with cross‑tool compatibility for VS Code Copilot, Claude Code, Cursor, Codex/Jules, and Windsurf.

📘 Documentation • 🔐 Security • 🤝 Contributing • 🐞 Report a Bug

---

Why Skills for Fabric?

Skills for Fabric bridges the gap between AI coding assistants and Microsoft Fabric's enterprise data platform. We provide first-party, production-ready agent skills that enable AI tools to safely author, query, and operate complex Fabric workloads—from Spark pipelines to semantic models—while maintaining enterprise security and governance standards.

---

✨ What are Skills for Fabric?

Skills for Fabric (also referred to as Agent Skills) provide a standardized, secure, and extensible way for AI coding agents to author, query, operate, and govern Microsoft Fabric workloads.

These skills allow AI tools to act as Fabric‑aware agents—capable of understanding workspaces, Lakehouses, Warehouses, Eventhouses, semantic models, and capacity settings—while respecting Microsoft security, governance, and Responsible AI requirements.

The project follows the same design principles used across other Microsoft‑hosted skill repositories:

• ✅ Explicit authentication and authorization
• ✅ Clear separation of instructions vs user content
• ✅ No arbitrary code execution
• ✅ Enterprise‑grade security and compliance
• ✅ Tool‑agnostic agent compatibility

---

🆚 Skills vs Prompt‑Only Approaches

Unlike prompt‑only workflows, Skills for Fabric:

• Use authenticated Microsoft Fabric APIs
• Enforce safe, validated operations
• Understand Fabric resource types and boundaries
• Prevent prompt injection and unsafe execution
• Produce deterministic, auditable actions

This makes agent interactions reliable, repeatable, and enterprise‑ready.

---

🧱 Skills vs Agents

Concept	Description
Skill	A single, focused capability (for example: run Spark, query SQL, manage KQL)
Agent	An orchestrator that combines multiple skills to achieve a goal

Agents are built on top of skills.

---

🧠 Supported Personas & Scenarios

Skills are organized by persona and intent, enabling both focused and end‑to‑end workflows.

👩‍💻 Developers & Data Engineers (Authoring)

• Create and manage Fabric resources
• Build Spark ETL / ELT pipelines
• Author SQL objects and KQL assets
• Automate deployments and CI/CD flows

📊 Consumers & Analysts (Consumption)

• Query Lakehouse tables interactively
• Run SQL, DAX, and KQL without drivers
• Explore metadata and monitor usage

🛡️ Admins & Platform Owners

• Capacity planning and optimization
• Governance and security validation
• Cost, performance, and usage analysis

🤖 Cross‑Workload Agents

• Medallion architectures (Bronze → Silver → Gold)
• Migration and modernization
• Data quality checks and observability

---

🚀 Example Use Cases

Scenario	What the Agent Does
Analytics PDF Report	Analyzes Fabric data and generates a production‑ready PDF report
Document My Workspace	Inspects Fabric workspaces and produces structured documentation
NYC Taxi Medallion Project	Ingests public data, builds Spark pipelines, and exposes SQL views
Dashboard App	Creates an interactive dashboard connected to Fabric data

---

📦 Installation

GitHub Copilot CLI (Recommended)

Always start by connecting to the Skills for Fabric marketplace

/plugin marketplace add microsoft/skills-for-fabric

Install all skills

/plugin install skills-for-fabric@fabric-collection

Install by persona

# Authoring (developers, automation, CI/CD)
/plugin install fabric-authoring@fabric-collection

# Consumption (interactive analytics)
/plugin install fabric-consumption@fabric-collection

Filter by engine or endpoint

/plugin install skills-for-fabric@fabric-collection --filter "spark-*"
/plugin install skills-for-fabric@fabric-collection --filter "sqldw-*"
/plugin install skills-for-fabric@fabric-collection --filter "eventhouse-*"

---

Manual Installation

git clone https://github.com/microsoft/skills-for-fabric.git
cd skills-for-fabric

# Windows
.\\install.ps1

# macOS / Linux
./install.sh

---

🔐 Authentication

All Fabric operations require Azure AD authentication:

az login
az account get-access-token --resource https://api.fabric.microsoft.com

No secrets or tokens are stored by the skills.

---

🧩 Skill Catalog

✍️ Authoring Skills