
Sql Code Review
The sql-code-review skill performs comprehensive security, performance, and maintainability analysis on SQL code across multiple database systems (MySQL, PostgreSQL, SQL Server, Oracle). It targets developers and database administrators who need to identify SQL injection vulnerabilities, access control issues, performance bottlenecks, and code quality problems in their database queries. The skill solves the problem of conducting thorough code reviews manually by providing automated detection of security risks, anti-patterns, and best practice violations in a single analysis.
- install copies · 90 days. Times the install command was copied on this site in the last 90 days, bots filtered.
- 11
- skills.sh installs
- 15.6K
- GitHub stars
- 41K
- last updated
- Aug 21, 2026
Install
$ npx -y skills add github/awesome-copilot --skill sql-code-review --agent claude-codeInstalls into .claude/skills of the current project.
Files
SQL Code Review
Perform a thorough SQL code review of ${selection} (or entire project if no selection) focusing on security, performance, maintainability, and database best practices.
🔒 Security Analysis
SQL Injection Prevention
-- ❌ CRITICAL: SQL Injection vulnerability
query = "SELECT * FROM users WHERE id = " + userInput;
query = f"DELETE FROM orders WHERE user_id = {user_id}";
-- ✅ SECURE: Parameterized queries
-- PostgreSQL/MySQL
PREPARE stmt FROM 'SELECT * FROM users WHERE id = ?';
EXECUTE stmt USING @user_id;
-- SQL Server
EXEC sp_executesql N'SELECT * FROM users WHERE id = @id', N'@id INT', @id = @user_id;
Access Control & Permissions
- 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
Sponsors
Details
More from github/awesome-copilot
All 318- Chrome Devtools15.4K
- Microsoft Docs15K
- Playwright Explore Website14.8K
- Azure Devops Cli14.8K
- Javascript Typescript Jest14.5K
- Nuget Manager14.5K
- Microsoft Code Reference14.4K
- Web Design Reviewer14.3K
- Playwright Automation Fill In Form13.7K
- Create Specification13.6K
- Game Engine13.4K
- Create Agentsmd13.3K
- Refactor Plan13K
- Pytest Coverage13K
- Penpot Uiux Design12.9K
- Memory Merger12.9K
- Postgresql Code Review12.8K
- Create Implementation Plan12.6K
- Webapp Testing12.5K
- Architecture Blueprint Generator12.3K
- Typescript Mcp Server Generator12.1K
- Java Junit11.8K
- Dotnet Design Pattern Review11.7K
- Dotnet Upgrade11.7K