The Agent Skills Directory

[REMOTE_CODE_EXECUTION]: Provides instructions for installing the Trunk CLI using a piped shell script (curl https://trunk.sh/install | bash). This is a standard and well-documented installation method for a well-known PostgreSQL extension manager. (references/POSTGRESQL-EXTENSIONS.md)
[COMMAND_EXECUTION]: Includes various administrative shell commands for database management, such as rm -rf for clearing data directories during recovery procedures, and sudo apt-get or pip install for installing database-related tools. These commands are typical for the database administrator (DBA) persona the skill supports. (references/POSTGRESQL-BACKUP-RECOVERY.md, references/POSTGRESQL-EXTENSIONS.md, references/POSTGRESQL-REPLICATION-MONITORING.md)
[EXTERNAL_DOWNLOADS]: Mentions the installation of PostgreSQL extensions and related management tools from external repositories including PGXN, Trunk, and system package registries. (references/POSTGRESQL-EXTENSIONS.md)
[SAFE]: The skill contains extensive documentation on security best practices, such as salted password hashing, prevention of SQL injection via prepared statements, and the implementation of Least Privilege and Role-Based Access Control (RBAC). (references/ANTIPATTERN-APPLICATION-DEV.md, references/DESIGN-POSTGRESQL-SECURITY.md, references/DESIGN-SECURITY-OPTIMIZATION.md)

developing-databases