skills.rest
fengjutian
fengjutianCOMMUNITY
Explore all skills by this author →
GitHub

code-reviewer

Automate code review for Python, Vue, and SQL code.

Updated Apr 28, 2026
Search Tags:#static analysis#code review#performance optimization#Python#Vue#security auditing
One-click install
npx skills add https://github.com/fengjutian/skills --skill code-reviewer-fengjutian
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: code-reviewer
Source: https://github.com/fengjutian/skills/tree/main/code-reviewer
Command: npx skills add https://github.com/fengjutian/skills --skill code-reviewer-fengjutian

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires pycodestyle, flake8, mypy, sqlparse, vuedoctest, and includes scripts (resource) and references (resource) components.

What problem does it solve?

This Skill automates the code review process for Python, Vue, and SQL code, helping developers improve the quality of their software by identifying and suggesting fixes for common issues.

Core Features & Use Cases

  • Static Analysis: Identifies potential issues in code such as empty values, boundary conditions, and missing exception handling.
  • Performance Analysis: Detects performance bottlenecks like N+1 queries and unnecessary database accesses.
  • Security Analysis: Finds security vulnerabilities such as SQL injection, unauthorized access, and information leaks.
  • Architecture Analysis: Evaluates code structure and architecture for best practices and common pitfalls.
  • Use Case: When you have a codebase with Python and Vue components and want to ensure high code quality, the code-reviewer Skill can scan the codebase for potential issues.

Quick Start

Perform a code review on the 'main.py' file using the code-reviewer skill.

Frequently Asked Questions about code-reviewer

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

FAQPage Schema
How do I automate Python and Vue code review for security vulnerabilities and performance bottlenecks?▼

Automate Python and Vue code review by scanning your codebase to identify security vulnerabilities like SQL injection and performance bottlenecks such as N+1 queries. This process evaluates static analysis, architecture, and security auditing to suggest fixes for common software issues.

What is static analysis for Python and Vue codebases and how does it find bugs?▼

Static analysis for Python and Vue codebases identifies potential bugs by parsing code without executing it. It detects empty values, boundary conditions, and missing exception handling, evaluating code structure and architecture to pinpoint common pitfalls and improve overall software quality.

Can I use flake8 and mypy for automated security auditing and architectural assessment?▼

Yes, automated security auditing and architectural assessment utilize libraries like flake8 and mypy for Python code parsing. These dependencies enable the identification of security vulnerabilities, unauthorized access, and architectural deviations within your Python, Vue, and SQL code.

What's the best way to detect SQL injection and N+1 query issues in my Python backend?▼

The best way to detect SQL injection and N+1 query issues is using automated code review focused on performance and security analysis. It scans Python and SQL code to find vulnerabilities like injection attacks and performance bottlenecks such as unnecessary database accesses.

Do I need specific Python and Vue libraries installed to perform automated static analysis?▼

Yes, you need specific Python and Vue libraries installed to perform automated static analysis. The code review process requires dependencies like pycodestyle, mypy, sqlparse, and vuedoctest to properly parse and analyze your codebase for quality and security issues.

Related Skills

Explore More Software Engineering Skills→
yun-s-ohyun-s-oh

openspec-validate-code

Validates Python codebase quality and Home Assistant schema compliance using flake8, mypy, py_compile, and hass-config-check commands.

Community
Intermediate
OneWave-AIOneWave-AI
245

code-review-pro

Review code for security vulnerabilities, performance bottlenecks, and maintainability issues.

Official
Basic
SensLiaoSensLiao

qa-static-baseline

Automate static code analysis and security scanning on pull requests or CI pipelines.

Community
Intermediate
matteocervellimatteocervelli
25

security-scanner

Scan codebases for secrets, vulnerable dependencies, and insecure patterns.

Community
Advanced