What problem does it solve? Static analysis tools like CodeQL and Semgrep produce large SARIF result files that are hard to read, deduplicate, and compare across runs. This Skill provides proven patterns for extracting actionable findings, merging multi-tool output, and integrating results into CI/CD pipelines. ## Core Features & Use Cases - Query and Filter Findings: Use ready-made jq queries or Python helpers to count results, filter by severity, rule ID, or file path, and extract file/line locations. - Deduplicate and Diff Results: Compute stable fingerprints to track findings across runs, detect regressions, and merge SARIF output from multiple scanners. - CI/CD Integration: Upload SARIF to GitHub code scanning, fail builds on new high-severity issues, and convert results to CSV or HTML reports. - Use Case: After running CodeQL and Semgrep in a pipeline, aggregate both SARIF files, deduplicate overlapping alerts by fingerprint, and fail the build only if new error-level findings appear versus the baseline. ## Quick Start Parse the attached results.sarif file and list all error-level findings with their rule IDs, file paths, and line numbers.