PostgreSQL sequences for auto-incrementing IDs: create with pgSequence("name", {startWith, maxValue, minValue, cycle, cache, increment}); use nextval/currval/setval/lastval; supports OWNED BY, cycling, caching; has gaps, out-of-order values, no rollback; PostgreSQL only.