sqldw-consumption-cli

This Skill executes read-only T-SQL queries against Microsoft Fabric SQL endpoints from the command line using sqlcmd. It requires az login for Entra ID authentication and explicit database selection to return schema discovery or row counts.

Yes, you can run read-only T-SQL queries against Lakehouse SQL endpoints without a GUI. The Skill uses sqlcmd and Entra ID authentication to perform schema discovery, row counts, and result exports directly from the CLI.

To connect to Fabric SQL endpoints using sqlcmd, you need the sqlcmd utility, an active az login session for Entra ID authentication, and explicit database selection. This setup allows you to execute read-only T-SQL queries and export results.

No, the Fabric SQL consumption CLI does not support write operations or data modification. It strictly executes read-only T-SQL queries using Fabric-supported syntax, making it safe for schema discovery, row counts, and performance checks.

The best way to discover schemas and table row counts in Fabric Mirrored Databases is to use this Skill's repeatable discovery workflows. It executes targeted read-only T-SQL queries via the CLI to inspect columns, permissions, and row counts.