backend-queries
Write secure, optimized database queries using parameterized statements, eager loading, proper indexing, and transaction management. Use this skill when writing database queries, implementing data fetching logic, optimizing query performance, preventing SQL injection, handling N+1 query problems, using ORMs or query builders, implementing caching strategies, or managing database transactions. Apply when working with SQL queries, ORM query methods, database repository patterns, or any code that retrieves or manipulates data from databases.
Packaged view
This page reorganizes the original catalog entry around fit, installability, and workflow context first. The original raw source lives below.
Install command
npx @skill-hub/cli install eis-its-vss-cli-backend-queries
Repository
Skill path: .claude/skills/backend-queries
Write secure, optimized database queries using parameterized statements, eager loading, proper indexing, and transaction management. Use this skill when writing database queries, implementing data fetching logic, optimizing query performance, preventing SQL injection, handling N+1 query problems, using ORMs or query builders, implementing caching strategies, or managing database transactions. Apply when working with SQL queries, ORM query methods, database repository patterns, or any code that retrieves or manipulates data from databases.
Open repositoryBest for
Primary workflow: Write Technical Docs.
Technical facets: Full Stack, Backend, Data / AI, Tech Writer.
Target audience: everyone.
License: Unknown.
Original source
Catalog source: SkillHub Club.
Repository owner: EIS-ITS.
This is still a mirrored public skill entry. Review the repository before installing into production workflows.
What it helps with
- Install backend-queries into Claude Code, Codex CLI, Gemini CLI, or OpenCode workflows
- Review https://github.com/EIS-ITS/vss-cli before adding backend-queries to shared team environments
- Use backend-queries for development workflows
Works across
Favorites: 0.
Sub-skills: 0.
Aggregator: No.
Original source / Raw SKILL.md
--- name: Backend Queries description: Write secure, optimized database queries using parameterized statements, eager loading, proper indexing, and transaction management. Use this skill when writing database queries, implementing data fetching logic, optimizing query performance, preventing SQL injection, handling N+1 query problems, using ORMs or query builders, implementing caching strategies, or managing database transactions. Apply when working with SQL queries, ORM query methods, database repository patterns, or any code that retrieves or manipulates data from databases. --- # Backend Queries ## When to use this skill - When writing database queries using ORM methods or raw SQL - When implementing data fetching logic in controllers, services, or repositories - When optimizing query performance or addressing slow database operations - When using eager loading to prevent N+1 query problems - When implementing filtering, sorting, or pagination for data sets - When writing JOIN operations or querying related data - When using parameterized queries to prevent SQL injection - When implementing database transactions for related operations - When adding query timeouts or performance monitoring - When caching expensive or frequently-run queries - When selecting specific columns instead of using SELECT * - When creating database indexes to optimize query performance - When refactoring queries for better efficiency or readability 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](../../../agent-os/standards/backend/queries.md)