Sqldb CLI
Manages a Fabric SQL database item, the OLTP SQL Server engine, including running T-SQL...
Install
npx skills add microsoft/skills-for-fabric --skill sqldb-cli -g -a claude-code -y- Repository
- microsoft/skills-for-fabric1.3k
- Category
- Data and ML
- Updated
- 6d ago
- License
- MIT
- Context cost
- Mediumabout 2,024 tokens
- Runs scripts
- No, instructions only
What it does
Manages a Fabric SQL database item, the OLTP SQL Server engine, including running T-SQL through sqlcmd, temporal and vector similarity search, schema and sys.tables inspection, dacpac deployment, and Query Store, blocked sessions and regressed-plan investigation. Use for any query or change against a SQL database item. Warehouse, lakehouse SQL endpoint and mirrored items belong to sqldw-cli.
Telemetry, MANDATORY. Every
api.fabric.microsoft.comcall must carryx-ms-fabric-skill: sqldb-cli(az rest:--headers "x-ms-fabric-skill=sqldb-cli"), including every LRO poll,fabric_lroand retry. Snippets omit it, add it anyway.
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
sqldb-cliONLY for a Fabric SQL database item (the OLTP, SQL Server engine). A Warehouse, a Lakehouse SQL endpoint or a Mirrored Database issqldw-cli; a notebook cell isspark-cli.
Fabric SQL Database (OLTP) -- CLI Skill
This one skill owns Fabric SQL database: T-SQL schema authoring, read-only querying, and OLTP 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 endpoints, payload shapes, templates and gotchas; acting without it produces wrong payloads and wrong results.
