Profile My skills Saved Collections Edit profile Submit a skill

Backend Queries

Write secure, optimized database queries using parameterized statements, eager loading, and proper indexing to prevent SQL injection and N+1 query problems. Use this skill when writing database queries, using ORM query methods, implementing data fetching logic, or optimizing database performance. When working with SQL queries, ORM query builders, repository patterns, or data access layers. When implementing joins, eager loading, query optimization, transactions, or query caching. When selecting data, filtering records, or fetching related associations in service files, repository files, or controller methods.

majiayu000 0a6b56a 2 files · 2.3 KB Updated 567 repo stars
Data & Analytics

File contents

Backend Queries

When to use this skill

  • When writing database queries in any backend file
  • When using ORM query methods (e.g., ActiveRecord, Sequelize, Prisma, SQLAlchemy)
  • When implementing eager loading or joins to prevent N+1 queries
  • When writing raw SQL queries or query builders
  • When optimizing query performance or adding indexes
  • When implementing transactions for related database operations
  • When adding query timeouts or performance monitoring
  • When implementing query caching strategies
  • When selecting specific columns instead of using SELECT *
  • When working in service files, repository files, or data access layers that fetch data

This Skill provides Claude Code with specific guidance on how to adhere to coding standards as they relate to how it should handle backend queries.

Instructions

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

majiayu000/claude-skill-registry-data/tree/main/data/backend-queries commit 0a6b56a423

Browse category

Frequently asked questions

npx skillmds add majiayu000/backend-queries