sqldw-authoring-cli
Pass
Audited by Gen Agent Trust Hub on Jul 10, 2026
Risk Level: SAFECOMMAND_EXECUTION
Full Analysis
- Industry Standard Tooling: The skill utilizes established utilities including
sqlcmd, the Azure CLI (az), andjq. These are standard tools for managing Microsoft SQL and Azure cloud resources, and the skill provides appropriate installation paths via official package managers like winget, brew, and apt. - Authentication Best Practices: Authentication is managed through Azure Entra ID, requiring an active
az loginsession. This ensures that the skill operates within the user's existing security context and permissions, rather than using non-standard authentication methods. - Local Script Generation: The skill provides templates for Bash and PowerShell scripts to automate ETL (Extract, Transform, Load) processes. These scripts are generated locally based on user-provided parameters and are used to facilitate standard database operations like table creation and data migration.
- Secure Data Ingestion: Data movement is performed using the native
COPY INTOcommand, which allows for direct ingestion from Azure Data Lake Storage (ADLS) into the Data Warehouse. This leverages secure, built-in cloud platform capabilities for data handling. - Configuration via Environment Variables: The skill promotes the use of environment variables for connection strings and server endpoints. This is a recommended security practice to avoid hardcoding environment-specific configurations within scripts or command history.
Audit Metadata