Back to skill

Security audit

Alibabacloud Migration Sdm Sql Trans

Security checks for vulnerabilities and agentic risk

Overview

This is a documented SQL conversion skill with no executable code or external-tool behavior, but users should review generated migration SQL before running it.

Install only if you want rule-based SQL migration assistance. Treat its converted SQL as a draft, especially for DDL, upserts, stored procedures, and anything marked TODO or manual review; verify it against your target Hologres environment before executing.

Vulnerability Patterns
  • Skill Instruction HijackingAlters the agent's session goals or safety constraints when the skill loads
  • Agent Memory PoisoningWrites attacker-controlled rules into memory that affect later sessions
  • Remote Payload Retrieval and ExecutionFetches external code whose behavior can change after review
  • Embedded Malicious CodeShips malicious scripts inside the skill and executes them locally
  • Unauthorized Access and Privilege EscalationObtains permissions beyond the task's legitimate needs
Vulnerability Patterns
  • MCP Tool PoisoningHidden Instructions, Unicode Deception, Parameter Description Injection
  • Prompt InjectionInstruction Override, Hidden Instructions, Exfiltration Commands
  • Data ExfiltrationExternal Transmission, Env Variable Harvesting, File System Enumeration
  • Privilege EscalationExcessive Permissions, Sudo/Root Execution, Credential Access
  • Supply ChainUnpinned Dependencies, External Script Fetching, Obfuscated Code
Findings (2)

Intent-Code Divergence

Medium
Category
Not specified by scanner
Confidence
97% confidence
Finding

The skill states that failed validation must produce no output, but later permits a fallback that outputs SQL with unresolved issues after three repair rounds. That contradiction weakens the safety gate for a SQL transformation workflow, making it more likely the agent will emit partially validated or known-incorrect migration SQL that a user may execute in production.

Content

No source excerpt is available for this finding.

Intent-Code Divergence

Medium
Category
Not specified by scanner
Confidence
94% confidence
Finding

The skill defines mutually inconsistent output requirements: one section forbids verbatim source-engine syntax in comments and logs, while other sections require or exemplify commentary that references source constructs during validation and transformation. In a rule-driven conversion skill, this ambiguity can cause the agent to either suppress necessary provenance/explanation or violate its own policy, leading to unsafe, unverifiable, or misleading SQL output.

Content

No source excerpt is available for this finding.

Static analysis

No suspicious patterns detected.