AI coding workspace
Database migrations
Change the schema without losing sight of the rows. SourceHarbor connects migration planning, existing data assumptions and the checks needed before a database change.
● ● ●SourceHarbor●
A concrete starting point · Database migrations ×
-- Inspect existing values before enforcing a constraint.
SELECT COUNT(*) FROM records WHERE status IS NULL;
-- Prepare a backfill and a reversible migration.
-- Test on a disposable database copy first.✳Plan a database column change around the existing rows.
✓ ChangesReview before applying ↗
Illustrative workspace
Review before applying
Compare actual behavior with the expected result. If a check fails, investigate it before applying more changes.
Connection
Base URL, credentials and a reachable server.
Project
Check null values, prepare a backfill and verify a rollback on a disposable copy before touching production data.
A concrete starting point
-- Inspect existing values before enforcing a constraint.
SELECT COUNT(*) FROM records WHERE status IS NULL;
-- Prepare a backfill and a reversible migration.
-- Test on a disposable database copy first.