skills.rest
nashirabbash
nashirabbashCOMMUNITY
Explore all skills by this author →
GitHub

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
One-click install
npx skills add https://github.com/nashirabbash/autorepychatbot --skill sql-code-review-nashirabbash
Or copy as Structured Prompt for Agent▼
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.

Related Skills

Explore More Software Engineering Skills→
scruffydanscruffydan

sql-security

Enforce parameterized queries and least-privilege credentials to prevent SQL injection.

Community
Basic
UnicornUnicorn

query-optimization-agent

Analyze SQL queries and produce rewritten SQL, index recommendations, and execution plan comparisons.

Official
Intermediate
AnveioAnveio
1

task-pull-request

Automate GitHub pull request creation, reviews, feedback, and merges via gh CLI.

Community
Intermediate
lluppesmslluppesms

sql-optimization

Analyze SQL execution plans and recommend index optimizations.

Community
Advanced