code-reviewer

Review Kotlin and SQL pull requests for bugs, security, and test quality.

Updated Mar 5, 2026
One-click install
npx skills add https://github.com/Astrumon/Spovishun --skill code-reviewer-astrumon
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: code-reviewer
Source: https://github.com/Astrumon/Spovishun/tree/main/.claude/skills/code-reviewer
Command: npx skills add https://github.com/Astrumon/Spovishun --skill code-reviewer-astrumon

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill helps maintainers and reviewers quickly assess pull requests and code changes by producing structured, prioritized, and actionable feedback that improves code quality without being condescending.

Core Features & Use Cases

  • Structured Review Workflow: Walks through context, architecture, detailed code issues, tests, and final feedback in a five-step process.
  • Kotlin and SQL Focus: Applies Kotlin-specific checks (coroutine safety, domain layer purity) and SQL/migration considerations for projects using Exposed/Flyway.
  • Security and Testing: Validates against OWASP Top 10, flags hardcoded secrets, and evaluates test quality and coverage.
  • Deliverable: Generates a categorized report with critical/major/minor findings, code fixes, positive notes, and clear merge verdicts.

Quick Start

Paste the PR title, description, and diff and ask for a prioritized, actionable code review following the provided output format.

Frequently Asked Questions about code-reviewer

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

FAQPage Schema
How do I get structured pull request feedback for Kotlin code?

Structured pull request feedback for Kotlin code is generated by submitting the PR title, description, and diff to receive a categorized report covering coroutine safety, domain layer purity, and actionable fixes for maintainers.

How does automated code review handle OWASP security checks and hardcoded secrets?

Automated code review handles OWASP security checks by validating code diffs against the OWASP Top 10, flagging hardcoded secrets, and detailing security vulnerabilities with reproducible steps and suggested fixes in the final report.

Can I use automated PR review for SQL migrations and Flyway updates?

You can use automated PR review for SQL migrations and Flyway updates because the process applies specific SQL and migration considerations to evaluate database changes alongside standard code and test quality checks.

What is the best way to evaluate test coverage and quality in a code diff?

The best way to evaluate test coverage and quality in a code diff is through a five-step review workflow that analyzes test changes, assesses coverage gaps, and outputs prioritized findings suitable for CI gating.

Does code review automation work for CI gating with critical and major findings?

Code review automation works for CI gating by producing a final categorized report with critical, major, and minor findings, alongside a clear merge verdict that maintainers can use to block or approve pull requests.