Skip to main content

review

Analyzes pull requests for SQL safety and structural issues, ensuring code quality before merging.

Install this skill

or
0/100

Security score

The review skill was audited on May 12, 2026 and we found 102 security issues across 4 threat categories. Review the findings below before installing.

Categories Tested

Security Issues

medium line 31

Template literal with variable interpolation in command context

SourceSKILL.md
31```bash
medium line 264

Template literal with variable interpolation in command context

SourceSKILL.md
264```bash
medium line 360

Template literal with variable interpolation in command context

SourceSKILL.md
360```bash
medium line 394

Template literal with variable interpolation in command context

SourceSKILL.md
394echo "before relying on \`gbrain search\` for code questions in this worktree."
medium line 522

Template literal with variable interpolation in command context

SourceSKILL.md
522```bash
medium line 863

Template literal with variable interpolation in command context

SourceSKILL.md
863```bash
medium line 1211

Template literal with variable interpolation in command context

SourceSKILL.md
1211```bash
medium line 1570

Template literal with variable interpolation in command context

SourceSKILL.md
1570```bash
low line 32

Access to hidden dotfiles in home directory

SourceSKILL.md
32_UPD=$(~/.claude/skills/gstack/bin/gstack-update-check 2>/dev/null || .claude/skills/gstack/bin/gstack-update-check 2>/dev/null || true)
low line 34

Access to hidden dotfiles in home directory

SourceSKILL.md
34mkdir -p ~/.gstack/sessions
low line 35

Access to hidden dotfiles in home directory

SourceSKILL.md
35touch ~/.gstack/sessions/"$PPID"
low line 36

Access to hidden dotfiles in home directory

SourceSKILL.md
36_SESSIONS=$(find ~/.gstack/sessions -mmin -120 -type f 2>/dev/null | wc -l | tr -d ' ')
low line 37

Access to hidden dotfiles in home directory

SourceSKILL.md
37find ~/.gstack/sessions -mmin +120 -type f -exec rm {} + 2>/dev/null || true
low line 38

Access to hidden dotfiles in home directory

SourceSKILL.md
38_PROACTIVE=$(~/.claude/skills/gstack/bin/gstack-config get proactive 2>/dev/null || echo "true")
low line 39

Access to hidden dotfiles in home directory

SourceSKILL.md
39_PROACTIVE_PROMPTED=$([ -f ~/.gstack/.proactive-prompted ] && echo "yes" || echo "no")
low line 42

Access to hidden dotfiles in home directory

SourceSKILL.md
42_SKILL_PREFIX=$(~/.claude/skills/gstack/bin/gstack-config get skill_prefix 2>/dev/null || echo "false")
low line 46

Access to hidden dotfiles in home directory

SourceSKILL.md
46source <(~/.claude/skills/gstack/bin/gstack-repo-mode 2>/dev/null) || true
low line 49

Access to hidden dotfiles in home directory

SourceSKILL.md
49_LAKE_SEEN=$([ -f ~/.gstack/.completeness-intro-seen ] && echo "yes" || echo "no")
low line 51

Access to hidden dotfiles in home directory

SourceSKILL.md
51_TEL=$(~/.claude/skills/gstack/bin/gstack-config get telemetry 2>/dev/null || true)
low line 52

Access to hidden dotfiles in home directory

SourceSKILL.md
52_TEL_PROMPTED=$([ -f ~/.gstack/.telemetry-prompted ] && echo "yes" || echo "no")
low line 57

Access to hidden dotfiles in home directory

SourceSKILL.md
57_EXPLAIN_LEVEL=$(~/.claude/skills/gstack/bin/gstack-config get explain_level 2>/dev/null || echo "default")
low line 60

Access to hidden dotfiles in home directory

SourceSKILL.md
60_QUESTION_TUNING=$(~/.claude/skills/gstack/bin/gstack-config get question_tuning 2>/dev/null || echo "false")
low line 62

Access to hidden dotfiles in home directory

SourceSKILL.md
62mkdir -p ~/.gstack/analytics
low line 64

Access to hidden dotfiles in home directory

SourceSKILL.md
64echo '{"skill":"review","ts":"'$(date -u +%Y-%m-%dT%H:%M:%SZ)'","repo":"'$(basename "$(git rev-parse --show-toplevel 2>/dev/null)" 2>/dev/null || echo "unknown")'"}' >> ~/.gstack/analytics/skill-usag
low line 66

Access to hidden dotfiles in home directory

SourceSKILL.md
66for _PF in $(find ~/.gstack/analytics -maxdepth 1 -name '.pending-*' 2>/dev/null); do
low line 68

Access to hidden dotfiles in home directory

SourceSKILL.md
68if [ "$_TEL" != "off" ] && [ -x "~/.claude/skills/gstack/bin/gstack-telemetry-log" ]; then
low line 69

Access to hidden dotfiles in home directory

SourceSKILL.md
69~/.claude/skills/gstack/bin/gstack-telemetry-log --event-type skill_run --skill _pending_finalize --outcome unknown --session-id "$_SESSION_ID" 2>/dev/null || true
low line 75

Access to hidden dotfiles in home directory

SourceSKILL.md
75eval "$(~/.claude/skills/gstack/bin/gstack-slug 2>/dev/null)" 2>/dev/null || true
low line 81

Access to hidden dotfiles in home directory

SourceSKILL.md
81~/.claude/skills/gstack/bin/gstack-learnings-search --limit 3 2>/dev/null || true
low line 86

Access to hidden dotfiles in home directory

SourceSKILL.md
86~/.claude/skills/gstack/bin/gstack-timeline-log '{"skill":"review","event":"started","branch":"'"$_BRANCH"'","session":"'"$_SESSION_ID"'"}' 2>/dev/null &
low line 91

Access to hidden dotfiles in home directory

SourceSKILL.md
91_ROUTING_DECLINED=$(~/.claude/skills/gstack/bin/gstack-config get routing_declined 2>/dev/null || echo "false")
low line 102

Access to hidden dotfiles in home directory

SourceSKILL.md
102_CHECKPOINT_MODE=$(~/.claude/skills/gstack/bin/gstack-config get checkpoint_mode 2>/dev/null || echo "explicit")
low line 103

Access to hidden dotfiles in home directory

SourceSKILL.md
103_CHECKPOINT_PUSH=$(~/.claude/skills/gstack/bin/gstack-config get checkpoint_push 2>/dev/null || echo "false")
medium line 111

Access to hidden dotfiles in home directory

SourceSKILL.md
111In plan mode, allowed because they inform the plan: `$B`, `$D`, `codex exec`/`codex review`, writes to `~/.gstack/`, writes to the plan file, and `open` for generated artifacts.
medium line 119

Access to hidden dotfiles in home directory

SourceSKILL.md
119If `SKILL_PREFIX` is `"true"`, suggest/invoke `/gstack-*` names. Disk paths stay `~/.claude/skills/gstack/[skill-name]/SKILL.md`.
medium line 121

Access to hidden dotfiles in home directory

SourceSKILL.md
121If output shows `UPGRADE_AVAILABLE <old> <new>`: read `~/.claude/skills/gstack/gstack-upgrade/SKILL.md` and follow the "Inline upgrade flow" (auto-upgrade if configured, otherwise AskUserQuestion with
medium line 126

Access to hidden dotfiles in home directory

SourceSKILL.md
126- Missing `~/.claude/skills/gstack/.feature-prompted-continuous-checkpoint`: AskUserQuestion for Continuous checkpoint auto-commits. If accepted, run `~/.claude/skills/gstack/bin/gstack-config set che
medium line 127

