Проектирование схем PostgreSQL

★ 8.5 · data

postgresql is a Claude Code skill that designs and reviews PostgreSQL-specific schemas following best practices for data types, indexing, constraints, and advanced database features. It covers primary key selection (`BIGINT GENERATED ALWAYS AS IDENTITY` vs. `UUID`), normalization to 3NF with justified denormalization, `NOT NULL` and `DEFAULT` placement, and manual index creation for FK columns that PostgreSQL does not auto-index. The skill addresses common PostgreSQL gotchas: MVCC dead tuples and vacuuming, `UNIQUE` behavior with NULLs, sequence gaps, and the absence of clustered storage by default. Useful for developers and architects building schemas for optimal performance and maintainability — covering type selection (`TIMESTAMPTZ`, `NUMERIC`, `TEXT`, `JSONB`, arrays, range types, `TSVECTOR`) and patterns for full-text search, network types, and vector similarity with `pgvector`.