UUID Use Case

UUID Surrogate Key

A surrogate key has no business meaning. A UUID surrogate shields internal data and stays stable when the 'real' identifier changes.

OpaqueStableDecouples schema

Version

How many

Uppercase Hyphens Braces { }

Result

Generated locally with the Web Crypto API — nothing leaves your browser.

What Is UUID Surrogate Key?

Natural keys (email, username) can change or leak PII. A surrogate UUID is stable and meaningless, so renaming a user never cascades through foreign keys.
Keep the natural attribute unique with a separate UNIQUE constraint; the UUID remains the internal pointer.

How to generate

Make the UUID the primary key.
Add UNIQUE on the natural attribute (email, slug).
Never expose the natural key in URLs if it is sensitive.

Use Cases

User accounts keyed by id, uniquely emailed.
Documents addressed by opaque id, titled by slug.
API resources referenced by id, filtered by name.

Code Examples

PostgreSQL

CREATE TABLE users (
  id UUID PRIMARY KEY DEFAULT gen_random_uuid(),
  email TEXT UNIQUE NOT NULL
);

Frequently Asked Questions

Surrogate vs natural key?

Surrogate (UUID) is stable and PII-free; natural keys are human-meaningful but mutable. Use a surrogate PK and a unique constraint on the natural value.

Does a UUID surrogate hurt joins?

No more than any other key; the 16-byte width is negligible for typical table sizes.

Related tools

UUID v1 Generator UUID v3 Generator UUID v4 Generator UUID v5 Generator UUID v6 Generator UUID v7 Generator UUID v8 Generator Bulk UUID Generator Short UUID Generator UUID Validator UUID Formatter UUID as a Primary Key UUID Database ID UUID Foreign Key UUID Shard Key UUID Partition Key UUID in a Composite Key UUID Surrogate Key UUID API Key UUID Session Token UUID Access Token UUID Refresh Token UUID Idempotency Key UUID Request ID UUID Correlation ID UUID Trace ID UUID CSRF Token UUID Nonce UUID Filename UUID Object Key UUID S3 Key UUID Upload ID UUID Cache Key UUID Blob Name UUID Temp File UUID User ID UUID Account ID UUID Customer ID UUID Device ID UUID Tenant ID UUID Client ID UUID Anonymous ID UUID Member ID UUID Message ID UUID Event ID UUID Job ID UUID Task ID UUID Queue Message ID UUID Transaction ID UUID Order ID UUID Invoice ID UUID Payment ID UUID Reset Token UUID Verification Token UUID Invite Code UUID API Secret UUID Share Link UUID Magic Link UUID Node ID UUID Worker ID UUID Lock ID UUID Cluster ID UUID Test Data UUID Seed Data UUID Fixture UUID Mock ID UUID Placeholder ID UUID Sample ID