스키마 정규화, 인덱싱 전략 및 마이그레이션 패턴
이 스킬은 데이터베이스 설계를 위한 포괄적인 가이드를 제공합니다. 개발자에게 스키마 정규화(기본적으로 3NF), 인덱싱 전략(기본 키, 외래 키, 자주 필터링/정렬되는 컬럼), 버전 제어된 마이그레이션(up + down, 설명적 이름), 시드 데이터(현실적인 테스트 데이터), 소프트 삭제 사용자 대상 레코드 및 하드 삭제 임시 데이터, 공개 ID용 UUID와 내부 관계용 자동 증가 정수, 서버리스용 연결 풀링(PgBouncer, Prisma Accelerate, Supabase pooler), 자동 일일 백업 및 복원 테스트와 같은 백업 전략, EXPLAIN ANALYZE를 사용한 쿼리 최적화 및 SELECT * 회피 등 모범 사례를 설명합니다. Claude Code, Cursor와 같은 AI 에이전트 플랫폼에서 유용하며, SKILL.md 문서에 명시된 규칙을 따릅니다.
npx skills add https://github.com/YepAPI/skills/tree/HEAD/skills/databasefoo/bar가 아닌 실제 테스트 데이터deletedAt) — 정말 일시적인 데이터는 하드 삭제EXPLAIN ANALYZE, SELECT * 회피, 특정 컬럼 사용This repo contains 20 individual skills — each has its own dedicated page.
WCAG 2.1 AA — semantic HTML, keyboard navigation, screen readers.
Experiment setup, variant splitting, statistical significance, and feature flag integration.
CRUD generators, data tables, user management, role-based access, and bulk operations.
Monitor what ChatGPT and Gemini say about your brand using YepAPI.
Queue workers with BullMQ/Inngest/Trigger.dev, job retries, dead letter queues, concurrency.
Commander.js, interactive prompts with Clack, spinners, colors, config files, exit codes, and npm publishing.
cmdk integration, Cmd+K trigger, fuzzy search, grouped actions, keyboard navigation, and dynamic action registration.
Content planning with trend and sentiment data from YepAPI.
Content calendar, keyword-driven planning, and content briefs.
Theme switching with CSS variables, system preference detection, next-themes, and persistence.
Threaded comments, @mentions, reactions, moderation queue, optimistic UI, and cursor pagination.
Competitive analysis between domains using YepAPI.
Layout grids, KPI cards, data tables with sorting/filtering, sidebar navigation, and responsive breakpoints.
Data encryption — TLS everywhere, AES-256-GCM for PII, bcrypt passwords, encrypted backups.
Chart patterns with Recharts/Nivo/D3, responsive containers, color scales, and accessibility.
Drizzle schema definition, push vs migrate, type-safe queries, relations, transactions, and prepared statements.
Upload handling, resize/compress, CDN delivery, blur placeholders, and next/image patterns.
Local business and Google Maps research using YepAPI.
Cursor-based pagination, IntersectionObserver, virtualized lists with @tanstack/react-virtual, and scroll position restoration.
Chat UI components, streaming responses with AI SDK, context window management, and RAG patterns.
ElevenLabs text-to-speech with mac-style say UX.
Oracle CLI second-model review/debug/refactor/design with selected files, dry-run token checks, API or browser engine.
Capture and automate macOS UI with the Peekaboo CLI.
Generate multiple radically different interface designs for a module using parallel sub-agents. Use when user wants to design an API, explore interface options, compare module shapes, or mentions "design it twice".
Build a throwaway prototype to flesh out a design — a runnable terminal app for state/business-logic questions, or several radically different UI variations toggleable from one route.
Interview the user relentlessly about a plan or design until reaching shared understanding, resolving each branch of the decision tree. Use when user wants to stress-test a plan, get grilled on their design, or mentions "grill me".