codeql
Comprehensive guide for setting up and configuring CodeQL code scanning via GitHub Actions workflows and the CodeQL CLI. This skill should be used when users need help with code scanning configuration, CodeQL workflow files, CodeQL CLI commands, SARIF output, security analysis setup, or troubleshoot
By github · 1,978 installs
npx skills add github/awesome-copilot --skill codeql
Source repository · Upstream listing
CodeQL Code Scanning
This skill provides procedural guidance for configuring and running CodeQL code scanning — both through GitHub Actions workflows and the standalone CodeQL CLI.
When to Use This Skill
Use this skill when the request involves:
Creating or customizing a codeql.yml GitHub Actions workflow
Choosing between default setup and advanced setup for code scanning
Configuring CodeQL language matrix, build modes, or query suites
Running CodeQL CLI locally ( codeql database create , database analyze , github upload results )
Understanding or interpreting SARIF output from CodeQL
Troubleshooting CodeQL analysis failures (build modes, compiled languages, runner requirements)
Setting up CodeQL for monorepos with per component scanning
Configuring dependency caching, custom query packs, or model packs
Supported Languages
CodeQL supports the following language identifiers:
Language Identifier Alternatives
C/C++ c cpp c , cpp
C csharp —
Go go —
Java/Kotlin java kotlin java , kotlin
JavaScript/TypeScript javascript typescript javascript , typescript
Python python —
Ruby ruby —
Rust rust —
Swift swift —
GitHub Actions actions —
Alternative identifiers are equivalent to the standard identifier (e.g., javascript does not exclude TypeScript analysis).
Core Workflow — GitHub Actions
Step 1: Choose Setup Type
Default setup — Enable from repository Settings → Advanced Security → CodeQL analysis. Best for getting started quickly. Uses none build mode for most languages.
Advanced setup — Create a .github/workflows/codeql.yml file for full control over triggers, build modes, query suites, and matrix strategies.
To switch from default to advanced: disable default setup first, then commit the workflow file.
Step 2: Configure Workflow Triggers
Define when scanning runs:
push — scans on every push to specified branches; results appear in Security tab
pull request — scans PR merge commits; results appear as PR check annotations
schedule — periodic scans of the default branch (cron must exist on default branch)
merge group — add if repository uses merge queues
To skip scans for documentation only PRs:
paths ignore controls whether the workflow runs, not which files are analyzed.
Step 3: Configure Permissions
Set least privilege permissions:
Step 4: Configure Language Matrix
Use a matrix strategy to analyze each language in parallel:
For compiled languages, set the appropriate build mode :
none — no build required (supported for C/C++, C , Java, Rust)
autobuild — automatic build detection
manual — custom build commands (advanced setup only)
For detailed per language autobuild behavior and runner requirements, search references/compiled languages.md .
Step 5: Configure CodeQL Init and Analysis
Query suite options:
security extended — default security queries plus additional coverage
security and quality — security plus code quality queries
Custom query packs via packs: input (e.g., codeql/javascript queries:AlertSuppression.ql )
Dependency caching: Set dependency caching: true on the init action to cache restored dependencies across runs.
Analysis category: Use category to distinguish SARIF results in monorepos (e.g., per language, per component).
Step 6: Monorepo Configuration
For monorepos with multiple components, use the category parameter to separate SARIF results:
To restrict analysis to specific directories, use a CodeQL configuration file ( .github/codeql/codeql config.yml ):
Reference it in the workflow:
Step 7: Manual Build Steps (Compiled Languages)
If autobuild fails or custom build commands are needed:
Then add explicit build steps between init and analyze :
Core Workflow — CodeQL CLI
Step 1: Install the CodeQL CLI
Download the CodeQL bundle (includes CLI + precompiled queries):
Always use the CodeQL bundle, not a standalone CLI download. The bundle ensures query compatibility and provides precompiled queries for better performance.
Step 2: Create a CodeQL Database
For compiled languages, provide the build command via command .
Step 3: Analyze the Database
Common query suites: <language code scanning.qls , <language security extended.qls , <language security and quality.qls .
Step 4: Upload Results to GitHub
Requires GITHUB TOKEN environment variable with security events: write permission.
CLI Server Mode
To avoid repeated JVM initialization when running multiple commands:
For detailed CLI command reference, search references/cli commands.md .
Alert Management
Severity Levels
Alerts have two severity dimensions:
Standard severity: Error , Warning , Note
Security severity: Critical , High , Medium , Low (derived from CVSS scores; takes display precedence)
Copilot Autofix
GitHub Copilot Autofix generates fix suggestions for CodeQL alerts in pull requests automatically — no Copilot subscription required. Review suggestions carefully before committing.
Alert Triage in PRs
Alerts appear as check annotations on changed lines
Check fails by default for error / critical / high severity alerts
Configure merge protection rulesets to customize the threshold
Dismiss false positives with a documented reason for audit trail
For detailed alert management guidance, search references/alert management.md .
Custom Queries and Packs
Using Custom Query Packs
Creating Custom Query Packs
Use the CodeQL CLI to create and publish packs:
CodeQL Configuration File
For advanced query and path configuration, create .github/codeql/codeql config.yml :
Code Scanning Logs
Summary Metrics
Workflow logs include key metrics:
Lines of code in codebase — baseline before extraction
Lines extracted — including external libraries and auto generated files
Extraction errors/warnings — files that failed or produced warnings during extraction
Debug Logging
To enable detailed diagnostics:
GitHub Actions: re run the workflow with "Enable debug logging" checked
CodeQL CLI: use verbosity=progress++ and logdir=codeql logs
Troubleshooting
Common Issues
Problem Solution
Workflow not triggering Verify on: triggers match event; check paths / branches filters; ensure workflow exists on target branch
Resource not accessible error Add security events: write and contents: read permissions
Autobuild failure Switch to build mode: manual and add explicit build commands
No source code seen Verify source root , build command, and language identifier
C compiler failure Check for /p:EmitCompilerGeneratedFiles=true conflicts with .sqlproj or legacy projects
Fewer lines scanned than expected Switch from none to autobuild / manual ; verify build compiles all source
Kotlin in no build mode Disable and re enable default setup to switch to autobuild
Cache miss every run Verify dependency caching: true on init action
Out of disk/memory Use larger runners; reduce analysis scope via paths config; use build mode: none
SARIF upload fails Ensure token has security events: write ; check 10 MB file size limit
SARIF results exceed limits Split across multiple uploads with different sarif category ; reduce query scope
Two CodeQL workflows Disable default setup if using advanced setup, or remove old workflow file
Slow analysis Enable dependency caching; use threads=0 ; reduce query suite scope
For comprehensive troubleshooting with detailed solutions, search references/troubleshooting.md .
Hardware Requirements (Self Hosted Runners)
Codebase Size RAM CPU
Small (<100K LOC) 8 GB+ 2 cores
Medium (100K–1M LOC) 16 GB+ 4–8 cores
Large ( 1M LOC) 64 GB+ 8 cores
All sizes: SSD with ≥14 GB free disk space.
Action Versioning
Pin CodeQL actions to a specific major version:
For maximum security, pin to a full commit SHA instead of a version tag.
Reference Files
For detailed documentation, load the following reference files as needed:
references/workflow configuration.md — Full workflow trigger, runner, and configuration options
Search patterns: trigger , schedule , paths ignore , db location , model packs , alert severity , merge protection , concurrency , config file
references/cli commands.md — Complete CodeQL CLI command reference
Search patterns: database create , database analyze , upload results , resolve packs , cli server , installation , CI integration
references/sarif output.md — SARIF v2.1.0 object model, upload limits, and third party support
Search patterns: sarifLog , result , location , region , codeFlow , fingerprint , suppression , upload limits , third party , precision , security severity
references/compiled languages.md — Build modes and autobuild behavior per language
Search patterns: C/C++ , C , Java , Go , Rust , Swift , autobuild , build mode , hardware , dependency caching
references/troubleshooting.md — Comprehensive error diagnosis and resolution
Search patterns: no source code , out of disk , out of memory , 403 , C compiler , analysis too long , fewer lines , Kotlin , extraction errors , debug logging , SARIF upload , SARIF limits
references/alert management.md — Alert severity, triage, Copilot Autofix, and dismissal
Search patterns: severity , security severity , CVSS , Copilot Autofix , dismiss , triage , PR alerts , data flow , merge protection , REST API