check_db_drift
Detect missing or extra tables, columns, and constraint mismatches by comparing your ERD model against a live database or schema dump.
Instructions
Checks whether a live database (url) or a schema dump (schemaSql) has drifted from the ERD's physical model. Errors: missing/extra tables and columns, PK/FK/NOT NULL mismatches. Warnings (strict promotes to errors): type/unique/auto-increment representation differences. Read-only; the database URL never leaves this process. Pro plan required; requires login.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| url | No | postgres:// or mysql:// URL (exactly one of url/schemaSql) | |
| ignore | No | Table name globs to ignore on the DB side, e.g. flyway_* | |
| source | Yes | Target ERD — exactly one of a local file ({file}) or a server ERD ({erdId}) | |
| strict | No | Promote warnings to errors | |
| dialect | No | Dump dialect (required with schemaSql) | |
| dbSchema | No | Schema to read (url only) | |
| schemaSql | No | Schema dump text, e.g. pg_dump -s output |