Backend Queries

Optimizing database queries involves writing efficient SQL or ORM code that minimizes round trips, avoids N+1 problems, and uses appropriate indexing. This Skill guides you through constructing, executing, and reviewing queries to meet backend standards for performance, security, and maintainability.

SQL injection occurs when untrusted input is directly concatenated into query strings, allowing attackers to execute arbitrary SQL. Prevention requires parameterized queries, input validation, and secure query construction practices enforced by this Skill.

N+1 problems occur when fetching parent records triggers a separate query for each child record. This Skill guides you to use efficient joins, batch loading, or eager-loading strategies in your ORM to fetch related data in fewer database round trips.

Backend query standards include proper input validation, parameterization, error handling, and logging practices. This Skill enforces compliance with these standards to ensure your queries are secure, maintainable, and interoperable across your application.

Yes. This Skill analyzes existing backend queries, identifies performance bottlenecks, and guides their refactoring to improve speed while adhering to security and maintainability standards.

Yes. This Skill covers optimization techniques for both raw SQL queries and ORM-based queries, ensuring efficient data access regardless of your backend database abstraction layer.