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

Ready to run

npx skills add https://github.com/leonanpereirapinto/ai-utils --skill sql-code-review-leonanpereirapinto

💬 Prompt for ChatGPT / Claude Chat▼

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.