Communitygithub.com

YepAPI/skills

Normalização de esquemas, estratégia de indexação e padrões de migração.

O que é skills?

Esta skill fornece uma abordagem estruturada e boas práticas para design de banco de dados, abrangendo desde a normalização de esquemas até estratégias de indexação e migração. Ela define regras claras para alcançar a Terceira Forma Normal (3FN) como padrão, permitindo desnormalização apenas quando há necessidade comprovada de performance. A skill também cobre a criação de índices para chaves estrangeiras e colunas frequentemente filtradas ou ordenadas, além de migrações versionadas com scripts up e down. Suporta plataformas como Prisma, Supabase e ambientes serverless, com recomendações para pooling de conexões, backups automáticos e otimização de consultas usando EXPLAIN ANALYZE.

Funciona com~Claude Code~Codex CLI~Cursor
npx skills add https://github.com/YepAPI/skills/tree/HEAD/skills/database
Ver original→Navegar por todas as habilidades

Perguntar na sua IA favorita

Abre um novo chat com esta habilidade de agente já pré-carregada.

OpenAIChatGPTClaudeClaudeGeminiGeminiGrokGrokPerplexityPerplexityDeepSeekDeepSeek

Documentação

Design de Banco de Dados

Regras

  • Normalize para 3FN por padrão — desnormalize apenas para necessidades de performance medidas
  • Estratégia de índices: chaves primárias (automáticas), chaves estrangeiras, colunas frequentemente filtradas/ordenadas
  • Migrações: versionadas, up + down, nomes descritivos
  • Dados de seed para desenvolvimento — dados de teste realistas, não foo/bar
  • Exclusões lógicas (deletedAt) para registros voltados ao usuário — exclusão física para dados verdadeiramente efêmeros
  • UUIDs para IDs públicos — inteiros auto-incrementados para relações internas
  • Pooling de conexões para serverless — PgBouncer, Prisma Accelerate ou pooler do Supabase
  • Estratégia de backup: backups automáticos diários, processo de restauração testado
  • Otimização de consultas: EXPLAIN ANALYZE, evite SELECT *, use colunas específicas

Individual skills in this repo

This repo contains 20 individual skills — each has its own dedicated page.

YepAPI/skills

WCAG 2.1 AA — semantic HTML, keyboard navigation, screen readers.

YepAPI/skills

Experiment setup, variant splitting, statistical significance, and feature flag integration.

YepAPI/skills

CRUD generators, data tables, user management, role-based access, and bulk operations.

YepAPI/skills

Monitor what ChatGPT and Gemini say about your brand using YepAPI.

YepAPI/skills

Queue workers with BullMQ/Inngest/Trigger.dev, job retries, dead letter queues, concurrency.

YepAPI/skills

Commander.js, interactive prompts with Clack, spinners, colors, config files, exit codes, and npm publishing.

YepAPI/skills

cmdk integration, Cmd+K trigger, fuzzy search, grouped actions, keyboard navigation, and dynamic action registration.

YepAPI/skills

Content planning with trend and sentiment data from YepAPI.

YepAPI/skills

Content calendar, keyword-driven planning, and content briefs.

YepAPI/skills

Theme switching with CSS variables, system preference detection, next-themes, and persistence.

YepAPI/skills

Threaded comments, @mentions, reactions, moderation queue, optimistic UI, and cursor pagination.

YepAPI/skills

Competitive analysis between domains using YepAPI.

YepAPI/skills

Layout grids, KPI cards, data tables with sorting/filtering, sidebar navigation, and responsive breakpoints.

YepAPI/skills

Data encryption — TLS everywhere, AES-256-GCM for PII, bcrypt passwords, encrypted backups.

YepAPI/skills

Chart patterns with Recharts/Nivo/D3, responsive containers, color scales, and accessibility.

YepAPI/skills

Drizzle schema definition, push vs migrate, type-safe queries, relations, transactions, and prepared statements.

YepAPI/skills

Upload handling, resize/compress, CDN delivery, blur placeholders, and next/image patterns.

YepAPI/skills

Local business and Google Maps research using YepAPI.

YepAPI/skills

Cursor-based pagination, IntersectionObserver, virtualized lists with @tanstack/react-virtual, and scroll position restoration.

YepAPI/skills

Chat UI components, streaming responses with AI SDK, context window management, and RAG patterns.

Habilidades Relacionadas

steipete/sag

ElevenLabs text-to-speech with mac-style say UX.

community

steipete/oracle

Oracle CLI second-model review/debug/refactor/design with selected files, dry-run token checks, API or browser engine.

community

steipete/peekaboo

Capture and automate macOS UI with the Peekaboo CLI.

community

mattpocock/design-an-interface

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".

community

mattpocock/prototype

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.

community

mattpocock/grill-me

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".

community