T09 · Insecure Skill Coding Practices
- Location
scripts/gen_data.py:76- Finding
SQL Injection Through an Unsanitized Table Identifier
- Content
View full analysis
- Remediation
View remediation
Security audit
Security checks for vulnerabilities and agentic risk
This is mostly a coherent test-data generator, but it needs Review because it gives under-scoped guidance for copying production personal data into test environments and has an unsafe SQL output edge case.
Install only if you are comfortable reviewing generated files before use. Prefer synthetic Faker data over copying production data; if real personal data must be used, treat the included masking snippets as insufficient by themselves and require proper anonymization, access controls, and compliance review. Pin Faker to a reviewed version and avoid accepting untrusted `--table` values for SQL output.
scripts/gen_data.py:76SQL Injection Through an Unsanitized Table Identifier
SKILL.md:25Unpinned Third-Party Dependency Installation
Without declared permissions the skill's intent is opaque and cannot be validated.
The skill explicitly advises copying production data into test environments and provides simple masking routines that may be reversible, incomplete, or insufficient for compliance requirements. Without strong warnings and safer defaults, users may expose real personal data such as Chinese ID numbers, phone numbers, addresses, and bank cards in lower-security environments.
The script hard-codes Faker('zh_CN'), which causes generated names, addresses, and related locale-specific data to always use the Chinese locale. This is a natural-language/locale policy concern because users are not offered any language or locale choice or told that output will be locale-constrained.
No suspicious patterns detected.