skills.rest
leonanpereirapinto
leonanpereirapintoCOMMUNITY
Explore all skills by this author →
𝕏@leonanpereirapGitHub

sql-code-review

Identify security, performance, and maintainability issues in SQL code.

1|Updated Mar 27, 2026
Search Tags:#performance#anti-patterns#security#maintainability#sql#code-review#databases
One-click install
npx skills add https://github.com/leonanpereirapinto/ai-utils --skill sql-code-review-leonanpereirapinto
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: sql-code-review
Source: https://github.com/leonanpereirapinto/ai-utils/tree/main/skills/sql/sql-code-review
Command: npx skills add https://github.com/leonanpereirapinto/ai-utils --skill sql-code-review-leonanpereirapinto

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Analyze SQL code to identify security vulnerabilities, performance bottlenecks, and maintainability gaps, and provide actionable remediation guidance.

Core Features & Use Cases

  • Security & Compliance: Detect SQL injection vectors, improper access controls, and risky data handling.
  • Performance & Quality: Flag inefficient patterns, missing indexes, and anti-patterns across multiple DB engines.
  • Use Case: Teams reviewing stored procedures and query sets across MySQL, PostgreSQL, SQL Server, and Oracle to improve security, performance, and readability.

Quick Start

Run a comprehensive SQL code review on the target project or file to generate a prioritized list of issues with suggested 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 review SQL code for security vulnerabilities and anti-patterns?▼

You can review stored procedures and query sets by running a comprehensive SQL code review that detects injection vectors, improper access controls, risky data handling, inefficient patterns, and missing indexes, returning a prioritized list of issues with suggested fixes.

What is the best way to check SQL queries for performance bottlenecks across multiple database engines?▼

A cross-engine SQL code review can analyze both small scripts and large codebases across MySQL, PostgreSQL, SQL Server, and Oracle, detecting injection vectors, poor indexing patterns, and anti-patterns to return a structured review with a compliance checklist.

Does SQL code review work with PostgreSQL and Oracle stored procedures?▼

SQL code review is suitable for teams reviewing stored procedures and query sets across MySQL, PostgreSQL, SQL Server, and Oracle to improve security, performance, and readability for both small scripts and large codebases.

How do I enforce parameterization and access controls in my database schema design?▼

To enforce parameterization and access controls in database schema design, run a SQL code review that returns a structured review enforcing best practices, proper schema design, naming conventions, and a compliance checklist with actionable before/after examples.

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
iCesofTiCesofT
1

sql-code-review

Identify and remediate security, performance, and maintainability issues in SQL code.

Community
Advanced
RightNow-AIRightNow-AI
18.1k

postgres-expert

Analyze PostgreSQL query plans and recommend indexing strategies.

Official
Advanced
pczhao1210pczhao1210

sql-code-review

Identify security vulnerabilities, performance bottlenecks, and maintainability issues in SQL code.

Community
Advanced