review

Analyze feature branch diffs against main for SQL safety and trust boundary issues.

Updated Jan 18, 2026
One-click install
npx skills add https://github.com/psyche911/investor-council-app --skill review-psyche911
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: review
Source: https://github.com/psyche911/investor-council-app/tree/main/.claude/skills/gstack/review
Command: npx skills add https://github.com/psyche911/investor-council-app --skill review-psyche911

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Automates pre-landing PR reviews to detect SQL safety issues, LLM prompt boundary violations, and conditional side effects.

Core Features & Use Cases

  • Two-pass diff analysis against main with a structured checklist-driven evaluation.
  • Generates actionable findings and remediation guidance for reviewers.
  • Supports interactive prompts to clarify edge cases via AskUserQuestion.

Quick Start

Run the /review workflow on a PR to analyze the branch against main and generate a findings report.

Frequently Asked Questions about review

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I automate pre-landing code review for SQL safety issues in a pull request?

Pre-landing code review is automated by analyzing the diff between your feature branch and main to detect SQL safety issues. The process applies a structured checklist to evaluate diffs and outputs findings with specific remediation guidance for reviewers.

What is a two-pass diff analysis and how does it work for PR review?

A two-pass diff analysis evaluates pull request changes against main in two structured stages using a checklist. This method identifies SQL safety issues, LLM trust boundary violations, and conditional side effects, guiding reviewers through generating actionable findings.

How do I check a pull request for LLM prompt boundary violations before merging?

To check a pull request for LLM prompt boundary violations before merging, run a diff analysis against the main branch. The review workflow identifies trust boundary violations and conditional side effects, providing remediation guidance for each finding.

Can I use a checklist-driven workflow to review code diffs for conditional side effects?

Yes, you can use a checklist-driven workflow to review code diffs for conditional side effects. The workflow requires a repository diff against main and a specific checklist file, utilizing interactive prompts to clarify edge cases during the evaluation process.

What do I need to run an automated diff analysis workflow on my feature branch?

To run an automated diff analysis workflow, you need access to the repository diff against main and a checklist file located at a specific path within your project structure. The workflow outputs a findings report with remediation guidance based on this input.

Why does my pre-landing review workflow need a checklist file in the repository?

Your pre-landing review workflow needs a checklist file to provide the structured evaluation criteria required for the two-pass diff analysis. Without this checklist file located at the specified path, the workflow cannot systematically detect SQL safety issues, LLM trust boundary violations, and conditional side effects.