sqlserver-execution-plans
Pass
Audited by Gen Agent Trust Hub on Jun 29, 2026
Risk Level: SAFE
Full Analysis
- [COMMAND_EXECUTION]: The skill provides various SQL commands for performance tuning and diagnostic purposes. These include queries against system dynamic management views (DMVs) such as
sys.dm_exec_query_statsand administrative commands likeDBCC FREEPROCCACHEandUPDATE STATISTICS. These operations are standard for the described use case of database optimization and performance analysis. - [EXTERNAL_DOWNLOADS]: The skill references an external third-party utility, SentryOne Plan Explorer, as a recommended tool for visual rendering of execution plans. This is a well-known technology service used within the database administration community.
- [DATA_EXPOSURE]: The skill demonstrates how to retrieve SQL text from the plan cache using
sys.dm_exec_sql_text. While this can reveal the structure and literal values of queries running on the server to the user/agent, this is the intended and documented function of these system views for database diagnostics.
Audit Metadata