Name: Backend Queries
Author: overtimepog

Backend Queries

Write efficient, secure database queries using ORMs or raw SQL, preventing N+1 problems, SQL injection, and performance issues. Use this skill when writing database queries, implementing data access layers, creating repository patterns, or optimizing query performance in service files, query builders, or data access objects. Apply this skill when using parameterized queries, implementing eager loading to avoid N+1 queries, selecting only needed columns, adding WHERE/JOIN/ORDER BY clauses, or working with query optimization, indexes, and database performance tuning. This skill ensures queries use proper SQL injection prevention, implement transactions for data consistency, cache expensive queries appropriately, and follow best practices for query timeouts, connection pooling, and database resource management.

overtimepog0 星標2025年12月2日

職業
分類: SQL 數據庫

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.

When to use this skill

When writing database queries using ORM methods or query builders
When implementing raw SQL queries with proper parameterization
When creating repository patterns or data access layers
When optimizing queries to prevent N+1 query problems using eager loading
When adding JOINs, WHERE clauses, or complex query logic
When selecting specific columns instead of using SELECT * for performance
When implementing query pagination, filtering, or sorting logic
When wrapping related database operations in transactions
When adding query timeouts or implementing query performance monitoring
When working with query optimization, EXPLAIN plans, or index usage analysis
When implementing query caching strategies for expensive or frequent queries
When preventing SQL injection through parameterized queries and input validation
When working with files like queries.py, repositories/, dao/, or service layer query logic

Backend Queries

overtimepog0 星標2025年12月2日

職業
分類: SQL 數據庫

When to use this skill

When writing database queries using ORM methods or query builders

When implementing raw SQL queries with proper parameterization

When creating repository patterns or data access layers

When optimizing queries to prevent N+1 query problems using eager loading

When adding JOINs, WHERE clauses, or complex query logic

When selecting specific columns instead of using SELECT * for performance

When implementing query pagination, filtering, or sorting logic

When wrapping related database operations in transactions

When adding query timeouts or implementing query performance monitoring

When working with query optimization, EXPLAIN plans, or index usage analysis

When implementing query caching strategies for expensive or frequent queries

When preventing SQL injection through parameterized queries and input validation

When working with files like queries.py, repositories/, dao/, or service layer query logic

Backend Queries

When to use this skill

Backend Queries

When to use this skill

Instructions

Postgres Patterns

Postgres Patterns

Database Migrations

Postgres Patterns

Postgres Patterns

Jpa Patterns