The Agent Skills Directory

[COMMAND_EXECUTION]: The skill documents the use of the PostgreSQL COPY FROM PROGRAM command, which enables the execution of shell commands (such as gunzip) from within the database environment to process compressed files during ingestion.
[COMMAND_EXECUTION]: Includes examples for using the pg_bulkload command-line utility to perform high-speed data loads, which involves executing external binary tools outside of the standard SQL interface.
[DATA_EXFILTRATION]: Provides instructions for using the COPY TO and COPY FROM commands to read and write data directly to the server's file system. These are standard operations for data engineering but involve direct file system interaction.
[EXTERNAL_DOWNLOADS]: Mentions the installation of database extensions like pg_partman and pg_bulkload via system package managers (apt-get) and the PostgreSQL Extension Network (pgxn).
[SAFE]: The skill uses legitimate, industry-standard patterns for its stated purpose of PostgreSQL data engineering. References are provided to official documentation and well-known technology community resources.

postgresql-data-engineering