$ loading_
Run read-only T-SQL queries on Fabric warehouse and lakehouse data.
Copy the install command and let the AI configure it · recommended for beginners
Please install the "sqldw-consumption-cli" skill from askskill: 1. Download https://raw.githubusercontent.com/microsoft/skills-for-fabric/main/skills/sqldw-consumption-cli/SKILL.md 2. Save it as ~/.claude/skills/sqldw-consumption-cli/SKILL.md 3. Reload skills and tell me it's ready
Generate read-only T-SQL for a Fabric Lakehouse SQL Endpoint to count total rows in the sales_orders table and group counts by order_status, sorted by count descending.
An executable T-SQL query that returns total row count and grouped counts by status.
I want to inspect the schema of the customer_profile table in Fabric Data Warehouse. Generate read-only T-SQL to list column names, data types, and nullability, plus a query to preview the first 10 rows.
Two read-only T-SQL scripts for schema inspection and sample data preview.
Generate a read-only T-SQL query to filter warehouse orders from the last 30 days with amounts above 1000, returning order ID, customer ID, amount, and date, and explain how to export the results to CSV or JSON.
A T-SQL query with the requested filters and brief instructions to export results as CSV or JSON.
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
| 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 |
| OneLake Data Access | COMMON-CORE.md § OneLake Data Access | Requires storage.azure.com token, not Fabric token |
| Job Execution | COMMON-CORE.md § Job Execution | |
| Capacity Management | COMMON-CORE.md § Capacity Management | |
| Gotchas, Best Practices & Troubleshooting | 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 |
OneLake Data Access via curl | COMMON-CLI.md § OneLake Data Access via curl | Use curl not az rest (different token audience) |
| SQL / TDS Data-Plane Access | COMMON-CLI.md § SQL / TDS Data-Plane Access | sqlcmd (Go) connect, query, CSV export |
| Job Execution (CLI) | COMMON-CLI.md § Job Execution | |
| OneLake Shortcuts | COMMON-CLI.md § OneLake Shortcuts | |
| Capacity Management (CLI) | COMMON-CLI.md § Capacity Management | |
| Composite Recipes | COMMON-CLI.md § Composite Recipes | |
| Gotchas & Troubleshooting (CLI-Specific) | COMMON-CLI.md § Gotchas & Troubleshooting (CLI-Specific) | az rest audience, shell escaping, token expiry |
…
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.
Analyze Fabric warehouse performance via CLI and get optimization recommendations.
Interactively analyze lakehouse data with PySpark, Livy sessions, and Spark SQL.
Run DAX queries and inspect Fabric Power BI semantic model metadata.
Build Fabric Spark workflows, author notebook code, and manage lakehouse resources.
Ask natural-language questions about Power BI reports and get business answers.
Query Microsoft Fabric workspaces, lakehouses, tables, jobs, and dependencies in natural language.