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

View on GitHub
---
id: SQL-INJECTION
severity_max: CRITICAL
applies_to: dotnet
overrides: generic/02-sql-injection.md
---

# SQL Injection — .NET 10 / EF Core Specialization

> Override cho rule chung `rules/generic/02-sql-injection.md`. Áp dụng khi `primary_language: dotnet`.

## Intent (.NET-specific)

.NET 10 / ASP.NET Core app thường dùng EF Core, Dapper hoặc ADO.NET. EF Core query LINQ typed thường safe, nhưng các API raw SQL như `FromSqlRaw`, `ExecuteSqlRaw`, `SqlQueryRaw`, Dapper `Query($"...")`, hoặc `SqlCommand.CommandText` ghép string vẫn tạo SQL Injection nếu nhận dữ liệu từ route/query/body. Vibe code hay nhầm interpolated string trong `FromSqlRaw($"...{input}...")` là parameterized, nhưng thực tế string đã được build trước khi EF nhận query.

## Khi nào CRITICAL

- `FromSqlRaw`, `ExecuteSqlRaw`, `SqlQueryRaw` nhận interpolated string, concat, `string.Format`, hoặc `$"...{input}..."`.
- ADO.NET `new SqlCommand("... " + input, conn)` hoặc `cmd.CommandText = $"...{input}..."` mà không dùng `SqlParameter`.
- Dapper `Query`, `Execute`, `QueryAsync` nhận SQL string build từ L1 mà không có anonymous object params.
- Input từ ASP.NET Core route/query/body/header/form đi vào raw SQL public endpoint.
- Dynamic `ORDER BY`, table name, column name nhận trực tiếp từ request mà không whitelist.

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

- Endpoint chỉ admin gọi được nhưng vẫn dùng raw SQL unsafe.
- Input đã ép kiểu mạnh trước khi concat (`int.TryParse`) nhưng vẫn nên parameterize.
- Dynamic identifier đã qua whitelist rõ ràng thì không flag; nếu whitelist thiếu chặt, downgrade thay vì CRITICAL.
- Query chỉ chạy trong migration/seed/test code, không reachable từ request.

## Cách reasoning

1. Grep raw SQL sink: `FromSqlRaw`, `ExecuteSqlRaw`, `SqlQueryRaw`, `SqlCommand`, Dapper `Query/Execute`.
2. Read controller/minimal API/service chứa sink.
3. Trace biến trong SQL string:
   - ASP.NET Core action parameter, `HttpContext.Request.Query`, `[FromBody]`, `[FromForm]`, route `{id}` → L1.
   - DB record dùng lại trong SQL → L2.
   - config/env/internal enum → L3.
   - constant string → L4.
4. Verify mitigation:
   - EF Core: `FromSql` / `FromSqlInterpolated` với interpolation parameterized.
   - ADO.NET: `cmd.Parameters.Add(...)` / `AddWithValue(...)`.
   - Dapper: `connection.Query(sql, new { id })`.
   - Identifier dynamic: allowlist enum/map.
5. Chỉ flag khi L1/L2 đi vào SQL sink mà không parameterize/whitelist.

## Search patterns

```
# EF Core raw SQL
\.FromSqlRaw\s*\(\s*\$
\.FromSqlRaw\s*\(\s*["'][^"']*["']\s*\+
\.ExecuteSqlRaw(Async)?\s*\(\s*\$
\.SqlQueryRaw\s*<[^>]+>\s*\(\s*\$

# ADO.NET
new\s+SqlCommand\s*\(\s*\$
new\s+SqlCommand\s*\(\s*["'][^"']*["']\s*\+
\.CommandText\s*=\s*\$
\.CommandText\s*\+=

# Dapper
\.(Query|QueryAsync|Execute|ExecuteAsync)\s*\(\s*\$
\.(Query|QueryAsync|Execute|ExecuteAsync)\s*\(\s*["'][^"']*["']\s*\+

# String helpers near SQL
string\.Format\s*\(\s*["'][^"']*(SELECT|INSERT|UPDATE|DELETE)
\$["'][^"']*(SELECT|INSERT|UPDATE|DELETE)[^"']*\{
```

## Examples

### CRITICAL — flag

```csharp
// ASP.NET Core Minimal API + EF Core FromSqlRaw
app.MapGet("/users", async (string name, AppDbContext db) =>
{
    return await db.Users
        .FromSqlRaw($"SELECT * FROM Users WHERE Name = '{name}'")
        .ToListAsync();
});
```

```csharp
// ExecuteSqlRawAsync với body input
[HttpDelete]
public Task Delete([FromBody] DeleteUserRequest req)
{
    return _db.Database.ExecuteSqlRawAsync(
        $"DELETE FROM Users WHERE Email = '{req.Email}'");
}
```

```csharp
// ADO.NET CommandText concat
var id = HttpContext.Request.Query["id"];
using var cmd = new SqlCommand("SELECT * FROM Orders WHERE Id = " + id, conn);
using var reader = cmd.ExecuteReader();
```

```csharp
// Dapper without params
var sort = Request.Query["sort"].ToString();
var rows = await connection.QueryAsync<Order>(
    $"SELECT * FROM Orders ORDER BY {sort}");
```

### NOT critical — không flag

```csharp
// EF Core FromSql parameterizes interpolated values
var users = await db.Users
    .FromSql($"SELECT * FROM Users WHERE Name = {name}")
    .ToListAsync();
```

```csharp
// Explicit interpolated API
var users = await db.Users
    .FromSqlInterpolated($"SELECT * FROM Users WHERE Email = {email}")
    .ToListAsync();
```

```csharp
// ADO.NET parameter
using var cmd = new SqlCommand("SELECT * FROM Orders WHERE Id = @id", conn);
cmd.Parameters.Add("@id", SqlDbType.Int).Value = id;
```

```csharp
// Dapper parameter object
var rows = await connection.QueryAsync<Order>(
    "SELECT * FROM Orders WHERE CustomerId = @customerId",
    new { customerId });
```

```csharp
// Dynamic ORDER BY with allowlist
var allowed = new Dictionary<string, string>
{
    ["created"] = "CreatedAt",
    ["name"] = "Name"
};
if (!allowed.TryGetValue(sort, out var col)) col = "CreatedAt";
var sql = $"SELECT * FROM Users ORDER BY {col}";
```

## Fix recommendation

1. EF Core: dùng `FromSql` hoặc `FromSqlInterpolated` cho value parameters; tránh `FromSqlRaw` với user input.
2. `ExecuteSqlRaw` chỉ dùng với placeholders + params, hoặc chuyển sang `ExecuteSql`/`ExecuteSqlInterpolated`.
3. ADO.NET: dùng `SqlParameter`, không concat vào `CommandText`.
4. Dapper: truyền anonymous object params, không build SQL từ request.
5. Với table/column/order dynamic: map từ allowlist hardcoded, không nhận string trực tiếp từ request.

## Cross-references

- `07-mass-assignment`: ASP.NET Core model binding cũng là đường L1 phổ biến.
- `17-verbose-error-debug-mode`: SQL error/stack trace leak giúp attacker refine payload.
- `04-idor`: SQLi cộng thiếu ownership check có thể dump dữ liệu tenant khác.
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