ClawHub
Back to skill

Security audit

Sql Optimization Patterns

Security checks for vulnerabilities and agentic risk

Overview

This is a documentation-only SQL optimization skill with purpose-aligned examples, but users should be careful before running maintenance SQL on production databases.

Install is reasonable if you want SQL optimization guidance. Before applying any generated SQL to a real database, especially VACUUM FULL, REINDEX, bulk UPDATE, COPY, partitioning, or index changes, review it with a database owner, verify backups, and prefer staging or a maintenance window for production systems.

A.I.G

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

SkillSpector

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)

Missing User Warnings

Medium
Confidence
90% confidence
Finding
The skill includes database maintenance commands such as VACUUM FULL and REINDEX without sufficiently prominent safety guidance at the point of use. In practice, an agent or user could apply these commands directly in production, causing table locks, service degradation, or unexpected operational impact even though the overall skill is educational rather than overtly malicious.

Static analysis

No suspicious patterns detected.