搵技能.../

Backend Queries | Skills Pool

技能檔案

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.

aiskillstore257 星標2026年1月20日

職業
分類: SQL 數據庫

技能內容

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

npx skills add aiskillstore/marketplace

下載 Skill 打開源碼倉庫

作者: aiskillstore
星標: 257
更新時間: 2026年1月20日
職業

本頁內容

01When to use this skill 02

backend queries

Instructions

資料庫管理員

Postgres Patterns

PostgreSQL database patterns for query optimization, schema design, indexing, and security. Based on Supabase best practices.

Postgres Patterns

PostgreSQL database patterns for query optimization, schema design, indexing, and security. Quick reference for common patterns, index types, data types, and anti-pattern detection. Based on Supabase best practices.

Database Migrations

Database migration best practices for schema changes, data migrations, rollbacks, and zero-downtime deployments across PostgreSQL, MySQL, and common ORMs (Prisma, Drizzle, Django, TypeORM, golang-migrate). Use when planning or implementing database schema changes.

Postgres Patterns

쿼리 최적화, 스키마 설계, 인덱싱, 보안을 위한 PostgreSQL 데이터베이스 패턴. Supabase 모범 사례 기반.

Postgres Patterns

PostgreSQL database patterns for query optimization, schema design, indexing, and security. Based on Supabase best practices.

Jpa Patterns

Spring Boot中的JPA/Hibernate模式，用于实体设计、关系处理、查询优化、事务管理、审计、索引、分页和连接池。

資料庫管理員