sql-code-review

Review SQL code for security, maintainability, and quality across MySQL, PostgreSQL, SQL Server, and Oracle.

Updated Dec 28, 2025
One-click install
npx skills add https://github.com/74nu5/Narratum --skill sql-code-review-74nu5
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: sql-code-review
Source: https://github.com/74nu5/Narratum/tree/main/.github/skills/sql-code-review
Command: npx skills add https://github.com/74nu5/Narratum --skill sql-code-review-74nu5

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This Skill addresses the critical need for robust SQL code quality, security, and maintainability across diverse database systems, preventing vulnerabilities and performance bottlenecks.

Core Features & Use Cases

  • Comprehensive Analysis: Evaluates SQL code for security flaws (SQL injection, access control), performance issues (indexing, query structure), and maintainability (style, naming).
  • Database Agnostic: Provides guidance applicable to MySQL, PostgreSQL, SQL Server, and Oracle, with specific examples.
  • Use Case: A developer can submit a complex SQL query or stored procedure to this Skill to receive a detailed report on potential security risks, performance optimizations, and adherence to best practices before deployment.

Quick Start

Run a security and performance review on the provided SQL script.

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 a SQL code review for security and performance issues?

To perform a SQL code review, you submit your SQL query or stored procedure to analyze security flaws like SQL injection, access control vulnerabilities, performance bottlenecks, and anti-patterns across MySQL, PostgreSQL, SQL Server, and Oracle databases.

What are common SQL injection vulnerabilities found during database code analysis?

SQL injection vulnerabilities found during database code analysis include improper input validation and dynamic query construction, which this analysis detects alongside access control flaws to prevent unauthorized data access across multiple database systems.

Can I analyze SQL code maintainability across different database platforms like PostgreSQL and Oracle?

Yes, you can analyze SQL code maintainability across PostgreSQL, Oracle, MySQL, and SQL Server, receiving database-agnostic guidance on code standards, naming conventions, and structural anti-patterns to improve overall query quality.

What is the best way to check stored procedures for SQL anti-patterns before deployment?

The best way to check stored procedures for SQL anti-patterns is running a comprehensive code review that evaluates query structure, indexing strategies, and adherence to best practices, providing a detailed risk and optimization report before deployment.

Does SQL security analysis work for both MySQL and SQL Server query optimization?

SQL security analysis works universally for both MySQL and SQL Server query optimization, evaluating access control and query structure to identify performance bottlenecks and provide specific, database-targeted optimization recommendations.

Why does my SQL query have performance bottlenecks and how can I identify them?

Your SQL query has performance bottlenecks potentially due to poor indexing or structural anti-patterns, which a comprehensive code review identifies by evaluating query structure and suggesting optimizations to resolve the issues.