schema-migrations-safely
Pass
Audited by Gen Agent Trust Hub on Sep 28, 2026
Risk Level: SAFE
Full Analysis
- Safe SQL Migration Patterns: The skill promotes secure practices for database management, such as using sp_getapplock for concurrency control and wrapping migrations in transactions to ensure atomicity. These patterns prevent data corruption during retries or concurrent executions.
- Use of Dynamic SQL: The instructions include sp_executesql to handle T-SQL syntax limitations. The provided snippets use hardcoded strings or system metadata lookups, which is a standard and safe application of dynamic SQL in this context.
- Standard Tooling and Placeholders: The skill demonstrates using official tools like sqlcmd for deployment. It correctly uses environment variable placeholders for sensitive information, adhering to secret management best practices.
- Diagnostic and Verification Scripts: The inclusion of verification scripts helps users identify and resolve hanging transactions or locks, enhancing the overall security and reliability of the migration process.
Audit Metadata