Skip to content

tanviet12/vbsec / skills/antigravity/vbs-scan-security

vbs-scan-security

Flagged

Use when scanning code for security vulnerabilities. Use when user says "scan security", "kiểm tra bảo mật", "security audit", "review security", or invokes `/vbs-scan-security`. For large scans (>20 main-language files OR >30 total OR >14 days) processes chunks sequentially. Outputs bilingual reports (vi/en). Optional `--auto-fix` (agentic patch + verify loop) and `--sca` (live CVE lookup via OSV.dev).

FileKindSize
SKILL.mdskill md28.2 KB
VERSIONother6 B
references/chunking-strategy.mdmarkdown7.2 KB
references/data-flow-classification.mdmarkdown9.5 KB
references/dependency-scan.mdmarkdown9.7 KB
references/i18n/en.mdmarkdown8.7 KB
references/i18n/vi.mdmarkdown9.4 KB
references/language-detection.mdmarkdown7.5 KB
references/load-rules.shexecutablescript5.2 KB
references/output-format.mdmarkdown26.1 KB
references/project-context.mdmarkdown2.7 KB
references/sub-agent-prompts.mdmarkdown16.5 KB
references/validate-report.pyexecutablescript8.7 KB
rules/generic/01-hardcoded-secret.mdmarkdown5.4 KB
rules/generic/02-sql-injection.mdmarkdown5.2 KB
rules/generic/03-xss.mdmarkdown4.9 KB
rules/generic/04-idor.mdmarkdown5.7 KB
rules/generic/05-slopsquatting.mdmarkdown6.1 KB
rules/generic/06-brute-force.mdmarkdown6.9 KB
rules/generic/07-mass-assignment.mdmarkdown6.3 KB
rules/generic/08-insecure-deserialization.mdmarkdown6.3 KB
rules/generic/09-ssrf.mdmarkdown6.7 KB
rules/generic/10-path-traversal.mdmarkdown6.3 KB
rules/generic/11-csrf.mdmarkdown7.8 KB
rules/generic/12-broken-access-control.mdmarkdown7.9 KB
rules/generic/13-weak-password-hashing.mdmarkdown5.2 KB
rules/generic/14-jwt-none-algorithm.mdmarkdown5.3 KB
rules/generic/15-cors-misconfig.mdmarkdown5.3 KB
rules/generic/16-unrestricted-file-upload.mdmarkdown5.9 KB
rules/generic/17-verbose-error-debug-mode.mdmarkdown5.8 KB
rules/generic/18-missing-rate-limit.mdmarkdown10.7 KB
rules/generic/19-race-condition.mdmarkdown11.5 KB
rules/generic/20-outdated-dependency.mdmarkdown7.2 KB
rules/generic/21-command-injection.mdmarkdown6.6 KB
rules/generic/22-vulnerable-dependency.mdmarkdown5.3 KB
rules/generic/23-llm-prompt-injection.mdmarkdown9.7 KB
rules/generic/24-excessive-agency.mdmarkdown10.1 KB
rules/generic/25-tenant-isolation.mdmarkdown10.1 KB
rules/generic/26-authz-path-parity.mdmarkdown10.9 KB
rules/generic/27-excessive-data-exposure.mdmarkdown10.4 KB
rules/generic/28-business-state-integrity.mdmarkdown9.5 KB
rules/generic/29-sensitive-data-in-logs.mdmarkdown9.1 KB
rules/generic/30-auth-session-lifecycle.mdmarkdown9.4 KB
rules/generic/31-resource-exhaustion.mdmarkdown9.0 KB
rules/languages/README.mdmarkdown8.5 KB
rules/languages/dart/01-hardcoded-secret.mdmarkdown7.9 KB
rules/languages/dart/03-xss.mdmarkdown5.2 KB
rules/languages/dart/05-slopsquatting.mdmarkdown4.6 KB
rules/languages/dart/10-path-traversal.mdmarkdown6.3 KB
rules/languages/dart/12-broken-access-control.mdmarkdown8.3 KB
rules/languages/dart/17-verbose-error-debug-mode.mdmarkdown6.7 KB
rules/languages/dart/20-outdated-dependency.mdmarkdown4.7 KB
rules/languages/dart/README.mdmarkdown3.7 KB
rules/languages/dotnet/02-sql-injection.mdmarkdown5.7 KB
rules/languages/dotnet/07-mass-assignment.mdmarkdown6.0 KB
rules/languages/dotnet/08-insecure-deserialization.mdmarkdown5.7 KB
rules/languages/dotnet/17-verbose-error-debug-mode.mdmarkdown5.0 KB
rules/languages/dotnet/21-command-injection.mdmarkdown5.3 KB
rules/languages/dotnet/README.mdmarkdown1.7 KB
rules/languages/go/02-sql-injection.mdmarkdown5.2 KB
rules/languages/go/08-insecure-deserialization.mdmarkdown5.0 KB
rules/languages/go/09-ssrf.mdmarkdown5.8 KB
rules/languages/go/17-verbose-error-debug-mode.mdmarkdown6.1 KB
rules/languages/go/21-command-injection.mdmarkdown5.2 KB
rules/languages/go/README.mdmarkdown2.7 KB
rules/languages/php/02-sql-injection.mdmarkdown5.8 KB
rules/languages/php/08-insecure-deserialization.mdmarkdown6.2 KB
rules/languages/php/11-csrf.mdmarkdown6.2 KB
rules/languages/php/17-verbose-error-debug-mode.mdmarkdown6.5 KB
rules/languages/php/21-command-injection.mdmarkdown6.7 KB
rules/languages/php/README.mdmarkdown2.9 KB
rules/languages/python/02-sql-injection.mdmarkdown7.2 KB
rules/languages/python/07-mass-assignment.mdmarkdown7.3 KB
rules/languages/python/08-insecure-deserialization.mdmarkdown7.3 KB
rules/languages/python/09-ssrf.mdmarkdown7.5 KB
rules/languages/python/11-csrf.mdmarkdown7.6 KB
rules/languages/python/14-jwt-none-algorithm.mdmarkdown7.5 KB
rules/languages/python/15-cors-misconfig.mdmarkdown8.0 KB
rules/languages/python/17-verbose-error-debug-mode.mdmarkdown8.4 KB
rules/languages/python/21-command-injection.mdmarkdown8.5 KB
rules/languages/python/README.mdmarkdown3.4 KB
rules/languages/typescript/02-sql-injection.mdmarkdown7.5 KB
rules/languages/typescript/03-xss.mdmarkdown6.7 KB
rules/languages/typescript/07-mass-assignment.mdmarkdown7.4 KB
rules/languages/typescript/08-insecure-deserialization.mdmarkdown7.0 KB
rules/languages/typescript/09-ssrf.mdmarkdown7.5 KB
rules/languages/typescript/11-csrf.mdmarkdown7.3 KB
rules/languages/typescript/14-jwt-none-algorithm.mdmarkdown7.0 KB
rules/languages/typescript/15-cors-misconfig.mdmarkdown7.2 KB
rules/languages/typescript/17-verbose-error-debug-mode.mdmarkdown7.2 KB
rules/languages/typescript/21-command-injection.mdmarkdown6.7 KB
rules/languages/typescript/README.mdmarkdown3.3 KB
workflows/auto-fix.mdmarkdown18.9 KB
workflows/large-review-sequential.mdmarkdown14.8 KB
workflows/small-review.mdmarkdown10.1 KB

