stored-procedures

SKILL.md

Implement stored procedures, functions, and triggers for business logic, data validation, and performance optimization. Covers procedure design, error handling, and performance considerations.

✅ DO use procedures for complex operations ✅ DO validate inputs in procedures ✅ DO handle errors gracefully ✅ DO document procedure parameters ✅ DO test procedures thoroughly ✅ DO use transactions appropriately ✅ DO monitor procedure performance

❌ DON'T put all business logic in procedures ❌ DON'T use procedures for simple queries ❌ DON'T ignore error handling ❌ DON'T create poorly documented procedures ❌ DON'T use procedures as security layer only

데이터베이스 논리를 위한 저장 프로시저 및 함수를 구현합니다. 재사용 가능한 데이터베이스 루틴, 복잡한 쿼리 또는 서버측 계산을 생성할 때 사용합니다. 출처: aj-geddes/useful-ai-prompts.

원본 보기