Simulate
You can simulate schema drift by using Admin mode within Bytebase SQL Editor. It’s similar to operating within your terminal. Visit SQL Editor, connect a database and click the gold wrench icon to enter Admin mode.

Detect
Bytebase has a background process to periodically compare the recorded latest schema with the actual schema in the live database and surface the drift if found. The check interval is configured in Scan Interval. You can also click Sync Database manually from the database detail page to check drift immediately. Schema Drift is detected and displayed under Anomalies section.

Remediate
There are 2 options to remediate the schema drift:- Baseline: Use the live database schema as the source of truth. And establish a new baseline for the Bytebase schema state.
- Revert: Use the Bytebase schema state as the source of truth. And revert the live database schema.
Baseline
WithinSample Project
, go to Database > Databases. Click and enter detail page of database hr_prod
, go to Change History page.
Establish new baseline from top right, you’ll be redirected to an issue page. Create this issue on top right and it rolls out automatically. The newly created baseline appears in Change History.