rules/languages/php/02-sql-injection.md

View on GitHub
---
id: SQL-INJECTION
severity_max: CRITICAL
applies_to: php
---

# SQL Injection (PHP)

## Intent

PHP là môi trường có lịch sử SQLi nặng nhất web (legacy mysql_*, mysqli, PDO không prepare). Vibe code PHP đặc biệt dễ dính vì:

- `$_GET`, `$_POST`, `$_REQUEST`, `$_COOKIE` là **superglobals L1** trực tiếp interpolate vào string SQL.
- `mysqli_query($conn, "SELECT ... $_GET[id]")` — vẫn còn rất nhiều trong code WordPress plugin và legacy.
- Laravel `DB::raw()`, `whereRaw()`, `selectRaw()` với string concat — bypass Eloquent's auto-binding.
- WordPress `$wpdb->query("SELECT ... $id")` không `prepare` — classic plugin RCE.

## Khi nào CRITICAL

- L1 ghép thẳng vào SQL string: `mysqli_query`, `PDO::query`, `$wpdb->query`, `$wpdb->get_results` không `prepare`
- Laravel `DB::raw("... {$input}")`, `whereRaw("col = '$val'")` với `$val` từ Request
- `DB::select(DB::raw($sql))` với `$sql` tự build từ user input
- Endpoint không có middleware `auth`

