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.
The sql-code-review skill serves as a comprehensive SQL code review assistant designed to improve the quality, security, and performance of SQL code across various database platforms, including MySQL, PostgreSQL, SQL Server, and Oracle. By analyzing SQL code for security vulnerabilities, code maintainability, and adherence to best practices, it helps developers identify potential issues before they cause problems in production environments. The skill ensures that SQL queries are optimized, safe from SQL injection attacks, and comply with industry standards for data access and protection.
To use sql-code-review, you can either select specific SQL code or review an entire project. The skill will analyze the code for security, performance, and maintainability issues based on predefined best practices.
The sql-code-review skill supports MySQL, PostgreSQL, SQL Server, and Oracle databases.
No, the sql-code-review skill provides recommendations and highlights issues in the code, but it does not automatically fix them. Developers can manually apply the suggested changes.
It performs a thorough analysis focusing on SQL injection prevention, access control and permissions, data protection (e.g., encryption, audit logging), and security best practices.
Yes, the skill helps with query structure analysis, indexing strategies, join optimizations, and aggregate/window function performance improvements.
Quick Setup:
.claude/skills/Repository
github/awesome-copilot