backend-queries
Write optimized and secure database queries using parameterized queries, eager loading, strategic indexing, and proper transaction management. Use this skill when writing database queries, repository methods, or data fetching logic that interacts with SQL or NoSQL databases. Use when implementing query builders, ORM query methods, raw SQL queries, or database service functions. Use when working with files containing database access code (repositories.ts, services.ts, queries.py, dao.java), when optimizing N+1 query problems, implementing query caching strategies, or writing queries with JOINs and WHERE clauses. Use when preventing SQL injection vulnerabilities, setting up query timeouts, or wrapping related operations in database transactions.
When & Why to Use This Skill
This Claude skill provides comprehensive guidance for writing optimized, secure, and high-performance database queries. It empowers developers to implement best practices such as parameterized queries to prevent SQL injection, eager loading to eliminate N+1 performance bottlenecks, and strategic indexing for faster data retrieval across both SQL and NoSQL environments.
Use Cases
- Performance Optimization: Identifying and resolving N+1 query problems using eager loading and strategic JOINs to reduce database load.
- Security Hardening: Implementing parameterized queries and secure data access patterns to eliminate SQL injection vulnerabilities.
- Data Integrity Management: Wrapping complex, multi-step database operations within transactions to ensure atomicity and consistency.
- ORM Best Practices: Writing clean and efficient query logic using modern ORMs and query builders like TypeORM, Sequelize, or SQLAlchemy.
- Database Schema Tuning: Applying strategic indexing and selecting specific columns to optimize query execution plans and reduce latency.
| name | Backend Queries |
|---|---|
| description | Write optimized and secure database queries using parameterized queries, eager loading, strategic indexing, and proper transaction management. Use this skill when writing database queries, repository methods, or data fetching logic that interacts with SQL or NoSQL databases. Use when implementing query builders, ORM query methods, raw SQL queries, or database service functions. Use when working with files containing database access code (repositories.ts, services.ts, queries.py, dao.java), when optimizing N+1 query problems, implementing query caching strategies, or writing queries with JOINs and WHERE clauses. Use when preventing SQL injection vulnerabilities, setting up query timeouts, or wrapping related operations in database transactions. |
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