sql-code-review

Topics in the source

• SQL Code Review
• 🔒 Security Analysis
• SQL Injection Prevention
• Access Control & Permissions
• Data Protection
• ⚡ Performance Optimization
• Query Structure Analysis
• Index Strategy Review

Perform a thorough SQL code review of ${selection} (or entire project if no selection) focusing on security, performance, maintainability, and database best practices. 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 Encryption: Verify encrypted storage for sensitive data Missing Indexes: Identify columns that need indexing Over-Indexing: Find unused or redundant indexes Composite Indexes: Multi-column indexes for complex queries Index Maintenance: Check for fragmented or outdated indexes Join Types: Verify appropriate join types (INNER vs LEFT vs EXISTS) Join Order: Optimize for smaller result sets first Cartesian Products: Identify and fix missing join conditions Subquery vs JOIN: Choose the most efficient approach Consistent Naming: Tables, columns, constraints follow consistent patterns D

This is an excerpt. Refer to the complete source and its current requirements.