field-notes / schema history

Migrations

Need help?Mock dataPolicy Studio
Schema changes you can review

Move the database forward without losing the trail.

Compare pending SQL with the applied history, then make the production boundary explicit.

Mock migration ledger No SQL is applied from this preview.
COMING SOON

Migrations is not in this build. The screen below is a design preview: every control is disabled and nothing reaches a deployment. The real path is wrangler d1 migrations, which the CLI will grow into as baseclf migrate.

Migration ledger1 pending · 3 applied
Migration 0007

add_post_visibility

Created12 min agoAuthorMayaTargetlaunch-notes-prod
ALTER TABLE posts ADD COLUMN visibility TEXT
  NOT NULL DEFAULT 'private';

CREATE INDEX idx_posts_visibility
  ON posts (visibility);

UPDATE posts SET visibility = 'public'
  WHERE status = 'published';