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/go/02-sql-injection.md

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

# SQL Injection (Go)

## Intent

Trong Go, lỗ hổng SQLi xuất hiện khi **L1 input** (chi.URLParam, gin Context.Query, mux.Vars, fiber Ctx.Params) được ghép thẳng vào câu SQL bằng `fmt.Sprintf` hoặc string `+`, thay vì dùng placeholder `?` / `$1` của `database/sql` hoặc parameterized API của GORM. Attacker dump DB, escalate, hoặc đọc file qua `LOAD_FILE`.

Go có vẻ "an toàn" hơn vì stdlib ép placeholder, **nhưng GORM `Raw()`, `Exec()`, `Where(string,...)` với string concat** vẫn vibe code rất hay sinh sai.

## Khi nào CRITICAL

- L1 input ghép vào `db.Raw(fmt.Sprintf(...))`, `db.Exec(fmt.Sprintf(...))`, `db.Query(fmt.Sprintf(...))`
- `gorm.DB.Where("name = " + userInput)` (truyền 1 string đã concat thay vì pattern `Where("name = ?", val)`)
- Raw query trên `*sql.DB` với `fmt.Sprintf("SELECT ... %s", userInput)`
- Endpoint dùng router public (chi, gin, echo, fiber, gorilla/mux, stdlib `net/http`) không có middleware auth

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

- Input trace về env var / config (L3) không phải request
- Đã có whitelist (`if !slices.Contains(allowedCols, col) { return err }`) trước khi nhét vào ORDER BY
- Endpoint chỉ admin (middleware check role qua context value)

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

1. **Grep** các sink: `db.Raw`, `db.Exec`, `db.Query`, `.QueryRow`, `.Where(`, `tx.Raw`
2. **Read** handler chứa call: trace biến từ `chi.URLParam`, `c.Query`, `c.Param`, `r.FormValue`, `mux.Vars(r)`, `c.Params(...)` (fiber)
3. **Trace L1→sink**:
   - Goroutine? Channel? Vẫn L1 nếu nguồn gốc là request.
   - Struct field nhận qua `c.BindJSON(&payload)` — vẫn L1 (mass-assignment cross-check)
   - GORM `Find(&users, "id = ?", id)` — placeholder, safe
   - GORM `Find(&users, fmt.Sprintf("id = %d", id))` — NGUY HIỂM dù `%d` cũng có thể bị bypass nếu interface{} là string
4. **Verify**: có dùng `?` / `$1` separator? Có whitelist trước concat?

## Search patterns (Go-specific)

```
# GORM raw query với fmt.Sprintf
\.(Raw|Exec|Query|QueryRow)\s*\(\s*fmt\.Sprintf
\.(Raw|Exec)\s*\(\s*`[^`]*\$\{          # rare, but template strings exist
\.(Raw|Exec|Query)\s*\(\s*"[^"]*"\s*\+

# GORM Where với string concat (BAD)
\.Where\s*\(\s*fmt\.Sprintf
\.Where\s*\(\s*"[^"]*"\s*\+

# database/sql với Sprintf
db\.(Query|Exec|QueryRow|QueryContext|ExecContext)\s*\(\s*fmt\.Sprintf

# sqlx
\.NamedQuery\s*\(\s*fmt\.Sprintf
\.Select\s*\(.*fmt\.Sprintf

# Sink nguy hiểm khác
\.Order\s*\(\s*[^"]*userInput     # GORM Order với user input không whitelist
\.Group\s*\(.*\+
```

## Examples

### CRITICAL — flag

```go
// chi router + GORM
func GetUser(w http.ResponseWriter, r *http.Request) {
    name := chi.URLParam(r, "name")  // L1
    var users []User
    db.Raw(fmt.Sprintf("SELECT * FROM users WHERE name='%s'", name)).Scan(&users)
}
```

```go
// gin + GORM Where string concat
func ListProducts(c *gin.Context) {
    q := c.Query("q")  // L1
    var products []Product
    db.Where("name LIKE '%" + q + "%'").Find(&products)  // BAD
}
```

```go
// fiber + database/sql
func handler(c *fiber.Ctx) error {
    id := c.Params("id")  // L1
    row := sqlDB.QueryRow(fmt.Sprintf("SELECT * FROM accounts WHERE id=%s", id))
    // ...
}
```

```go
// echo + sqlx
func search(c echo.Context) error {
    term := c.QueryParam("term")  // L1
    sqlxDB.Select(&results, "SELECT * FROM items WHERE title='"+term+"'")
    return c.JSON(200, results)
}
```

### NOT critical — safe

```go
// Parameterized — safe
db.Where("name = ?", name).Find(&users)
db.Raw("SELECT * FROM users WHERE id = ?", id).Scan(&u)
sqlDB.QueryRow("SELECT * FROM accounts WHERE id = $1", id)
```

```go
// Whitelist trước ORDER BY (cột không bind được)
allowed := map[string]bool{"name": true, "created_at": true, "price": true}
sort := c.Query("sort")
if !allowed[sort] {
    c.JSON(400, gin.H{"error": "bad sort"})
    return
}
db.Order(sort).Find(&products)  // safe vì whitelist
```

```go
// Struct embedding với gorm:"-" tránh mass-assignment nhưng KHÔNG fix SQLi nếu raw query vẫn concat
type User struct {
    ID   uint
    Role string `gorm:"-"`  // skip column, không liên quan SQLi
}
```

## Fix recommendation

1. **Luôn dùng placeholder `?` (GORM/MySQL) hoặc `$1, $2` (Postgres pgx):**
   ```go
   // BAD
   db.Raw(fmt.Sprintf("SELECT * FROM u WHERE id=%d", id))
   // GOOD
   db.Raw("SELECT * FROM u WHERE id = ?", id).Scan(&u)
   ```
2. **GORM idiomatic**: dùng `Where("col = ?", val)`, `First(&u, id)`, struct queries. Tránh `Raw` trừ khi cần.
3. **Tên cột / ORDER BY**: whitelist với `map[string]bool` hoặc `slices.Contains`.
4. **`context.Context`** không liên quan trực tiếp nhưng dùng `QueryContext` để hủy query lỗi nhanh, giảm thời gian tấn công.
5. **Defense in depth**: DB user least privilege, bật slow query log, dùng read-replica cho query SELECT.

## Cross-references

- Rule `17-verbose-error-debug-mode`: GORM error trả về SQL string nếu `c.String(500, err.Error())` — leak schema
- Rule `07-mass-assignment`: `c.BindJSON(&user)` cho phép set field `Role` → cross-check
- Rule `04-idor`: SQLi + no ownership check = 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: 471kUpdated 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: 471kUpdated Claude CodeCodexVerifiedInstall
rea-tool-designmorluto/reaAudit, investigate, design, or change REA investigation tools, CLI/MCP contracts, provider capabilities, and Evidence semantics.Stars: 471kUpdated 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