$ loading_
Analyze Fabric warehouse performance via CLI and get optimization recommendations.
Copy the install command and let the AI configure it · recommended for beginners
Please install the "sqldw-operations-cli" skill from askskill: 1. Download https://raw.githubusercontent.com/microsoft/skills-for-fabric/main/skills/sqldw-operations-cli/SKILL.md 2. Save it as ~/.claude/skills/sqldw-operations-cli/SKILL.md 3. Reload skills and tell me it's ready
Use sqlcmd and queryinsights views to analyze the slowest queries in this Fabric Data Warehouse over the last 24 hours, rank them by duration, CPU, and scan volume, and summarize the most likely bottlenecks.
A list of slow queries, key performance metrics, bottleneck diagnosis, and actionable optimization recommendations.
Check this warehouse’s SQL pool pressure windows and pressure events over the last week, identify high-pressure periods and top resource-consuming queries, and determine whether concurrency or resource contention issues exist.
Pressure windows, resource-heavy queries, root-cause analysis, and recommended mitigation steps.
Based on current query patterns, table access distribution, and historical performance baselines, evaluate which tables should adjust their clustering keys and compare whether recent performance has degraded versus baseline.
Candidate tables, clustering key recommendations, baseline comparison results, and prioritized optimization actions.
Update Check — ONCE PER SESSION (mandatory) The first time this skill is used in a session, run the check-updates skill before proceeding.
- GitHub Copilot CLI / VS Code: invoke the
check-updatesskill.- Claude Code / Cowork / Cursor / Windsurf / Codex: compare local vs remote package.json version.
- Skip if the check was already performed earlier in this session.
CRITICAL NOTES
- To find the workspace details (including its ID) from workspace name: list all workspaces and, then, use JMESPath filtering
- To find the item details (including its ID) from workspace ID, item type, and item name: list all items of that type in that workspace and, then, use JMESPath filtering
This skill provides performance analysis, deep diagnostics, and optimization guidance for Microsoft Fabric Data Warehouse via sqlcmd and the built-in queryinsights views. All queries are read-only.
For tool installation and authentication setup, see COMMON-CLI.md § Authentication Recipes and COMMON-CLI.md § SQL / TDS Data-Plane Access.
Monitoring-specific requirements:
queryinsights views)queryinsights views retain 30 days; data appears with up to 15 min delay)| Task | Reference | Notes |
|---|---|---|
| Finding Workspaces and Items in Fabric | COMMON-CLI.md § Finding Workspaces and Items in Fabric | Mandatory — READ link first [needed for finding workspace id by its name or item id by its name, item type, and workspace id] |
| Fabric Topology & Key Concepts | COMMON-CORE.md § Fabric Topology & Key Concepts | |
| Environment URLs | COMMON-CORE.md § Environment URLs | |
| Authentication & Token Acquisition | COMMON-CORE.md § Authentication & Token Acquisition | Wrong audience = 401; read before any auth issue |
| Core Control-Plane REST APIs | COMMON-CORE.md § Core Control-Plane REST APIs | Includes pagination, LRO polling, and rate-limiting patterns |
| Capacity Management | COMMON-CORE.md § Capacity Management | |
| Gotchas, Best Practices & Troubleshooting (Platform) | COMMON-CORE.md § Gotchas, Best Practices & Troubleshooting | |
| Tool Selection Rationale | COMMON-CLI.md § Tool Selection Rationale | |
| Authentication Recipes | COMMON-CLI.md § Authentication Recipes | az login flows and token acquisition |
Fabric Control-Plane API via az rest | COMMON-CLI.md § Fabric Control-Plane API via az rest | Always pass --resource; includes pagination and LRO helpers |
| SQL / TDS Data-Plane Access | COMMON-CLI.md § SQL / TDS Data-Plane Access | sqlcmd (Go) connect, query, CSV export |
| Gotchas & Troubleshooting (CLI-Specific) | COMMON-CLI.md § Gotchas & Troubleshooting (CLI-Specific) | az rest audience, shell escaping, token expiry |
| Quick Reference | COMMON-CLI.md § Quick Reference | az rest template + token audience/tool matrix |
…
Inspect Fabric alerts, notifications, and automated actions via read-only API calls.
Run authoring T-SQL for Fabric warehouses and SQL endpoints from CLI.
Monitor, inspect, and query Fabric Dataflows Gen2 through a read-only CLI.
Query Fabric Eventhouse data, analyze time series, and monitor ingestion health.
Migrate Databricks notebooks, jobs, and paths into Microsoft Fabric.
List, inspect, and validate Microsoft Fabric Eventstream topology and configuration.
Run read-only T-SQL queries on Fabric warehouse and lakehouse data.
Run DAX queries and inspect Fabric Power BI semantic model metadata.
Write, optimize, and translate SQL across major warehouse dialects.
Interactively analyze lakehouse data with PySpark, Livy sessions, and Spark SQL.
Diagnose Spark failures, session issues, and performance bottlenecks in Microsoft Fabric.
Ask natural-language questions about Power BI reports and get business answers.