Skills
skills/vince-winkintel/sql-server-skills/sqlserver-indexes/Gen Agent Trust Hub

sqlserver-indexes

Pass

Audited by Gen Agent Trust Hub on Jun 29, 2026

Risk Level: SAFE
Full Analysis
  • [SAFE]: The skill includes several SQL scripts designed to query system Dynamic Management Views (DMVs) like sys.dm_db_index_usage_stats and sys.dm_db_index_physical_stats. These scripts are used to identify performance optimization opportunities by examining index usage and fragmentation metadata.
  • [COMMAND_EXECUTION]: A reference guide in references/index-strategies.md demonstrates how to use dynamic SQL via sp_executesql to automate index maintenance tasks. The script constructs ALTER INDEX commands using schema and object names retrieved from system metadata, which is a standard administrative pattern for SQL Server maintenance.
Audit Metadata
Risk Level
SAFE
Analyzed
Jun 29, 2026, 06:57 AM
Security Audit — agent-trust-hub — sqlserver-indexes