Миграции PostgreSQL — паттерны и решения

★ 8.0 · vibe-coding

postgres-migrations is a Claude Code skill that provides a comprehensive reference for PostgreSQL schema migrations, covering common errors, idempotent patterns, generated columns, full-text search, and index management. The skill addresses eight practical scenarios: safe re-runnable migrations using IF NOT EXISTS, creating IMMUTABLE wrapper functions for expressions like array_to_string() to use in generated columns and indexes, gracefully handling optional extensions such as pg_trgm and uuid-ossp, resolving circular foreign key dependencies by deferring constraint creation, and optimizing full-text search with tsvector generated columns, GIN indexes, and materialized views with CONCURRENTLY refresh. It targets developers who frequently evolve their PostgreSQL schema and need to avoid common pitfalls when running migrations repeatedly.