KeyFoldAccount identity atlas
Field notes

Better Auth account identity map

Same rows. A different key. See what comes together in 1.7.3.

Key contract

Synthetic demonstration · 3 rows

Account identity mapLoading the example…
KEY 01

Inspect the connection.

Choose a row to follow its identifiers.

Only supplied rows are inspected.

Loading the map…

Understanding the atlas Keys, rows, people ↗

Read the connections before changing the data.

A central circle is one lookup key. The surrounding circles are the account rows with that exact key. Switch between issuer and provider contracts to regroup the same records; the tool never changes those records.

Start with the three-row example: two issuers identify different people, then meet at one provider key. The second example shows why duplicate rows are still ambiguous when their user labels match. The third leaves absent issuers unknown.

Before acting on a finding, establish which account schema your deployment actually used. A clear projection can coexist with a remaining NOT NULL issuer column that rejects the next insert. Those are separate observations and separate checks.

Local input, bounded claims. This map compares exact strings in your projection. It cannot see missing database rows, collations, provider ownership or live sign-in behavior. See the real-version tests and exclusions.

After the data review, verify an old and a new account in your own staging app. The map alone cannot establish that either flow works.

Open a small identity projection.

JSON array · 2 MiB · 10,000 rows maximum. Only id, providerId, accountId, userId, issuer. Remove secrets and use consistent aliases. Prepare the file.

Read in this tab only. No database connection or automatic changes.

Source row

The map cannot see your schema.

Record what you checked in a restored database and ORM definition. These declarations do not run SQL or validate the schema.

Read the database-specific boundary ↗

Save a review, not a migration.

The JSON review includes every supplied row, all target groups, source positions, coverage and schema declarations. The readable Markdown summary contains the totals and up to 100 duplicate groups.

Default: consistent aliases. Relationships and source positions remain visible. A downloaded review is not anonymous proof or a database backup.