A skill for working with Microsoft Fabric Warehouses, Lakehouse SQL analytics endpoints, and Mirrored Databases using T-SQL. T-SQL is Microsoft's SQL language for reading and changing relational data.

Use it to write table definitions and data changes, load data with COPY INTO, run read-only queries and row counts, and investigate query performance.

It keeps queries and data-loading tasks targeted at the correct Fabric SQL item and supports performance investigation when queries are slow.

sqldw-cli — Skill for Claude Code by microsoft/skills-for-fabric

About the project

Microsoft Fabric Skills is a collection of reusable instructions and MCP systems that help AI assistants work with Microsoft Fabric workloads, APIs, queries, and operations. It is intended for users of GitHub Copilot CLI and compatible coding tools; the catalogue entries are the skills, agents, instructions, MCP systems, plugins, and rules distributed by the project.

microsoft/skills-for-fabric · 1,321 stars · on GitHub

Install

Getting it into your agent

One page per mod, every tool's command on it. A separate URL per tool would split the same page into five that compete with each other.

Any agent

npx skills add microsoft/skills-for-fabric --skill sqldw-cli

Clone the repo

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

Made for: Claude Code.

Or install fabric-skills, the plugin that ships this one along with the rest of its 25 skills.

Wrote this? Show the measurements

A badge with what this costs and how it scanned, read live from this page, so it follows the numbers instead of freezing them. Markdown for a README, HTML for a documentation site or a project page.

README.md

