github avatar

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-code

Installs 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

Repository
github.com/github/awesome-copilot
Categories
Backend & APIs, Testing & QA, Security, Git & Pull Requests, Code Review & Quality, AI & Agent Building, Databases

More from github/awesome-copilot

All 318
1clerk avatarclerk-chrome-extension-patternsclerk/skillsChrome Extension auth with @clerk/chrome-extension -- popup/sidepanel setup, syncHost for OAuth/SAML via web app, createClerkClient for service workers and head14.9Kskills.sh installs
2clerk avatarclerk-androidclerk/skillsImplement Clerk authentication for native Android apps using Kotlin and Jetpack Compose with clerk-android source-guided patterns. Use for prebuilt AuthView/Use14.9Kskills.sh installs
3clerk avatarclerk-astro-patternsclerk/skillsAstro patterns with Clerk — middleware, SSR pages, island components, API routes, static vs SSR rendering. Triggers on: astro clerk, clerk astro middleware, ast14.8Kskills.sh installs
4clerk avatarclerk-nuxt-patternsclerk/skillsNuxt 3 auth patterns with @clerk/nuxt - middleware, composables, server API routes, SSR. Triggers on: Nuxt auth, useAuth composable, clerkMiddleware Nuxt, serve14.4Kskills.sh installs
5google avataralloydb-basicsgoogle/skillsManages clusters, instances, and backups for AlloyDB for PostgreSQL, and integrates with AlloyDB Model Context Protocol (MCP) tools for automated database opera14Kskills.sh installs
6samber avatargolang-pkg-go-devsamber/cc-skills-golangGolang package and module documentation and exploration via `godig`, a pkg.go.dev API client (CLI + MCP server) — package docs, API references, symbols, code ex13.3Kskills.sh installs