detecting-sql-injection-via-waf-logs

Detect SQL injection attempts in WAF logs and produce structured findings.

Updated Apr 23, 2026
One-click install
npx skills add https://github.com/YukiIto1999/ctf-sleuth --skill detecting-sql-injection-via-waf-logs
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: detecting-sql-injection-via-waf-logs
Source: https://github.com/YukiIto1999/ctf-sleuth/tree/main/.claude/skills/detecting-sql-injection-via-waf-logs
Command: npx skills add https://github.com/YukiIto1999/ctf-sleuth --skill detecting-sql-injection-via-waf-logs

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) and references (resource) components.

What problem does it solve?

Identify SQL injection attempts in WAF logs and produce structured findings.

Core Features & Use Cases

  • Parse ModSecurity audit logs and JSON WAF logs to extract requests, IPs, and rule IDs.
  • Classify SQLi patterns using a broad set of regex rules and map to standard injection types.
  • Correlate multiple requests by source IP to identify campaigns and provide both human-readable reports and machine-readable outputs.

Quick Start

Run the agent against your WAF log file to generate a sqli_report.json.

Frequently Asked Questions about detecting-sql-injection-via-waf-logs

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I detect SQL injection attempts from WAF logs?

Detect SQL injection in WAF logs by parsing request data and applying regex rules to identify malicious patterns. The Skill extracts IPs and rule IDs to classify injections and outputs structured findings for security operations.

Can I analyze AWS WAF and Cloudflare logs for SQLi campaigns?

Yes, AWS WAF and Cloudflare logs are supported alongside ModSecurity audit logs. The Skill parses JSON WAF logs and correlates multiple requests by source IP to identify coordinated SQLi campaigns across these platforms.

How does source IP correlation work for identifying SQLi campaigns?

Source IP correlation groups multiple WAF log requests originating from the same address to detect coordinated SQLi campaigns. This process transforms isolated event logs into structured campaign findings with human-readable reports.

What is the best way to extract rule IDs and requests from ModSecurity audit logs?

The best way to extract rule IDs and requests from ModSecurity audit logs is using modular parsing logic. This approach isolates relevant transaction fields, enabling regex-based SQLi detection and accurate mapping to standard injection types.

Do I need to provide machine-readable outputs for SQLi detection?

You do not need to manually provide outputs; the Skill generates both human-readable reports and machine-readable JSON files. Running the agent against your WAF log file automatically produces a structured sqli_report.json.

SQLi detection in WAF logs is not mapping to standard injection types, what are the limitations?

Limitations in mapping to standard injection types stem from regex rule coverage and log format variations. If WAF logs lack complete request payloads, modular parsing cannot fully classify complex or obfuscated SQLi patterns.