Back to skill

Security audit

duckdb-en

Security checks for vulnerabilities and agentic risk

Overview

This is a straightforward DuckDB CLI reference skill whose file and database operations match its stated data-analysis purpose.

Install this if you want DuckDB CLI help. Before letting an agent run suggested commands, check file paths and confirm any COPY, CREATE, INSERT, or persistent database command, especially where outputs could overwrite files or modify a database.

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
  • Rogue AgentSelf-Modification, Session Persistence
  • Trigger AbuseOverly Broad Trigger, Shadow Command Trigger, Keyword Baiting Trigger
  • Prompt InjectionInstruction Override, Hidden Instructions, Exfiltration Commands
  • Data ExfiltrationExternal Transmission, Env Variable Harvesting, File System Enumeration
  • Privilege EscalationExcessive Permissions, Sudo/Root Execution, Credential Access
Findings (5)

Skill Enumeration

Medium
Category
Agent Snooping
Content
Copy `SKILL.md` to your Claude Code skills directory:

```bash
mkdir -p ~/.claude/skills/duckdb
cp SKILL.md ~/.claude/skills/duckdb/
```
Confidence
85% confidence
Finding
Skill enumerates or reads other installed skills. Access to other skills' SKILL.md files or the skills directory reveals prompt instructions, capabilities, and secrets that should be invisible to peer skills.

Session Persistence

Medium
Category
Rogue Agent
Content
Copy `SKILL.md` to your Claude Code skills directory:

```bash
mkdir -p ~/.claude/skills/duckdb
cp SKILL.md ~/.claude/skills/duckdb/
```
Confidence
60% confidence
Finding
Skill establishes unauthorized persistence across sessions via cron jobs, startup scripts, or state files. Session persistence allows an attacker to maintain access beyond the current interaction.

Vague Triggers

Medium
Confidence
96% confidence
Finding
The manifest description says the skill triggers on generic terms like "sql", "query", "data analysis", and "convert data". These phrases overlap with common user requests and do not clearly constrain when this DuckDB-specific skill should activate versus other general analysis or database skills.

Missing User Warnings

Medium
Confidence
89% confidence
Finding
The skill includes examples that write files and perform database-modifying operations, but it does not clearly warn that these commands can overwrite outputs, create artifacts, or modify persistent databases. In an agent setting, this increases the chance that a user request for analysis could be translated into state-changing commands without explicit confirmation.

Session Persistence

Medium
Category
Rogue Agent
Content
# Pipe to another command
duckdb -csv -c "SELECT * FROM 'data.parquet'" | head -20

# Write to stdout
duckdb -c "COPY (SELECT * FROM 'data.csv') TO '/dev/stdout' (FORMAT CSV)"
```
Confidence
60% confidence
Finding
Skill establishes unauthorized persistence across sessions via cron jobs, startup scripts, or state files. Session persistence allows an attacker to maintain access beyond the current interaction.

Static analysis

No suspicious patterns detected.