postgresql

name	postgresql
description	PostgreSQL 18 — production-grade open-source RDBMS. Raw SQL, async I/O, virtual generated columns, OAuth, temporal constraints, UUIDv7, skip-scan B-tree, RLS, extensions. Use when: postgresql, postgres, psql, pg_dump, pg_basebackup, pgBouncer, pg_stat_statements, EXPLAIN ANALYZE, CREATE INDEX CONCURRENTLY, partial index, GIN, GiST, BRIN, pgvector, pg_partman, postgis, logical replication, WAL, vacuum, autovacuum, RLS, CHECK constraint, generated column, JSONB, MERGE, UPSERT, ON CONFLICT. SKIP: ORM-specific (→prisma), MySQL (→mysql cascade), Supabase platform (→supabase cascade), SQLite.
stacks	["postgresql","database","sql","linux"]
packages	[]
tags	["postgresql","postgres","sql","database","rls","indexes","replication","extensions"]
manifests	["postgresql.conf","pg_hba.conf"]
source	vechkasov-global-skills
risk	high-stakes

🎯 Version Requirements (May 2026)

Primary pins:

• PostgreSQL: 18.x

Source of truth: STACK_VERSIONS.md — verified 2026-05-16

Usage

Loaded when the description matches the task. Open only the reference you need.

Use this skill when

• Designing a PostgreSQL 18 schema, picking native types, modeling relationships
• Writing / reviewing raw SQL — DML, DDL, window functions, CTEs, lateral joins, MERGE, RETURNING
• Tuning queries with EXPLAIN (ANALYZE, BUFFERS); identifying seq scans / sort spills
• Designing indexes — B-tree, partial, expression, GIN, GiST, BRIN, multicolumn order, covering
• Configuring transactions, isolation levels, advisory locks, FOR UPDATE / NOWAIT / SKIP LOCKED
• Implementing Row-Level Security (RLS) for multi-tenant separation
• Managing extensions — pgvector, pg_partman, postgis, pg_trgm, citext, pg_stat_statements
• Setting up streaming / logical replication, failover, pg_basebackup, PITR
• Backup & restore — pg_dump/pg_restore, WAL archiving, pgBackRest
• Performance tuning — shared_buffers, work_mem, autovacuum thresholds, pgBouncer pool mode
• Schema migration tooling — Alembic, dbmate, sqitch, Atlas (ORM-agnostic)
• Adopting PG 18 features — async I/O, virtual generated columns, OAuth, uuidv7(), skip-scan B-tree, temporal constraints (WITHOUT OVERLAPS)

Do not use this skill when

• Prisma-ORM-specific (schema.prisma, Prisma migrations) — use prisma
• Drizzle ORM — use drizzle (cascade marker)
• MySQL / MariaDB syntax — use mysql (cascade marker)
• Supabase platform features (auth, edge functions, realtime) — use supabase (cascade)
• SQLite-specific SQL — different dialect
• Postgres ops on Ubuntu (restart, logs via journalctl) — use linux-sysadmin