Backend Queries

概要

Enhance application performance and security by implementing industry-standard database interaction patterns within your data access layer. This skill guides the development of robust database operations, focusing on preventing SQL injection through parameterization, eliminating N+1 query overhead with eager loading, and optimizing execution speed via strategic indexing and precise column selection. Whether working with raw SQL or modern ORMs like Prisma and Sequelize, it ensures every database interaction is transactionally sound, resource-efficient, and follows best practices for caching and timeouts.

主な機能

• Resolves N+1 query problems using eager loading and optimized JOIN operations
• 0 GitHub stars
• Implements strategic indexing for WHERE, JOIN, and ORDER BY clauses
• Manages database transactions for complex, multi-step relational operations
• Prevents SQL injection attacks through the use of parameterized queries
• Optimizes resource usage through specific column selection and query caching

ユースケース

• Implementing complex filtering, sorting, and pagination for large datasets
• Refactoring legacy data access code to improve performance and security standards
• Developing secure and high-performance API endpoints that interact with relational databases