数据库设计技能：模式规范化、索引策略和迁移模式。
该技能专注于数据库设计的最佳实践，涵盖数据规范化、索引策略、迁移模式以及数据管理等多个方面。它为开发者提供了一套完整的规则集，帮助构建稳健、高效且易于维护的数据库架构。技能支持通过版本控制管理数据库迁移，确保变更可追溯、可回滚。同时，它强调使用软删除（deletedAt）处理用户相关记录，以保障数据安全性；而真正临时数据则采用硬删除。此外，技能还涉及连接池配置（如PgBouncer、Prisma Accelerate或Supabase Pooler）以及备份策略，确保数据库在无服务器环境下的性能和可靠性。它适用于任何需要数据库设计的项目中，可搭配Claude Code、Cursor、Codex等AI代码工具使用，帮助开发者快速生成符合规范的设计方案。
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".