🏁 Final Week — Lifetime Pro $39 until July 10. Claim yours →

Schema Lockfile Generator

Pin your database schema to a deterministic fingerprint. Generate a schema.lock file and a CI verification script that catches unexpected drift before it reaches production.

🔐 Generate a schema lockfile

Paste a full or partial schema dump. Comments and whitespace are normalized before hashing.
Used in the lockfile metadata and default filename.

⚡ How it works

1

Paste your schema dump

Any CREATE TABLE, CREATE INDEX, and ALTER TABLE statements work. We parse and normalize them in your browser.

2

Generate a deterministic fingerprint

We sort tables, columns, and indexes; strip comments; and compute a SHA-256 hash. The same schema always produces the same hash.

3

Commit the lockfile and verify in CI

Save schema.lock in your repo. Your CI pipeline regenerates the hash and fails if it drifts from the committed value.

🛡️ What it catches

🔴 Unexpected schema drift

Catch when a committed schema dump no longer matches the expected state.

🟡 Missing migration files

If the schema changes but the lockfile was not updated, the build fails.

🔒 Environment parity

Compare schema fingerprints across staging and production to detect drift.

📦 No database required

Works entirely from SQL files — no live connection needed.

Want schema diff reports on every pull request?

The free SchemaLens GitHub Action goes beyond lockfiles — it comments the full semantic diff, migration SQL, and risk score directly on PRs.

Add the GitHub Action → Try pre-commit hook
Lockfile hashing runs entirely in your browser. No schema data is sent to SchemaLens unless you use the optional CI script. Privacy policy · Pricing