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 Jun 10, 2026 and we found 105 security issues across 3 threat categories. Review the findings below before installing.

Categories Tested

Security Issues

medium line 35

Template literal with variable interpolation in command context

SourceSKILL.md
35```bash
medium line 285

Template literal with variable interpolation in command context

SourceSKILL.md
285```bash
medium line 420

Template literal with variable interpolation in command context

SourceSKILL.md
420```bash
medium line 454

Template literal with variable interpolation in command context

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

Template literal with variable interpolation in command context

SourceSKILL.md
582```bash
medium line 855

Template literal with variable interpolation in command context

SourceSKILL.md
855```bash
medium line 1247

Template literal with variable interpolation in command context

SourceSKILL.md
1247```bash
medium line 1607

Template literal with variable interpolation in command context

SourceSKILL.md
1607```bash
low line 36

Access to hidden dotfiles in home directory

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

Access to hidden dotfiles in home directory

SourceSKILL.md
38mkdir -p ~/.gstack/sessions
low line 39

Access to hidden dotfiles in home directory

SourceSKILL.md
39touch ~/.gstack/sessions/"$PPID"
low line 40

Access to hidden dotfiles in home directory

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

Access to hidden dotfiles in home directory

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

Access to hidden dotfiles in home directory

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

Access to hidden dotfiles in home directory

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

Access to hidden dotfiles in home directory

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

Access to hidden dotfiles in home directory

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

Access to hidden dotfiles in home directory

SourceSKILL.md
53_SESSION_KIND=$(~/.claude/skills/gstack/bin/gstack-session-kind 2>/dev/null || echo "interactive")
low line 56

Access to hidden dotfiles in home directory

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

Access to hidden dotfiles in home directory

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

Access to hidden dotfiles in home directory

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

Access to hidden dotfiles in home directory

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

Access to hidden dotfiles in home directory

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

Access to hidden dotfiles in home directory

SourceSKILL.md
69mkdir -p ~/.gstack/analytics
low line 71

Access to hidden dotfiles in home directory

SourceSKILL.md
71echo '{"skill":"review","ts":"'$(date -u +%Y-%m-%dT%H:%M:%SZ)'","repo":"'$(_repo=$(basename "$(git rev-parse --show-toplevel 2>/dev/null)" 2>/dev/null | tr -cd 'a-zA-Z0-9._-'); echo "${_repo:-unknown}
low line 73

Access to hidden dotfiles in home directory

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

Access to hidden dotfiles in home directory

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

Access to hidden dotfiles in home directory

SourceSKILL.md
76~/.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 82

Access to hidden dotfiles in home directory

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

Access to hidden dotfiles in home directory

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

Access to hidden dotfiles in home directory

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

Access to hidden dotfiles in home directory

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

Access to hidden dotfiles in home directory

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

Access to hidden dotfiles in home directory

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

Access to hidden dotfiles in home directory

SourceSKILL.md
131In 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 139

Access to hidden dotfiles in home directory

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

Access to hidden dotfiles in home directory

SourceSKILL.md
141If 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 146

Access to hidden dotfiles in home directory

SourceSKILL.md
146- 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 147

Access to hidden dotfiles in home directory

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

Access to hidden dotfiles in home directory

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

Access to hidden dotfiles in home directory

SourceSKILL.md
164rm -f ~/.gstack/.writing-style-prompt-pending
low line 165

Access to hidden dotfiles in home directory

SourceSKILL.md
165touch ~/.gstack/.writing-style-prompted
low line 174

Access to hidden dotfiles in home directory

SourceSKILL.md
174touch ~/.gstack/.completeness-intro-seen
medium line 187

Access to hidden dotfiles in home directory

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

Access to hidden dotfiles in home directory

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

Access to hidden dotfiles in home directory

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

Access to hidden dotfiles in home directory

SourceSKILL.md
202touch ~/.gstack/.telemetry-prompted
medium line 215

Access to hidden dotfiles in home directory

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

Access to hidden dotfiles in home directory

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

Access to hidden dotfiles in home directory

SourceSKILL.md
220touch ~/.gstack/.proactive-prompted
medium line 262

Access to hidden dotfiles in home directory

SourceSKILL.md
262If 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 266

Access to hidden dotfiles in home directory

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

Access to hidden dotfiles in home directory

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

Access to hidden dotfiles in home directory

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

Access to hidden dotfiles in home directory

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

Access to hidden dotfiles in home directory

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

Access to hidden dotfiles in home directory

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

Access to hidden dotfiles in home directory

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

Access to hidden dotfiles in home directory

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

Access to hidden dotfiles in home directory

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

Access to hidden dotfiles in home directory

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

Access to hidden dotfiles in home directory

SourceSKILL.md
583eval "$(~/.claude/skills/gstack/bin/gstack-slug 2>/dev/null)"
low line 600

Access to hidden dotfiles in home directory

SourceSKILL.md
600~/.claude/skills/gstack/bin/gstack-decision-search --recent 5 2>/dev/null
medium line 609

Access to hidden dotfiles in home directory

SourceSKILL.md
609**Cross-session decisions.** If `ACTIVE DECISIONS` are listed, treat them as prior settled calls with their rationale — do not silently re-litigate them; if you're about to reverse one, say so explici
medium line 622

Access to hidden dotfiles in home directory

SourceSKILL.md
622Curated jargon list lives at `~/.claude/skills/gstack/scripts/jargon-list.json` (80+ terms). On the first jargon term you encounter this session, Read that file once; treat the `terms` array as the ca
medium line 668

Access to hidden dotfiles in home directory

SourceSKILL.md
668Before 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 676

Access to hidden dotfiles in home directory

SourceSKILL.md
676~/.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 685

Access to hidden dotfiles in home directory

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

Access to hidden dotfiles in home directory

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

Access to hidden dotfiles in home directory

SourceSKILL.md
705jq -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 723

Access to hidden dotfiles in home directory

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

Access to hidden dotfiles in home directory

SourceSKILL.md
733`~/.gstack/analytics/`, matching preamble analytics writes.
low line 740

Access to hidden dotfiles in home directory

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

Access to hidden dotfiles in home directory

SourceSKILL.md
742~/.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 745

Access to hidden dotfiles in home directory

SourceSKILL.md
745echo '{"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 748

Access to hidden dotfiles in home directory

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

Access to hidden dotfiles in home directory

SourceSKILL.md
749~/.claude/skills/gstack/bin/gstack-telemetry-log \
low line 859

Access to hidden dotfiles in home directory

SourceSKILL.md
859# Compute project slug for ~/.gstack/projects/ lookup
low line 1011

Access to hidden dotfiles in home directory

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

Access to hidden dotfiles in home directory

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

Access to hidden dotfiles in home directory

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

Access to hidden dotfiles in home directory

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

Access to hidden dotfiles in home directory

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

Access to hidden dotfiles in home directory

SourceSKILL.md
1149If B: run `~/.claude/skills/gstack/bin/gstack-config set cross_project_learnings false`
medium line 1225

Access to hidden dotfiles in home directory

SourceSKILL.md
1225`~/.gstack-dev/plans/1539-framework-aware-review.md` design doc.
low line 1248

Access to hidden dotfiles in home directory

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

Access to hidden dotfiles in home directory

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

Access to hidden dotfiles in home directory

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

Access to hidden dotfiles in home directory

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

Access to hidden dotfiles in home directory

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

Access to hidden dotfiles in home directory

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

Access to hidden dotfiles in home directory

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

Access to hidden dotfiles in home directory

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

Access to hidden dotfiles in home directory

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

Access to hidden dotfiles in home directory

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

Access to hidden dotfiles in home directory

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

Access to hidden dotfiles in home directory

SourceSKILL.md
1458~/.claude/skills/gstack/bin/gstack-review-read
low line 1614

Access to hidden dotfiles in home directory

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

Access to hidden dotfiles in home directory

SourceSKILL.md
1649codex 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 1678

Access to hidden dotfiles in home directory

SourceSKILL.md
1678codex 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 1706

Access to hidden dotfiles in home directory

SourceSKILL.md
1706~/.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 1739

Access to hidden dotfiles in home directory

SourceSKILL.md
1739~/.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 1759

Access to hidden dotfiles in home directory

SourceSKILL.md
1759~/.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 170

External URL reference

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

External URL reference

SourceSKILL.md
173open https://garryslist.org/posts/boil-the-ocean
Scanned on Jun 10, 2026
View Security Dashboard
Installation guide →
GitHub Stars 104.9K
Rate this skill
Categorydevelopment
UpdatedJune 10, 2026
claudeclaude-codecodexclinefrontenddesignplaywrightsupabasedocxgitapidatabasetestingdevopsbackenddevops-sreqa-engineerbackend-developerdevelopment
garrytan/gstack