Access to hidden dotfiles in home directory

SourceSKILL.md
127- Missing `~/.claude/skills/gstack/.feature-prompted-model-overlay`: inform "Model overlays are active. MODEL_OVERLAY shows the patch." Always touch marker.
medium line 140

Access to hidden dotfiles in home directory

SourceSKILL.md
140If B: run `~/.claude/skills/gstack/bin/gstack-config set explain_level terse`.
low line 144

Access to hidden dotfiles in home directory

SourceSKILL.md
144rm -f ~/.gstack/.writing-style-prompt-pending
low line 145

Access to hidden dotfiles in home directory

SourceSKILL.md
145touch ~/.gstack/.writing-style-prompted
low line 154

Access to hidden dotfiles in home directory

SourceSKILL.md
154touch ~/.gstack/.completeness-intro-seen
medium line 167

Access to hidden dotfiles in home directory

SourceSKILL.md
167If A: run `~/.claude/skills/gstack/bin/gstack-config set telemetry community`
medium line 177

Access to hidden dotfiles in home directory

SourceSKILL.md
177If B→A: run `~/.claude/skills/gstack/bin/gstack-config set telemetry anonymous`
medium line 178

Access to hidden dotfiles in home directory

SourceSKILL.md
178If B→B: run `~/.claude/skills/gstack/bin/gstack-config set telemetry off`
low line 182

