Проектирование схем реляционных баз данных

★ 6.8 · general

database-design-patterns is a Claude Code skill that guides relational database schema design — covering normalization and denormalization decisions, index type selection (B-tree, GIN, GiST, hash, partial, covering), zero-downtime migrations using the expand-contract pattern, and connection pool configuration for PgBouncer or Prisma. The skill provides visual decision trees for normalization levels (1NF through 3NF), index choice, and migration safety, along with reference files for indexing strategies and rollback approaches. Use it when designing new tables, refactoring existing schemas, or implementing composite keys, surrogate keys, soft deletes, or polymorphic associations. It is not intended for EXPLAIN ANALYZE query tuning, NoSQL document model design, or cloud database provisioning.