skills.rest
hiiamsky
hiiamskyCOMMUNITY
Explore all skills by this author →
GitHub

sql-code-review

Analyze SQL code for security, maintainability, and quality issues.

Updated Apr 4, 2026
Search Tags:#performance#security#sql#code-quality#code-review#database-best-practices
One-click install
npx skills add https://github.com/hiiamsky/multi-agent-dev-team --skill sql-code-review-hiiamsky
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: sql-code-review
Source: https://github.com/hiiamsky/multi-agent-dev-team/tree/main/.github/skills/sql-code-review
Command: npx skills add https://github.com/hiiamsky/multi-agent-dev-team --skill sql-code-review-hiiamsky

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Universally analyze SQL code to identify security, maintainability, and quality issues across all databases.

Core Features & Use Cases

  • Security-first reviews: Detect SQL injection risks and permission misconfigurations.
  • Maintainability & standards: Enforce naming conventions, formatting, and anti-patterns across MySQL, PostgreSQL, SQL Server, and Oracle.
  • Use Case: Integrate into PR checks or CI pipelines to provide actionable remediation guidance and fix suggestions.

Quick Start

Analyze the given SQL script and return a prioritized list of issues with recommended fixes.

Frequently Asked Questions about sql-code-review

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

FAQPage Schema
How do I detect SQL injection risks and security issues in my database scripts?▼

SQL code review detects injection risks by enforcing parameterization and access controls across your database scripts. It analyzes queries to identify permission misconfigurations and provides concrete remediation guidance to patch vulnerabilities.

Can I automate SQL code quality checks for PostgreSQL and MySQL in a CI pipeline?▼

You can integrate SQL code analysis into CI pipelines to automate quality checks for PostgreSQL and MySQL. It enforces naming conventions and anti-pattern detection, returning prioritized issues with recommended fixes during PR checks.

What is the best way to enforce naming conventions and formatting standards across SQL Server and Oracle?▼

Enforcing SQL formatting standards involves analyzing scripts against style guidelines to flag anti-patterns and naming convention violations across SQL Server and Oracle. This maintains code quality and ensures database maintainability.

How do I review SQL migrations to prevent anti-patterns and maintainability issues?▼

SQL migration audits identify maintainability issues and anti-patterns by analyzing the migration code. This detects security flaws, style violations, and quality degradation, providing actionable fix suggestions for database updates.

Does automated SQL analysis work across different database dialects like MySQL, PostgreSQL, and SQL Server?▼

Automated SQL analysis universally supports MySQL, PostgreSQL, SQL Server, and Oracle. It identifies security, maintainability, and quality issues across these dialects, applying parameterization and access control checks to all databases.

Related Skills

Explore More Software Engineering Skills→
nashirabbashnashirabbash

sql-code-review

Review SQL code across MySQL, PostgreSQL, SQL Server, and Oracle for security and performance issues.

Community
Advanced
sergicalsergical

sentry-pr-code-review

Parse Sentry bot comments in GitHub PRs to extract issues and suggested fixes.

Community
Advanced
apollographqlapollographql
301

review

Automate Rust pull request reviews for security, performance, and test gaps.

Official
Advanced
ollieb89ollieb89

sast-configuration

Configures SAST tools like Semgrep, SonarQube and CodeQL for automated vulnerability detection in CI/CD pipelines.

Community
Advanced