Access to hidden dotfiles in home directory

SourceSKILL.md
182touch ~/.gstack/.telemetry-prompted
medium line 195

Access to hidden dotfiles in home directory

SourceSKILL.md
195If A: run `~/.claude/skills/gstack/bin/gstack-config set proactive true`
medium line 196

Access to hidden dotfiles in home directory

SourceSKILL.md
196If B: run `~/.claude/skills/gstack/bin/gstack-config set proactive false`
low line 200

Access to hidden dotfiles in home directory

SourceSKILL.md
200touch ~/.gstack/.proactive-prompted
medium line 241

Access to hidden dotfiles in home directory

SourceSKILL.md
241If B: run `~/.claude/skills/gstack/bin/gstack-config set routing_declined true` and say they can re-enable with `gstack-config set routing_declined false`.
medium line 245

Access to hidden dotfiles in home directory

SourceSKILL.md
245If `VENDORED_GSTACK` is `yes`, warn once via AskUserQuestion unless `~/.gstack/.vendoring-warned-$SLUG` exists:
medium line 257

Access to hidden dotfiles in home directory

SourceSKILL.md
2573. Run `~/.claude/skills/gstack/bin/gstack-team-init required` (or `optional`)
medium line 259

Access to hidden dotfiles in home directory

SourceSKILL.md
2595. Tell the user: "Done. Each developer now runs: `cd ~/.claude/skills/gstack && ./setup --team`"
low line 265

Access to hidden dotfiles in home directory

SourceSKILL.md
265eval "$(~/.claude/skills/gstack/bin/gstack-slug 2>/dev/null)" 2>/dev/null || true
low line 266

Access to hidden dotfiles in home directory

SourceSKILL.md
266touch ~/.gstack/.vendoring-warned-${SLUG:-unknown}
low line 369

Access to hidden dotfiles in home directory

SourceSKILL.md
369_BRAIN_SYNC_BIN="~/.claude/skills/gstack/bin/gstack-brain-sync"
low line 370

Access to hidden dotfiles in home directory

SourceSKILL.md
370_BRAIN_CONFIG_BIN="~/.claude/skills/gstack/bin/gstack-config"
medium line 474

Access to hidden dotfiles in home directory

SourceSKILL.md
474If A/B and `~/.gstack/.git` is missing, ask whether to run `gstack-artifacts-init`. Do not block the skill.
low line 479

Access to hidden dotfiles in home directory

SourceSKILL.md
479"~/.claude/skills/gstack/bin/gstack-brain-sync" --discover-new 2>/dev/null || true
low line 480

Access to hidden dotfiles in home directory

SourceSKILL.md
480"~/.claude/skills/gstack/bin/gstack-brain-sync" --once 2>/dev/null || true
low line 523

Access to hidden dotfiles in home directory

SourceSKILL.md
523eval "$(~/.claude/skills/gstack/bin/gstack-slug 2>/dev/null)"
medium line 678

Access to hidden dotfiles in home directory

