Back to skill

Security audit

City of Edmonton Open Data

Security checks for vulnerabilities and agentic risk

Overview

This skill is a straightforward City of Edmonton open-data CLI, with one CSV-export safety caveat users should understand.

Install only if you are comfortable with a Bash-invoked helper that contacts data.edmonton.ca and may cache the public dataset catalog locally. Treat CSV output as untrusted remote data; prefer JSON for analysis, or sanitize CSV files before opening them in spreadsheet applications.

Vulnerability Patterns
  • Insecure Skill Coding PracticesFinds exploitable flaws such as hardcoded secrets or command injection
  • 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
Findings (1)

T09 · Insecure Skill Coding Practices

Warning
Location
scripts/edmonton_data.py:151
Finding

Unsafe CSV Export Permits Spreadsheet Formula Injection

Content
View full analysis
permits.csv ``` CSV quoting alone prevents structural corruption but does not prevent spreadsheet applications from interpreting a quoted cell as a formula. Formula-prefixed cells therefore require separate neutralization when the export is intended for spreadsheet use. ### Attack Path 1. An attacker places a formula-prefixed value in a source represented by an Edmonton open dataset, or dataset content is otherwise compromised. 2. A user exports that dataset using `fetch --csv`. 3. The script writes the attacker-controlled value to the CSV output without formula neutralization. 4. The user opens the exported file in spreadsheet software that evaluates ...[truncated 1080 chars]
Remediation
View remediation
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