---
name: "sqli-defense-parameterized-queries"
description: "Eliminate SQL injection vulnerabilities using parameterized prepared statements."
metadata:
  author: "OWASP"
  version: "1.0.0"
  runtime_compatibility:
    - "codex"
    - "claude-code"
    - "cursor"
    - "windsurf"
triggers:
  - "prevent sql injection"
  - "use parameterized query"
  - "fix dynamic sql string concatenation"
permissions:
  fs_read: true
  fs_write: "workspace"
  shell_exec: false
  net_access: false
---

# SQL Injection Defense & Parameterized Statements

Implements strict parameterized query patterns across Node.js, Python, Go, and Java: eliminating dynamic SQL string concatenation, escaping LIKE clauses, and auditing raw database calls.

## When to Invoke
Invoke this skill whenever you need to:
- prevent sql injection
- use parameterized query
- fix dynamic sql string concatenation

## Execution SOP & Rules
1. Never concatenate or interpolate user input directly into SQL strings.
2. Use parameterized query placeholders ($1, ?, :param) supported by the database driver.
3. Escape wildcard characters (% and _) in user inputs intended for LIKE clauses.
4. Enforce database account least-privilege permissions to restrict unauthorized data modifications.

## Verification Checklist
- Run local linting, syntax validation, and type-checks before reporting completion.
- Ensure all created or modified files adhere to workspace boundaries and avoid uncommitted secrets.
- Verify tests or build commands exit cleanly with return code 0.