The Agent Skills Directory

[COMMAND_EXECUTION]: The skill provides numerous high-privilege SQL commands for database administration and tuning. These include:
PostgreSQL: ALTER SYSTEM SET for global configuration, CREATE EXTENSION, REINDEX INDEX CONCURRENTLY, and VACUUM FULL (which requires an exclusive table lock).
MySQL: SET GLOBAL for critical system variables (e.g., innodb_buffer_pool_size, max_connections, innodb_flush_log_at_trx_commit) and OPTIMIZE TABLE.
These commands are legitimate within the scope of database optimization but require administrative permissions and should be executed with caution as they can impact system-wide performance.
[SAFE]: The skill incorporates several security and operational best practices to mitigate risk:
It mandates capturing baseline metrics before applying any optimizations.
It requires using CONCURRENTLY for PostgreSQL index creation to prevent blocking application traffic.
It includes explicit warnings to test changes in non-production environments and to monitor for side effects like replication lag or write amplification.
No evidence of prompt injection, unauthorized data exfiltration, or obfuscation was detected across the skill files.

database-optimizer