Diagnose SQL database in Fabric performance via sqlcmd against Query Store, DMVs, sys.dm_db_resource_stats, 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 diagnostics. For routine data queries use the sqldb-consumption-cli skill; for schema changes use the sqldb-authoring-cli skill. Triggers: "query store slow query analysis sqldb top queries", "top resource-consuming queries from query store sqldb", "slowest queries sql database in Fabric query store", "most expensive queries sqldb query store", "sql database in Fabric blocked sessions head blocker chain sqlcmd", "sqldb missing index recommendation", "sqldb regressed plan instability sqlcmd", "sqldb extended events trace".
How to install sqldb-operations-cli?
microsoft/skills-for-fabric/sqldb-operations-cli
$npx -y skills add microsoft/skills-for-fabric --skill sqldb-operations-cliInstalls into the current project.
›Prefer a prompt? Paste this to your agent
Run `npx skills use "https://github.com/microsoft/skills-for-fabric" --skill "microsoft/skills-for-fabric/sqldb-operations-cli"` and follow the generated skill instructions now. Read its complete output, redirecting it to a temporary file first if necessary. Resolve relative paths from the supporting-files directory it provides.
Use the skills in "https://github.com/microsoft/skills-for-fabric" that are relevant to the current task. Run `npx skills add "https://github.com/microsoft/skills-for-fabric"` and select the relevant skills, then follow their instructions.
Related
6 picksType
- supabase-postgres-best-practicesPostgres performance optimization and best practices from Supabase.Jul 2026
- firebase-data-connect-basicsBuilds and deploys Firebase SQL Connect (aka Firebase Data Connect) backends with PostgreSQL securely.Jul 2026
- firebase-firestoreSets up, manages, queries, and configures Cloud Firestore databases (Standard/Enterprise edition), including data modeling, security rules, indexes, and SDK…Jul 2026
- prisma-database-setupGuides for configuring Prisma with different database providers (PostgreSQL, MySQL, SQLite, MongoDB, etc.).Jul 2026
- prisma-client-apiPrisma Client API reference covering model queries, filters, operators, and client methods.Jul 2026
- prisma-cliPrisma ORM CLI commands reference covering init, generate, migrate, db, dev, studio, validate, format, debug, and mcp.Jul 2026