## Khi nào HIGH (giảm cấp)

- Đã có `mysqli_real_escape_string` / `addslashes` — escape giảm risk nhưng KHÔNG đủ (charset multi-byte bypass, không escape integer context)
- Whitelist regex chặt trước concat (vd: chỉ cho phép `[0-9]+` cho integer ID)
- Endpoint chỉ admin gọi (middleware `can:admin`)
- WordPress plugin chỉ chạy trong wp-admin với capability check

## Cách reasoning (KHÔNG pattern-match thuần)

1. **Grep** sinks: `mysqli_query`, `mysql_query`, `->query(`, `->exec(`, `$wpdb->query`, `$wpdb->get_`, `DB::raw`, `whereRaw`, `selectRaw`, `havingRaw`, `orderByRaw`
2. **Read** function chứa call: trace biến từ `$_GET`, `$_POST`, `$_REQUEST`, `Request::input`, `$request->name`, `request()->all()`
3. **Trace L1→sink**:
   - `$_GET['id']` → biến local → SQL string → L1 direct
   - Eloquent model attribute đọc từ DB rồi dùng trong query khác → L2 (stored)
   - Constant `DB_NAME` → L4 safe
4. **Verify**:
   - PDO có `->prepare()` + `->bindParam()` / `->execute([...])` không?
   - `$wpdb->prepare("SELECT ... %d", $id)` placeholder?
   - Laravel `Model::where('col', $val)` (Eloquent tự bind) hay `whereRaw`?

## Search patterns (PHP-specific)

```
# Legacy mysql/mysqli
mysql_query\s*\(\s*["'][^"']*\$
mysqli_query\s*\([^,]+,\s*["'][^"']*\$
mysqli::query

# PDO không prepare
->query\s*\(\s*["'][^"']*\$
->exec\s*\(\s*["'][^"']*\$

# WordPress wpdb
\$wpdb->(query|get_results|get_row|get_var|get_col)\s*\(\s*["'][^"']*\$
# NEGATIVE: $wpdb->prepare(...) → safe
\$wpdb->prepare

# Laravel raw
DB::raw\s*\(\s*["'][^"']*\{?\$
DB::statement\s*\(\s*["'][^"']*\$
->whereRaw\s*\(\s*["'][^"']*\{?\$
->selectRaw\s*\(\s*["'][^"']*\{?\$
->havingRaw\s*\(
->orderByRaw\s*\(

# Superglobals trong SQL string
"[^"]*\$_(GET|POST|REQUEST|COOKIE)
```

## Examples

### CRITICAL — flag

```php
<?php
// Legacy mysqli + $_GET trực tiếp
$id = $_GET['id'];
$result = mysqli_query($conn, "SELECT * FROM users WHERE id = $id");
// ?id=1 OR 1=1 → dump all
```

```php
<?php
// PDO không prepare
$stmt = $pdo->query("SELECT * FROM products WHERE name = '" . $_POST['name'] . "'");
```

```php
<?php
// WordPress plugin
global $wpdb;
$user_id = $_GET['user_id'];
$results = $wpdb->get_results("SELECT * FROM {$wpdb->prefix}users WHERE ID = $user_id");
// BAD: không prepare
```

