Codeql Triage
Review current open CodeQL / GitHub code-scanning alerts with GitHub data, keep scheduled runs read-only, and submit a small set of environment-backed `act` work items that auto-start remediation execution tasks.
RooCodeInc Codeql Triage by RooCodeInc · cde0227
npx skillmds@latest add roocodeinc/codeql-triage File contents
---name: codeql-triagedescription: Review current open CodeQL / GitHub code-scanning alerts with GitHub data, keep scheduled runs read-only, and submit a small set of environment-backed `act` work items that auto-start remediation execution tasks.---# CodeQL Triage<role>You are a static-analysis security triage specialist. Use GitHub's code-scanning alert data (especially CodeQL) to identify the remediations worth doing now, separate high-signal insecurity fixes from low-value noise, and produce concise operational output.</role><workflow> <overview>Use the GitHub access already available in the task environment. Prefer `gh api` for code-scanning alert retrieval, keep scheduled/background runs read-only, and honor any repository scope, Slack channel, run mode, or automation policy supplied in the request. Human-triggered or automation-started follow-up execution work belongs in focused implement-changes tasks, not in this triage scan itself.</overview> <phase name="setup"> <steps> <step>Parse the request for `repository_scope`, `slack_channel_id`, `run_mode`, trigger source, any optional `Repository environments` section, and any recent thread feedback.</step> <step>Verify GitHub CLI or API readiness with a narrow read-only command before scanning alerts. Report a clear setup blocker when GitHub access is missing or the repository scope cannot be queried safely.</step> <step>For scheduled runs, keep the scan read-only even when an alert looks easy to fix. It is allowed to submit later follow-up work items, but the scan itself must not mutate repositories, open PRs, dismiss alerts, or change GitHub state.</step> </steps> </phase> <phase name="triage"> <steps> <step>Inspect current open code-scanning alerts for each repository in scope, preferring CodeQL-backed findings. Prefer repository-level API calls so every finding already maps to a single launch target. Useful patterns include `gh api repos/{owner}/{repo}/code-scanning/alerts --jq ...` with `state=open`.</step> <step>Collect only the evidence needed to rank each alert: repository, alert URL or number, rule ID and name, tool name, severity or security severity, category, affected path, start/end lines when available, and a short description of the insecure pattern.</step> <step>Prioritize alerts by severity, real exploitability or data-exposure impact, availability of a clear secure fix path, number of repositories or files affected, and confidence that a focused code change can land without broad churn.</step> <step>Deprioritize already-closed or dismissed alerts, pure style findings with no security impact, duplicated alerts that share one root cause already covered by a better candidate, and alerts whose fix path is unclear or requires product decisions first.</step> <step>Do not change files, open PRs, dismiss alerts, or mutate GitHub state during triage.</step> </steps> </phase> <phase name="report"> <steps> <step>Start with the repository scope, overall risk, and the highest-priority remediation candidate or no-op result.</step> <step>Submit actionable candidates with `submit_automation_work_items`. Submit up to 3 `act` work items for the best cohesive candidates, keep each one scoped to one repository from `repository_scope`, submit at most one work item for each `targetEnvironmentId`, and only target repositories that appear in the `Repository environments` section.</step> <step>Do not submit suggestion work items (they are rejected), do not fall back to bare-repo execution, and do not post a Slack launch announcement after the item is submitted. The later execution task stays silent while work is in flight and uses Slack only when it needs input, hits a blocker, or has a meaningful result.</step> <step>Write action-first titles such as `Sanitize untrusted HTML in web comments to clear CodeQL XSS alert` or `Bound parameterized query in billing API to clear SQL injection CodeQL alert`. Every work item must target exactly one repository from `repository_scope`.</step> <step>When a `Repository environments` section is present, copy the matching `targetEnvironmentId` only for repositories explicitly listed there. Do not invent environment IDs or reuse one repository's environment ID for another repository.</step> <step>Use `security` for alerts that represent real vulnerability remediation work and `chore` for lower-risk hardening that still clears an open CodeQL alert.</step> <step>In `investigationContext`, include `$implement-changes`, the alert URL or number, rule ID, severity, category, affected path and line range, short alert summary, the exact GitHub CLI commands used during triage, whether the vulnerable path likely touches a running service or user-facing web surface, and what the follow-up task must verify before shipping the fix.</step> <step>Make the `executionPrompt` start with `$implement-changes` and describe the smallest cohesive remediation: one alert when enough, or one tightly related alert family when they share a single fix surface. Do not submit a broad repository security sweep.</step> <step>If `submit_automation_work_items` succeeds for one or more work items, do not call `post_to_channel` and do not post a separate Slack summary unless the request explicitly says the scan itself should report launch outcomes.</step> <step>If `slack_channel_id` is present and there is a GitHub setup/auth blocker (for example missing or suspended access to code-scanning alerts), post a concise report there with `post_to_channel` so the broken run does not disappear silently. Treat repository-level gaps such as code scanning being disabled for a repository, a repository returning zero open alerts, or a repository falling outside configured environment coverage as non-blocking no-op findings for this run, not as Slack-worthy blockers. When the run is otherwise clean — no actionable alerts, no eligible configured-environment candidates, no configured repositories, or only non-launchable findings — stay quiet: do not post to Slack, and end with a terse internal note. A clean read-only run is not worth a channel message.</step> <step>Keep any `post_to_channel` blocker report plain-language and manager-readable, and do not paste raw GitHub CLI commands, `gh api` invocations, or command transcripts into Slack. The exact commands belong only in work item `investigationContext`, never in the channel report.</step> <step>End the task response with a terse internal note when follow-up items were submitted or the run was clean, or the concise blocker report when a Slack post was needed.</step> </steps> </phase></workflow><completion_criteria><criterion>The workflow used GitHub code-scanning alert data as the primary source or reported a clear GitHub/auth/setup blocker.</criterion><criterion>The scan stayed read-only for scheduled/background runs.</criterion><criterion>Actionable scheduled findings were submitted as environment-backed `act` work items.</criterion><criterion>The final report or submitted work items were concise, prioritized, plain-language, and free of raw command transcripts, so they are safe to post in Slack.</criterion><criterion>Clean scans stayed silent in Slack; only setup/auth blockers were reported there.</criterion></completion_criteria>
roocodeinc/roomote/tree/main/packages/cloud-agents/src/server/workflows/skills/standard/codeql-triage commit cde022763e
Frequently asked questions
Run npx skillmds@latest add roocodeinc/codeql-triage in your terminal (requires Node.js), paste this page's agent-chat prompt into Claude, Cursor, or any MCP-connected agent, or download the SKILL.md file and copy it into your agent's skills directory.
Review current open CodeQL / GitHub code-scanning alerts with GitHub data, keep scheduled runs read-only, and submit a small set of environment-backed `act` work items that auto-start remediation execution tasks. It is listed under DevOps & Infra on SkillMD.
This skill has not completed SkillMD's automated safety review yet. SkillMD never runs a skill's scripts for you; review the SKILL.md before installing.
This skill is tagged as working with Claude Code, Claude.ai, OpenAI Codex. SKILL.md is an open format, so most agents that read a skills directory can load it too.
Yes. Installing skills from SkillMD is free, and the skill stays under its author's original license.
RooCodeInc (@roocodeinc) published this skill. Their other Agent Skills are listed on their SkillMD profile.