Back to skill

Security audit

DWD/DWS/ADS Data Warehouse Patterns

Security checks for vulnerabilities and agentic risk

Overview

This skill is a documentation-only SQL pattern guide for data warehouse modeling, with no requested permissions or hidden runtime behavior.

Install this as a data-engineering reference skill. Review generated SQL before running it against a real warehouse, especially INSERT OVERWRITE statements and partition placeholders, because the skill provides templates that could affect production data if applied without normal change controls.

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
  • 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
  • Excessive AgencyUnrestricted Tool Access, Autonomous Decision Making, Scope Creep
Findings (1)

Natural-Language Policy Violations

Low
Category
Not specified by scanner
Confidence
78% confidence
Finding

The description explicitly frames the skill as using patterns 'widely used in large-scale Chinese tech companies,' which introduces a region-specific language/locale context in the natural-language metadata. The file does not indicate that this locale framing is optional or user-selectable, nor does it clearly justify it as a required regional-compliance constraint.

Content

No source excerpt is available for this finding.

Static analysis

No suspicious patterns detected.