sql-code-review

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

Updated Mar 30, 2026

Search Tags:#performance #anti-patterns #security #database #maintainability #sql #code-review

Ready to run

npx skills add https://github.com/nashirabbash/autorepychatbot --skill sql-code-review-nashirabbash

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: sql-code-review
Source: https://github.com/nashirabbash/autorepychatbot/tree/main/.agents/skills/sql-code-review
Command: npx skills add https://github.com/nashirabbash/autorepychatbot --skill sql-code-review-nashirabbash

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This skill identifies security flaws, performance bottlenecks, and maintainability issues across SQL codebases in MySQL, PostgreSQL, SQL Server, and Oracle, delivering structured, actionable guidance.

Core Features & Use Cases

Security & Compliance: detects SQL injection risks, improper access controls, and sensitive data exposure.
Performance & Maintainability: analyzes query patterns for efficient joins, indexing, readability, and coding standards.
Use Case: Review a complex application SQL module and produce a prioritized fix list.

Quick Start

Review the provided SQL code and return a prioritized list of issues with actionable 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 perform an automated SQL code review for security and performance issues?▼

To perform an automated SQL code review, submit your raw SQL, stored procedures, or ORM-generated queries to receive a prioritized list of security, performance, and maintainability issues with structured fix templates.

Can I review ORM-generated queries and stored procedures across different database engines?▼

Yes, you can review ORM-generated queries and stored procedures across MySQL, PostgreSQL, SQL Server, and Oracle. The review process identifies security flaws and performance bottlenecks regardless of the specific SQL dialect.

What is the best way to detect SQL injection risks and improper access controls in my database code?▼

The best way to detect SQL injection risks and improper access controls is running a targeted SQL code review that analyzes your codebase patterns and returns a structured report highlighting sensitive data exposure vulnerabilities.

How do I analyze query patterns for efficient joins and indexing in PostgreSQL and MySQL?▼

You can analyze query patterns by submitting your PostgreSQL and MySQL code for review. The process evaluates join efficiency and readability, applying a clear scoring rubric to produce actionable maintainability improvements.

Does the SQL code review process provide a scoring rubric for maintainability standards?▼

Yes, the SQL code review process implements a reproducible workflow with a clear scoring rubric. It evaluates coding standards and returns structured issue formats with templates for fixes to improve maintainability.