UUIDv7 is not a drop-in replacement for your sequence number.

UUIDv7 is not a drop-in replacement for your sequence number. It buys distribution and index-locality but not strict ordering, stable pagination semantics, or business meaning. The RFC allows implementations to alter timestamps and real-world libs like Python’s uuid7 can advance timestamps to avoid regressions, producing IDs that aren’t strictly time-ordered or that embed misleading times. Use UUIDv7 for sharding and write-hot index locality; keep a real serial, monotonic sequence, or authoritative timestamp column when you need exact ordering or cursor stability.