SQL Audit Skill

When to Activate

Activate this skill when the user asks to:

• Review SQL queries for production readiness
• Audit database performance or index usage
• Analyze locking risks or concurrency issues
• Review MyBatis mapper XML files
• Check SQL scalability for large datasets

Hard Rule

• Audit ALL mapper XML files in the project — do not skip any.
• Every SQL statement must be checked against ALL review criteria below.
• Report findings with severity ratings — do not silently pass questionable queries.

Instructions