T09 · Insecure Skill Coding Practices
- Location
skill.md:27- Finding
Unrestricted generation and execution of SQL from user-controlled requirements
- Content
View full analysis
- Remediation
View remediation
Security audit
Security checks for vulnerabilities and agentic risk
The skill is purpose-built for NocoBase data modeling, but it gives an agent broad database-changing authority without clear confirmation or safety boundaries.
Install only if you want an agent to make real NocoBase database changes. Before allowing tool calls, require the agent to show the planned SQL and API operations, confirm the target database, reject destructive or unrelated statements, and keep backups or rollback procedures available.
skill.md:27Unrestricted generation and execution of SQL from user-controlled requirements
Shadow Command Trigger: 'create table' conflicts with built-in command 'create'
The trigger list contains very broad, common terms such as '字段', '关系', 'collection', 'data model', and 'create table', which can cause the skill to activate during ordinary schema-design or discussion requests. Because the skill is wired to powerful database-modifying tools, over-broad activation increases the chance the agent proposes or initiates destructive state changes in contexts where the user did not clearly request execution.
The skill explicitly instructs use of SQL and setup APIs to create tables, relations, and seed data, but it does not require an explicit warning or confirmation before modifying the database. In a tool-enabled agent, this can lead to unintended schema changes or data insertion if the skill is triggered from an ambiguous request, making the impact materially higher than a purely advisory skill.
Overly Broad Trigger: '建模' is too short and may match unintended inputs
Overly Broad Trigger: '字段' is too short and may match unintended inputs
Overly Broad Trigger: '关系' is too short and may match unintended inputs
No suspicious patterns detected.