etl-incremental-patterns
Pass
Audited by Gen Agent Trust Hub on Sep 16, 2026
Risk Level: SAFEINDIRECT_PROMPT_INJECTION
Full Analysis
- [INDIRECT_PROMPT_INJECTION]: The skill provides code templates that are vulnerable to SQL injection. Specifically, the
incremental_by_timestampandfull_refresh_with_swapfunctions interpolate variable table and column names directly into SQL strings using Python f-strings. This pattern is dangerous if the identifiers are sourced from untrusted external data (e.g., user input or file names). - Ingestion points: The functions accept
tableandtimestamp_colas parameters inSKILL.mdwhich an agent might populate with external data. - Boundary markers: No delimiters or warnings are provided to prevent the agent from treating untrusted data as SQL identifiers.
- Capability inventory: The templates utilize
pandas.read_sqlandsqlalchemyto execute the resulting queries against a database. - Sanitization: The patterns lack identifier quoting or validation, which is necessary when parameterizing SQL identifiers.
Audit Metadata