[![agentmods](https://agentmods.dev/badge/skills/microsoft/skills-for-fabric/sqldw-cli/github.svg)](https://agentmods.dev/skills/microsoft/skills-for-fabric/sqldw-cli)

Your own site

<a href="https://agentmods.dev/skills/microsoft/skills-for-fabric/sqldw-cli"><img src="https://agentmods.dev/badge/skills/microsoft/skills-for-fabric/sqldw-cli/github.svg" alt="Measured on agentmods" height="20"></a>

Or the 80×15 button, for a site that already has a row of RSS and ATOM ones. Only the verdict fits; the numbers stay here.

Your own site · 80×15

<a href="https://agentmods.dev/skills/microsoft/skills-for-fabric/sqldw-cli"><img src="https://agentmods.dev/badge/skills/microsoft/skills-for-fabric/sqldw-cli.svg" alt="Reviewed on agentmods" width="80" height="20"></a>

Per session 98 Skills are progressive disclosure: only the name and description are preloaded; the body loads when the skill is used.

When invoked 3,300 The whole file, excluding the scripts and references it only reads on demand.

Security scan A 0 findings. A grade says what 26 rules found in the file — not that it is safe. Third-party audits

NVIDIA SkillSpector warn 7 Sept 2026

SkillSpector: 1 finding, up to high

These are SkillSpector’s own severities. On a checked sample its high-severity flags on skills were ~96% false positives — a documented command, a public API, a “never do X” rule — so we show them as a caution to read, not a verdict. Why →

high Agent Snooping · line 83
Skill accesses MCP server configuration files (mcp.json). MCP configs contain server URLs, authentication tokens, and tool definitions — reading them allows the skill to discover and potentially abuse other tool integrations.

Fix: Remove all code or instructions that read MCP configuration files (mcp.json). MCP server details should be managed by the agent runtime, not read by individual skills.

How audits are shown

Origin original No closer match found in the catalogue.

Token cost

What it costs to keep this loaded

Counted locally with the o200k_base tokenizer, which is exact for GPT models; Claude uses its own tokenizer and its counts differ. Treat this as one consistent yardstick across the catalogue rather than a bill. Prices are per million input tokens.

Model	Per session	Once invoked
Fable 5.1	$0.00098	$0.03300
Opus 5.5	$0.00039	$0.01320
Sonnet 5.5	$0.00020	$0.00660
Haiku 4.5	$0.00010	$0.00330

Measured 1mo ago against content hash a8148ca651c5, method: parsed. Prices are Anthropic first-party input rates as of 2026-10-07, from the pricing page.

Security

Grade A, and why

sqldw-cli scanned grade A with 0 findings against 26 rules in 11 categories — prompt injection, anti-refusal, data exfiltration, privilege escalation, supply chain, agent snooping, system-prompt leakage, SSRF and excessive agency — measured 1mo ago.

A static scan of the body, not an audit. Every finding is printed with the line that produced it so you can judge whether it matters here. A mod is markdown that instructs an agent; that is exactly why what it instructs is worth reading.

Nothing flagged

None of the 26 patterns this scan looks for appear in this file: no shell pipes, no recursive deletes, no credential paths, no hidden text, no instruction-override or anti-refusal phrasing, no agent-config snooping. That is not a guarantee, it is the absence of the things that are checkable.

plugins/fabric-skills/skills/sqldw-cli/SKILL.md · 140 lines

How it starts

The opening of the file, as written. The whole thing — 140 lines — stays where its author put it; the contents beside it link to each section on GitHub.

Telemetry — MANDATORY. Every api.fabric.microsoft.com call must carry x-ms-fabric-skill: sqldw-cli (az rest: --headers "x-ms-fabric-skill=sqldw-cli"), including every LRO poll, fabric_lro and retry. Snippets omit it — add it anyway. This covers all three modes; the mode references inherit it.

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

Skill disambiguation: use sqldw-cli for T-SQL sent to a Warehouse, a Lakehouse SQL analytics endpoint, or a Mirrored Database, including plain Lakehouse table SELECT, row-count, filtering, and aggregation requests. Target Warehouse SQL executed within an end-to-end Azure Synapse or Dedicated SQL Pool migration belongs to synapse-migration; standalone Warehouse work before or after migration returns to sqldw-cli. Any notebook-cell or PySpark DataFrame work is spark-cli; a Fabric SQL database (OLTP) is sqldb-cli.

Fabric Warehouse and SQL Endpoints — CLI Skill

This one skill owns Fabric Warehouse, Lakehouse SQL analytics endpoints and Mirrored Databases: T-SQL authoring and ingestion, read-only querying, and warehouse performance diagnostics.

It is a mode dispatcher and contains NO procedures. Pick the mode that matches the request from the table below, then read the matching references/<mode>.md file end to end with your file-reading tool BEFORE issuing a single command. That file holds the T-SQL surface area, DDL constraints, query templates and gotchas; acting without it produces invalid T-SQL and wrong results.

Mode selection

Mode	Use when the request ...	Example triggers	Read this first
`authoring`	changes warehouse state: table DDL, DML, ingestion, transactions, procedures, schema evolution, time travel	create warehouse table, COPY INTO, OPENROWSET, INSERT/UPDATE/DELETE, warehouse MERGE, CTAS, sp_rename, create T-SQL procedure, warehouse time travel	references/authoring.md
`consumption`	reads data or metadata: SELECT, row counts, filtering, aggregation, schema/object discovery, CSV export	query warehouse, count rows lakehouse, SELECT lakehouse, show tables, describe warehouse schema, export SQL data	references/consumption.md
`operations`	diagnoses performance, failures, capacity consumption, SQL pool usage, or health through `queryinsights` and supported endpoint diagnostics	failed or canceled warehouse queries, CU spike, Capacity Metrics app, expensive SQL users, custom SQL pool recommendation, queryinsights CPU, pressure events, cache warmth, Lakehouse tables needing attention	references/operations.md

Read the full file on GitHub · 140 lines

Files

What ships with it

15 files beside SKILL.md in the same directory: the scripts, references and assets a skill reads on demand. Not counted in the per-session cost; read them before you install if any of them is executable.

Changes

What this file has done since we first saw it

Hashed on every crawl. A supply-chain change to an agent config is a question of when, not whether, so the history is kept rather than the latest state alone.

1mo ago Changed · -2 tokens per session a8148ca651c5
2mo ago Changed · +16 lines · +17 tokens per session e98b55715629
2mo ago First seen · 124 lines · 83 tokens per session scan A 28466decce1a

Subscribe to this mod's changes

sqldw-cli is a skill published in the GitHub repository microsoft/skills-for-fabric (1,321 stars, last pushed yesterday), licensed MIT. It adds 98 tokens to every session and 3,300 once invoked, about $0.0004 per session on Opus 5.5. A static security scan graded it A with 0 findings. No closer match exists in the catalogue, so it is treated as the original; first seen 2026-08-30.

Analytics and metrics Databases

sqldw-cli next to 6 skills from other repositories
Mod	Type	Stars	Last push	Licence	Scan	Tokens	Works with
sqldw-climicrosoft/skills-for-fabric	Skill	1.3k	yesterday	MIT	A	98	Claude Code
create-prprisma/orm	Skill	48k	yesterday	Apache-2.0	A	48	Claude Code, Codex
schema-explorationlangchain-ai/deepagents	Skill	31k	yesterday	MIT	A	57	Claude Code, Codex
atlas-mssqlariga/atlas	Skill	8.8k	yesterday	Apache-2.0	A	163	Claude Code
ha-data-storesshiwenwen/hope-agent	Skill	1.9k	yesterday	MIT	A	115	Claude Code, Codex
nornicdb-cypher-queriesorneryd/NornicDB	Skill	923	yesterday	MIT	A	79	Claude Code, Codex
volcengine-rds-postgresqlbytedance/agentkit-samples	Skill	484	today	Apache-2.0	A	63	Claude Code, Codex