資料庫設計規範：綱要正規化、索引策略與遷移模式。
此技能提供一套完整的資料庫設計準則，涵蓋從綱要設計、索引策略到資料遷移與備份的最佳實踐。它預設要求遵循第三正規化（3NF），僅在經由實際效能測試後才允許去正規化。索引方面，除了主鍵自動建立外，還需為外鍵及經常篩選或排序的欄位手動建立索引；所有遷移腳本必須納入版本控制，包含向上（up）與向下（down）操作，並使用描述性命名。此外，針對不同情境提供明確指引：使用者相關記錄採用軟刪除（`deletedAt`），短暫的暫存資料則使用硬刪除；公開 ID 使用 UUID，內部關聯則使用自動遞增整數。技能亦涵蓋 Serverless 環境的連線池配置（如 PgBouncer、Prisma Accelerate、Supabase pooler）、自動化每日備份與還原測試，以及查詢最佳化（使用 `EXPLAIN ANALYZE`、避免 `SELECT *`）。此技能適用於任何使用關聯式資料庫的開發環境，如 Node.js、Python 或 Go 專案，能幫助團隊建立一致且高效能的資料層。
npx skills add https://github.com/YepAPI/skills/tree/HEAD/skills/databasefoo/bardeletedAt）— 真正短暫的資料則使用硬刪除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".