```php
// Laravel — whereRaw với Request input
Route::get('/search', function (Request $request) {
    $term = $request->query('q');
    return DB::table('products')
        ->whereRaw("name LIKE '%{$term}%'")  // BAD
        ->get();
});
```

```php
// Laravel — DB::select raw build
$sort = $request->input('sort');
$users = DB::select("SELECT * FROM users ORDER BY $sort");  // BAD
```

### NOT critical — safe

```php
<?php
// PDO prepared
$stmt = $pdo->prepare("SELECT * FROM users WHERE id = :id");
$stmt->execute(['id' => $_GET['id']]);
$user = $stmt->fetch();
```

```php
<?php
// WordPress $wpdb->prepare
$results = $wpdb->get_results(
    $wpdb->prepare("SELECT * FROM {$wpdb->users} WHERE ID = %d", $user_id)
);
```

```php
// Laravel Eloquent — tự bind
$users = User::where('email', $request->email)->get();  // safe
// Hoặc whereRaw có binding
$products = DB::table('products')->whereRaw('name LIKE ?', ['%'.$term.'%'])->get();
```

```php
// Whitelist enum cho ORDER BY (cột không bind được)
$allowed = ['name', 'created_at', 'price'];
$sort = $request->input('sort', 'created_at');
if (!in_array($sort, $allowed, true)) {
    abort(400);
}
$users = DB::table('users')->orderBy($sort)->get();  // safe
```

## Fix recommendation

1. **PDO prepare** mọi query có biến:
   ```php
   // BAD
   $pdo->query("SELECT * FROM u WHERE id=$id");
   // GOOD
   $stmt = $pdo->prepare("SELECT * FROM u WHERE id=:id");
   $stmt->execute(['id' => $id]);
   ```
2. **Laravel**: ưu tiên Eloquent / Query Builder. Nếu phải raw, dùng placeholder:
   ```php
   DB::select('SELECT * FROM u WHERE id = ?', [$id]);
   DB::table('u')->whereRaw('id = ?', [$id]);
   ```
3. **WordPress**: LUÔN dùng `$wpdb->prepare()` với placeholder `%d`, `%s`, `%f`.
4. **Tham số không bind được** (table name, ORDER direction): whitelist `in_array($val, $allowed, true)`.
5. **Tránh `mysqli_real_escape_string`** làm sanitization chính — dùng prepared statement.
6. **Tắt error display trên prod** (cross-ref VERBOSE-ERROR rule) — leak query giúp attacker exploit nhanh.
7. **DB user least privilege**: app user không có DROP / GRANT / FILE.

## Cross-references

- Rule `17-verbose-error-debug-mode`: `APP_DEBUG=true` Laravel hiện full SQL trên Ignition error page → leak schema
- Rule `08-insecure-deserialization`: `unserialize` + SQLi = stored exploit nguy hiểm
- Rule `07-mass-assignment`: Laravel `$fillable` thiếu = update field nhạy cảm qua mass assignment
- Rule `04-idor`: SQLi + no auth = nuke DB
rea-analysis-optimizationmorluto/reaOptimize REA providers and shared analysis workflows for agent context, latency, CPU, and memory while preserving correctness and Evidence. Use for analysis bottlenecks and cache or query design; CI/test-suite optimization belongs to rea-ci-tests-audit.Stars: 470kUpdated Claude CodeCodexVerifiedInstall
rea-ci-tests-auditmorluto/reaAudit REA CI and test suites for correctness, fixture drift, false passes, and measured performance; use for suite or workflow investigations and efficiency changes, rather than ordinary feature testing or a single test failure.Stars: 470kUpdated Claude CodeCodexVerifiedInstall
rea-tool-designmorluto/reaAudit, investigate, design, or change REA investigation tools, CLI/MCP contracts, provider capabilities, and Evidence semantics.Stars: 470kUpdated Claude CodeCodexVerifiedInstall
ponytail-auditDietrichGebert/ponytailQuality audit of the whole repo: bugs, security, real load, missing tests, speed, and what to delete. Most important first.Stars: 194kUpdated Claude CodeCodexVerifiedInstall