Backend Queries

This Skill provides Claude Code with specific guidance on how to adhere to coding standards for writing secure and optimized database queries.

When to use this skill

• When writing database query code in services, repositories, or data access layers
• When working with files containing database queries (services.ts, repositories.ts, queries.py, dao.java, etc.)
• When using query builders or ORM query methods (TypeORM QueryBuilder, Sequelize queries, SQLAlchemy queries)
• When writing raw SQL queries or stored procedure calls
• When optimizing N+1 query problems with eager loading or joins
• When selecting specific columns instead of using SELECT *
• When implementing query caching for expensive or frequent queries
• When wrapping related database operations in transactions
• When adding indexes to optimize WHERE, JOIN, or ORDER BY clauses
• When preventing SQL injection by using parameterized queries
• When setting query timeouts to prevent runaway queries
• When implementing pagination or data filtering logic

Instructions

For details, refer to the information provided in this file: backend queries