Skip to main content
Use selfcheck when evaluating supaschema against an existing database or after upgrading the engine. The command extracts a live catalog, re-renders the modeled SQL, re-extracts it, and reports identity normalization gaps.

​
Use this when

  • You are validating catalog normalization.
  • A provider-specific object shape may need investigation.
  • An upgrade should be checked against a real database.
  • You need diagnostics for engine parity work.

​
Run it

npx supaschema selfcheck --database-url "$DATABASE_URL"
selfcheck is a diagnostic tool, not a deployment gate. Review mismatches before deciding whether they matter.

​
Flags

​
--database-url
url
PostgreSQL URL to extract. Defaults to normal database URL resolution.

​
Exit codes

CodeMeaning
0Selfcheck completed without error diagnostics
1Runtime failure or missing database URL
2Diagnostics contained an error

Inspect

Print the extracted model directly.

Fingerprint

Compare normalized model hashes.

Corpus

Run dirty-real regression coverage.

Support matrix

Check modeled object coverage.
Last modified on June 16, 2026