managing-database-replication

HIGH W007: Insecure credential handling detected in skill instructions.

• Insecure credential handling detected (high risk: 1.00). The skill contains explicit plaintext passwords and password placeholders in example SQL/CLI commands (e.g., "PASSWORD 'secure_password'" and SOURCE_PASSWORD='...'), which instructs including secret values verbatim in generated output and is therefore high-risk credential handling.

MEDIUM W013: Attempt to modify system services in skill instructions.

• Attempt to modify system services in skill instructions detected (high risk: 0.90). The skill instructs modifying server configuration files (pg_hba.conf, postgresql data directory), creating replication users, performing base backups to /var/lib/postgresql/data, and testing failover by stopping the primary — all actions that change the host/server state and typically require elevated privileges/SSH access.