Skip to content

搵技能.../

Agent Skill Search Engine

搜尋

搜尋
分類
職業

About

About
Privacy
Terms

© 2026 Skills Pool. All rights reserved.

When to use this skill: | Skills Pool

技能檔案

When to use this skill:

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.

mshafei7210 星標2026年1月4日

職業
分類: SQL 數據庫

技能內容

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:

相關技能

快速安裝

When to use this skill:

npx skillvault add mshafei721/mshafei721-turbocat-claude-skills-backend-queries-skill-md

下載 Skill 打開源碼倉庫

作者: mshafei721
星標: 0
更新時間: 2026年1月4日
職業

本頁內容

01When to use this skill:02Backend Queries

backend queries

軟件開發人員

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模式，用于实体设计、关系处理、查询优化、事务管理、审计、索引、分页和连接池。

軟件開發人員