🎯

sql-code-review

🎯Skill

from github/awesome-copilot

What it does

Reviews SQL code across all database platforms for security vulnerabilities, maintainability issues, and quality standards.

Overview

This skill performs comprehensive SQL code reviews across all major database platforms (MySQL, PostgreSQL, SQL Server, Oracle). It focuses on security vulnerability detection including SQL injection prevention, access control review, code quality standards, anti-pattern detection, and maintainability analysis to ensure production-grade SQL code.

Key Features

SQL Injection Prevention - Identifies dynamic SQL concatenation vulnerabilities and enforces parameterized queries with platform-specific prepared statement patterns
Access Control & Permissions Review - Evaluates principle of least privilege, role-based access, schema security, and DEFINER vs INVOKER rights for stored procedures
Query Structure Analysis - Detects inefficient patterns like implicit joins, SELECT *, missing WHERE clauses, and recommends optimized alternatives with proper join syntax
Anti-Pattern Detection - Catches common SQL anti-patterns including God queries, implicit type conversions, unnecessary DISTINCT usage, and function calls on indexed columns
Data Protection Audit - Reviews sensitive data exposure, audit logging practices, data masking implementations, and encryption requirements

Who is this for?

Database developers, backend engineers, and security-focused teams who need thorough SQL code reviews before deploying to production. Ideal as a complement to SQL optimization workflows, providing the security and maintainability analysis that completes a full development coverage audit.

📦

Same repository

github/awesome-copilot(314 items)

sql-code-review

Installation

Vibe Index InstallInstalls to .claude/skills/ - auto-recognized by Claude Code

npx vibeindex add github/awesome-copilot --skill sql-code-review

skills.sh Install⚠ Installs to .agents/skills/ - may not be auto-recognized by Claude Code

npx skills add github/awesome-copilot --skill sql-code-review

Manual InstallCopy SKILL.md content and save to the path below

~/.claude/skills/sql-code-review/SKILL.md

SKILL.md

9,608Installs

AddedFeb 25, 2026

View on GitHub Back to Skills

More from this repository10

🎯

git-commit🎯Skill

A community-curated collection of custom agents, prompts, instructions, and skills to enhance GitHub Copilot across different domains, languages, and use cases.

🎯

gh-cli🎯Skill

A community-curated collection of custom agents, prompts, instructions, and skills to enhance GitHub Copilot across different domains, languages, and use cases.

🎯

prd🎯Skill

Generates comprehensive Product Requirements Documents (PRDs) by systematically analyzing requirements and crafting detailed technical specifications

🎯

documentation-writer🎯Skill

Expert technical writer guided by the Diataxis framework, creating tutorials, how-to guides, reference docs, and explanation pages for software documentation.

🎯

excalidraw-diagram-generator🎯Skill

Generates Excalidraw diagrams from natural language descriptions, creating visual representations of processes, systems, relationships, and ideas.

🎯

refactor🎯Skill

A community-curated collection of custom agents, prompts, instructions, and skills to enhance GitHub Copilot across different domains, languages, and use cases.

🎯

java-springboot🎯Skill

Provides Spring Boot best practices covering project setup, dependency injection, REST API design, data access with JPA, security configuration, and testing strategies.

🎯

multi-stage-dockerfile🎯Skill

Creates optimized multi-stage Dockerfiles for any language or framework, separating builder and runtime stages to produce smaller, more secure container images.

🎯

create-readme🎯Skill

Creates README.md files for projects.

🎯

memory-merger🎯Skill

Merges mature lessons from domain memory files into instruction files, consolidating knowledge with minimal redundancy across global, user, and workspace scopes.