SourceSKILL.md
678Before each AskUserQuestion, choose `question_id` from `scripts/question-registry.ts` or `{skill}-{slug}`, then run `~/.claude/skills/gstack/bin/gstack-question-preference --check "<id>"`. `AUTO_DECID
low line 682

Access to hidden dotfiles in home directory

SourceSKILL.md
682~/.claude/skills/gstack/bin/gstack-question-log '{"skill":"review","question_id":"<id>","question_summary":"<short>","category":"<approval|clarification|routing|cherry-pick|feedback-loop>","door_type"
low line 691

Access to hidden dotfiles in home directory

SourceSKILL.md
691~/.claude/skills/gstack/bin/gstack-question-preference --write '{"question_id":"<id>","preference":"<pref>","source":"inline-user","free_text":"<optional original words>"}'
medium line 706

Access to hidden dotfiles in home directory

SourceSKILL.md
706Before building anything unfamiliar, **search first.** See `~/.claude/skills/gstack/ETHOS.md`.
low line 711

Access to hidden dotfiles in home directory

SourceSKILL.md
711jq -n --arg ts "$(date -u +%Y-%m-%dT%H:%M:%SZ)" --arg skill "SKILL_NAME" --arg branch "$(git branch --show-current 2>/dev/null)" --arg insight "ONE_LINE_SUMMARY" '{ts:$ts,skill:$skill,branch:$branch,i
low line 729

Access to hidden dotfiles in home directory

SourceSKILL.md
729~/.claude/skills/gstack/bin/gstack-learnings-log '{"skill":"SKILL_NAME","type":"operational","key":"SHORT_KEY","insight":"DESCRIPTION","confidence":N,"source":"observed"}'
medium line 739

Access to hidden dotfiles in home directory

SourceSKILL.md
739`~/.gstack/analytics/`, matching preamble analytics writes.
low line 746

Access to hidden dotfiles in home directory

SourceSKILL.md
746rm -f ~/.gstack/analytics/.pending-"$_SESSION_ID" 2>/dev/null || true
low line 748

Access to hidden dotfiles in home directory

SourceSKILL.md
748~/.claude/skills/gstack/bin/gstack-timeline-log '{"skill":"SKILL_NAME","event":"completed","branch":"'$(git branch --show-current 2>/dev/null || echo unknown)'","outcome":"OUTCOME","duration_s":"'"$_T
low line 751

Access to hidden dotfiles in home directory

SourceSKILL.md
751echo '{"skill":"SKILL_NAME","duration_s":"'"$_TEL_DUR"'","outcome":"OUTCOME","browse":"USED_BROWSE","session":"'"$_SESSION_ID"'","ts":"'$(date -u +%Y-%m-%dT%H:%M:%SZ)'"}' >> ~/.gstack/analytics/skill-
low line 754

Access to hidden dotfiles in home directory

SourceSKILL.md
754if [ "$_TEL" != "off" ] && [ -x ~/.claude/skills/gstack/bin/gstack-telemetry-log ]; then
low line 755

Access to hidden dotfiles in home directory

SourceSKILL.md
755~/.claude/skills/gstack/bin/gstack-telemetry-log \
medium line 765

Access to hidden dotfiles in home directory

SourceSKILL.md
765In plan mode before ExitPlanMode: if the plan file lacks `## GSTACK REVIEW REPORT`, run `~/.claude/skills/gstack/bin/gstack-review-read` and append the standard runs/status/findings table. With `NO_RE
low line 867

Access to hidden dotfiles in home directory

SourceSKILL.md
867# Compute project slug for ~/.gstack/projects/ lookup
low line 1019

Access to hidden dotfiles in home directory

SourceSKILL.md
1019~/.claude/skills/gstack/bin/gstack-learnings-log '{
low line 1129

Access to hidden dotfiles in home directory

SourceSKILL.md
1129_CROSS_PROJ=$(~/.claude/skills/gstack/bin/gstack-config get cross_project_learnings 2>/dev/null || echo "unset")
low line 1132

Access to hidden dotfiles in home directory

SourceSKILL.md
1132~/.claude/skills/gstack/bin/gstack-learnings-search --limit 10 --cross-project 2>/dev/null || true
low line 1134

Access to hidden dotfiles in home directory

SourceSKILL.md
1134~/.claude/skills/gstack/bin/gstack-learnings-search --limit 10 2>/dev/null || true
medium line 1149

Access to hidden dotfiles in home directory

SourceSKILL.md
1149If A: run `~/.claude/skills/gstack/bin/gstack-config set cross_project_learnings true`
medium line 1150

Access to hidden dotfiles in home directory

SourceSKILL.md
1150If B: run `~/.claude/skills/gstack/bin/gstack-config set cross_project_learnings false`
low line 1212

Access to hidden dotfiles in home directory

SourceSKILL.md
1212source <(~/.claude/skills/gstack/bin/gstack-diff-scope <base> 2>/dev/null) || true
low line 1238

Access to hidden dotfiles in home directory

SourceSKILL.md
1238~/.claude/skills/gstack/bin/gstack-specialist-stats 2>/dev/null || true
medium line 1246

Access to hidden dotfiles in home directory

SourceSKILL.md
12461. **Testing** — read `~/.claude/skills/gstack/review/specialists/testing.md`
medium line 1247

Access to hidden dotfiles in home directory

SourceSKILL.md
12472. **Maintainability** — read `~/.claude/skills/gstack/review/specialists/maintainability.md`
medium line 1252

Access to hidden dotfiles in home directory

