sql-code-review

Comprehensive SQL security, performance, and quality analysis across MySQL, PostgreSQL, SQL Server, and Oracle databases.

github ↓ 12k
Claude Code
View source ↗

What it does

  • Principle of Least Privilege: Grant minimum required permissions
  • Role-Based Access: Use database roles instead of direct user permissions
  • Schema Security: Proper schema ownership and access controls
  • Function/Procedure Security: Review DEFINER vs INVOKER rights
  • Sensitive Data Exposure: Avoid SELECT on tables with sensitive columns
  • Audit Logging: Ensure sensitive operations are logged
  • Data Masking: Use views or functions to mask sensitive data

Requirements & configuration

  • Missing Indexes: Identify columns that need indexing

Derived from the skill's own SKILL.md documentation · extracted 2026-07-23

Comprehensive SQL security, performance, and quality analysis across MySQL, PostgreSQL, SQL Server, and Oracle databases.

Source

Repository: https://github.com/github/awesome-copilot

sql-code-review FAQ

What does the sql-code-review skill do?

Universal SQL code review assistant that performs comprehensive security, maintainability, and code quality analysis across all SQL databases (MySQL, PostgreSQL, SQL Server, Oracle). Focuses on SQL injection prevention, access control, code standards, and anti-pattern detection. Complements SQL optimization prompt for complete development coverage. Principle of Least Privilege: Grant minimum required permissions Role-Based Access: Use database roles instead of direct user permissions

What does sql-code-review require?

Missing Indexes: Identify columns that need indexing

How do I install sql-code-review?

Run: npx -y skills add https://github.com/github/awesome-copilot --skill sql-code-review --agent claude-code — the source lives at github.com/github/awesome-copilot.

Maintain sql-code-review?

Let people know it's listed here — add the badge (live metrics, light/dark aware) or a plain link to your README or docs.

sql-code-review on getagentictools
[![sql-code-review on getagentictools](https://getagentictools.com/badge/skills/github-awesome-copilot-sql-code-review.svg)](https://getagentictools.com/skills/github-awesome-copilot-sql-code-review?ref=badge)
npx agentictools info skills/github-awesome-copilot-sql-code-review

The second line is the CLI lookup for this page — handy in READMEs and docs.