Profile My skills Saved Collections Edit profile Submit a skill

Backend Queries

Write secure, performant database queries using parameterized queries, proper eager loading, and transaction management. Use this skill when writing database queries, ORM operations, raw SQL statements, or repository methods. When working on files in repositories/, queries/, services/, or any code that interacts with the database. When optimizing query performance, preventing N+1 queries, implementing transactions, adding query timeouts, or caching expensive queries. When reviewing code for SQL injection vulnerabilities.

majiayu000 974a6d1 2 files · 1.9 KB Updated 567 repo stars
Data & Analytics

File contents

When to use this skill:

  • When writing database queries (ORM or raw SQL)
  • When creating repository or data access layer methods
  • When working on files in repositories/, queries/, services/, or dal/ directories
  • When using SELECT statements and choosing which columns to fetch
  • When implementing eager loading or joins to prevent N+1 queries
  • When wrapping related operations in database transactions
  • When adding indexes to optimize WHERE, JOIN, or ORDER BY clauses
  • When implementing query timeouts for long-running queries
  • When caching results of expensive or frequently-run queries
  • When reviewing code for SQL injection vulnerabilities
  • When using parameterized queries to prevent injection attacks

Backend Queries

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-mshafei721-turbocat commit 974a6d1779

Browse category

Frequently asked questions

npx skillmds add majiayu000/backend-queries-3