sqldb-operations-cli Skill
Diagnose SQL database in Fabric performance via sqlcmd against Query Store, DMVs, sys.dmdbresourcestats, and Extended Events on the OLTP endpoint. Identifies the top resource-consuming, slowest, or most expensive queries and handles query-performance ranking, blocking-chain, missing-index, and plan-regression diagnosti Published by microsoft in skills-for-fabric.
What is sqldb-operations-cli Skill?
Diagnose SQL database in Fabric performance via sqlcmd against Query Store, DMVs, sys.dmdbresourcestats, and Extended Events on the OLTP endpoint. Identifies the top resource-consuming, slowest, or most expensive queries and handles query-performance ranking, blocking-chain, missing-index, and plan-regression diagnosti Published by microsoft in skills-for-fabric. This profile combines repository metadata with install, compatibility, and usage signals so developers can quickly decide whether it fits their agent workflow before opening the source repository.
Automated repository signals based on public metadata such as recency, license, installation evidence, and adoption. These are not a security audit or endorsement.
Key capabilities
- Includes SKILL.md support
- Reusable instructions support
- Database workflows
- Database workflows use cases
Technical details
- Install or run with Copy skill directory
When to use sqldb-operations-cli Skill
- Use it for database workflows.
Built with
Editorial notes
Source
- Creator: microsoft
- Repository: microsoft/skills-for-fabric
- Skill file: skills/sqldb-operations-cli/SKILL.md
What it does
Diagnose SQL database in Fabric performance via sqlcmd against Query Store, DMVs, sys.dmdbresourcestats, and Extended Events on the OLTP endpoint. Identifies the top resource-consuming, slowest, or most expensive queries and handles query-performance ranking, blocking-chain, missing-index, and plan-regression diagnosti
Skill instructions
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-updates skill. - 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 1. To find the workspace details (including its ID) from workspace name: list all workspaces and, then, use JMESPath filtering 2. 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 SQL Database in Fabric — Operations & Diagnostics CLI Skill Deep performance diagnostics for SQL database in Fabric via sqlcmd against Query Store, DMVs, sys.dmdbresourcestats, and Extended Events. All analytical queries are read-only; the optional XE session creation is dropped at the end of the investigation. Prere
Explore related resources
Frequently asked questions
What is sqldb-operations-cli?
sqldb-operations-cli is a open-source AI agent skill with Copy skill directory. Diagnose SQL database in Fabric performance via sqlcmd against Query Store, DMVs, sys.dmdbresourcestats, and Extended Events on the OLTP endpoint.
Who is sqldb-operations-cli best for?
sqldb-operations-cli is best for reusing agent instructions, scripts, and references, database workflows.
How do I install sqldb-operations-cli?
Install or run sqldb-operations-cli using Copy skill directory. Check sqldb-operations-cli for the latest setup command.
Is sqldb-operations-cli actively maintained?
sqldb-operations-cli may need a closer maintenance check before production use.
Auto-fetched from GitHub.
