skills.rest
PoyoPoak
PoyoPoakCOMMUNITY
Explore all skills by this author →
GitHub

sql-code-review

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

Updated Aug 27, 2026
Search Tags:#performance#anti-patterns#security#maintainability#sql#code-review#database-best-practices
One-click install
npx skills add https://github.com/PoyoPoak/FastAPI-App-Template --skill sql-code-review-poyopoak
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: sql-code-review
Source: https://github.com/PoyoPoak/FastAPI-App-Template/tree/main/.agents/skills/sql-code-review
Command: npx skills add https://github.com/PoyoPoak/FastAPI-App-Template --skill sql-code-review-poyopoak

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

SQL code contains security risks, maintainability challenges, and anti-patterns across multiple databases. This Skill provides a structured, end-to-end review covering security, performance, and code quality with actionable guidance.

Core Features & Use Cases

  • Security-focused analysis: detects SQL injection vulnerabilities, access control gaps, and data exposure risks.
  • Performance & maintainability: highlights inefficient patterns, poor indexing, and maintainability issues across DB engines.
  • Use Case: when reviewing a new data access module, the Skill outputs a prioritized remediation plan and a checklist to validate against coding standards.

Quick Start

Provide the SQL code or project you want reviewed and I will deliver a comprehensive security, performance, and maintainability assessment.

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?▼

SQL code review identifies security vulnerabilities by enforcing parameterization and access controls across your database code. It detects SQL injection risks, data exposure gaps, and anti-patterns, delivering structured issue templates with actionable remediation guidance.

Can I run a SQL code review on both PostgreSQL and Oracle projects?▼

Yes, SQL code review supports PostgreSQL and Oracle projects, alongside MySQL and SQL Server. It analyzes queries, procedures, and scripts across both codebases and live databases to identify performance bottlenecks, poor indexing, and maintainability issues.

What is the best way to check database queries for performance issues and maintainability?▼

The best way to check database queries for performance issues and maintainability is a structured review that highlights inefficient patterns and poor indexing. It evaluates SQL scripts against database best practices to output a prioritized remediation plan and validation checklist.

How do I get a remediation plan for SQL injection risks in my database scripts?▼

To get a remediation plan for SQL injection risks, submit your database scripts for security-focused analysis. The review enforces parameterization, detects access control gaps, and outputs a prioritized remediation plan with a checklist to validate against coding standards.

Does SQL code review work on stored procedures and live databases?▼

Yes, SQL code review works on stored procedures and live databases. It analyzes procedures, queries, and scripts across MySQL, PostgreSQL, SQL Server, and Oracle to identify anti-patterns, enforce naming conventions, and assess data exposure risks.

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
zhukunpenglinyutongzhukunpenglinyutong
330

security-review

Audit code for OWASP Top 10 vulnerabilities and provide secure development checklists.

Community
Advanced
veerababumanyamveerababumanyam

project-structure

Enforce standardized project structure and coding conventions across the RawDrive monorepo.

Community
Basic
Mentor-WizardMentor-Wizard
10

postgresql-optimization

Analyze PostgreSQL queries with EXPLAIN ANALYZE and tune indexes and configuration.

Official
Advanced