UUID v7 Generator: Time Ordered IDs

UUID v7 Generator

UUID version 7 pairs a 48 bit millisecond timestamp with 74 bits of randomness in the familiar 8-4-4-4-12 format. The result sorts by creation time with plain string comparison while keeping 74 bits of uniqueness per millisecond. It is the IETF recommended UUID for database keys, event streams, and distributed systems that need order without coordination.

Anatomy of a v7 Value

Read the first 12 hex digits as one integer to recover the timestamp. The third group starts with 7, marking the version.

How to Use

1. The tool opens in v7 mode with a fresh ID ready
2. Click Generate for single values or bulk generate for seed data
3. IDs from later milliseconds always sort after earlier ones
4. Copy and use as primary keys, event IDs, or stream cursors

Database Notes

Postgres 18 ships uuidv7() natively. On older versions use the pg_uuidv7 extension or generate in the app layer. For MySQL and SQLite, store as CHAR(36) or BLOB(16) and generate client side. Keep an explicit created_at column anyway: the embedded timestamp records ID generation, not business event time, and clocks can skew.

For opaque tokens use the UUID v4 Generator instead, and read the full v4 vs v7 comparison before choosing.