SourceSKILL.md
12523. **Security** — if SCOPE_AUTH=true, OR if SCOPE_BACKEND=true AND DIFF_LINES > 100. Read `~/.claude/skills/gstack/review/specialists/security.md`
medium line 1253

Access to hidden dotfiles in home directory

SourceSKILL.md
12534. **Performance** — if SCOPE_BACKEND=true OR SCOPE_FRONTEND=true. Read `~/.claude/skills/gstack/review/specialists/performance.md`
medium line 1254

Access to hidden dotfiles in home directory

SourceSKILL.md
12545. **Data Migration** — if SCOPE_MIGRATIONS=true. Read `~/.claude/skills/gstack/review/specialists/data-migration.md`
medium line 1255

Access to hidden dotfiles in home directory

SourceSKILL.md
12556. **API Contract** — if SCOPE_API=true. Read `~/.claude/skills/gstack/review/specialists/api-contract.md`
medium line 1256

Access to hidden dotfiles in home directory

SourceSKILL.md
12567. **Design** — if SCOPE_FRONTEND=true. Use the existing design review checklist at `~/.claude/skills/gstack/review/design-checklist.md`
low line 1288

Access to hidden dotfiles in home directory

SourceSKILL.md
1288~/.claude/skills/gstack/bin/gstack-learnings-search --type pitfall --query "{specialist domain}" --limit 5 2>/dev/null || true
medium line 1393

Access to hidden dotfiles in home directory

SourceSKILL.md
13931. The red-team checklist from `~/.claude/skills/gstack/review/specialists/red-team.md`
low line 1421

Access to hidden dotfiles in home directory

SourceSKILL.md
1421~/.claude/skills/gstack/bin/gstack-review-read
low line 1576

Access to hidden dotfiles in home directory

SourceSKILL.md
1576OLD_CFG=$(~/.claude/skills/gstack/bin/gstack-config get codex_reviews 2>/dev/null || true)
low line 1607

Access to hidden dotfiles in home directory

SourceSKILL.md
1607codex exec "IMPORTANT: Do NOT read or execute any files under ~/.claude/, ~/.agents/, .claude/skills/, or agents/. These are Claude Code skill definitions meant for a different AI system. They contain
low line 1636

Access to hidden dotfiles in home directory

SourceSKILL.md
1636codex review "IMPORTANT: Do NOT read or execute any files under ~/.claude/, ~/.agents/, .claude/skills/, or agents/. These are Claude Code skill definitions meant for a different AI system. They conta
low line 1664

Access to hidden dotfiles in home directory

SourceSKILL.md
1664~/.claude/skills/gstack/bin/gstack-review-log '{"skill":"adversarial-review","timestamp":"'"$(date -u +%Y-%m-%dT%H:%M:%SZ)"'","status":"STATUS","source":"SOURCE","tier":"always","gate":"GATE","commit"
low line 1697

Access to hidden dotfiles in home directory

SourceSKILL.md
1697~/.claude/skills/gstack/bin/gstack-review-log '{"skill":"review","timestamp":"TIMESTAMP","status":"STATUS","issues_found":N,"critical":N,"informational":N,"quality_score":SCORE,"specialists":SPECIALIS
low line 1717

Access to hidden dotfiles in home directory

SourceSKILL.md
1717~/.claude/skills/gstack/bin/gstack-learnings-log '{"skill":"review","type":"TYPE","key":"SHORT_KEY","insight":"DESCRIPTION","confidence":N,"source":"SOURCE","files":["path/to/relevant/file"]}'
low line 331

Unicode escape sequences

SourceSKILL.md
331writes `\u3103` thinking it is 管 U+7BA1, but `\u3103` is
low line 150

External URL reference

SourceSKILL.md
150If `LAKE_INTRO` is `no`: say "gstack follows the **Boil the Lake** principle — do the complete thing when AI makes marginal cost near-zero. Read more: https://garryslist.org/posts/boil-the-ocean" Offe
low line 153

External URL reference

SourceSKILL.md
153open https://garryslist.org/posts/boil-the-ocean
Scanned on May 12, 2026
View Security Dashboard
Installation guide →
GitHub Stars 92.6K
Rate this skill
Categorydevelopment
UpdatedMay 13, 2026
claudeclaude-codecodexclinefrontenddesignplaywrightsupabasedocxgitapidatabasetestingdevopsbackenddevops-sreqa-engineerbackend-developerdevelopment
garrytan/gstack