Free Online UUID v7 Generator & Decoder

Generate time-sortable UUID v7 identifiers, decode embedded timestamps, and visualize the bit structure. Perfect for database-friendly primary keys — free, offline, no signup.

UUID v7 Generation
Timestamp Decoding
Bit Visualizer
Bulk Generate
SQL Format
100% Private
Generated UUID v7
0 UUID(s) 0 chars
Bit Structure Visualizer
Generate or decode a UUID to see its structure
Timestamp (48 bits) Version (4 bits) Variant (2 bits) Random (62 bits)
Decode UUID
Paste a UUID v7 above to extract its embedded timestamp

Why UUID v7? The Case for Time-Sortable IDs

UUID v4 is the most common UUID version, but it has a significant drawback for databases: it's completely random. This randomness causes B-tree index fragmentation in databases like PostgreSQL and MySQL, leading to slower inserts and larger index sizes over time.

UUID v7 (defined in RFC 9562) solves this by embedding a Unix timestamp in the first 48 bits. This makes UUIDs naturally time-ordered, which means:

  • Better index performance — new rows always append to the end of the B-tree
  • Built-in created-at — the timestamp is embedded in the ID itself
  • Drop-in replacement — same 128-bit format as UUID v4, works in any UUID column
  • Still globally unique — 62 random bits provide collision resistance

If you've been burned by UUID v4 index fragmentation, read our deep dive on the UUID gotcha and switch to v7.