Step 4: Change Schema

A Plan tracks a database change through automated checks, Review, and Deploy.

Create a Plan

1. Open the project from Step 3, then go to CI/CD > Plans and click + New Plan.

2. Select the database from Step 3 and click Confirm.

3. Write a CREATE TABLE statement, or use Schema Editor to design one visually:

   CREATE TABLE test_table (
     id INT,
     name VARCHAR(50)
   );
   

4. Click Create. Bytebase checks the statement automatically. Inspect the results and correct any errors before continuing.

5. Click Ready for Review to submit the plan.

Without a SQL Review Policy, no policy rules are evaluated; built-in checks still run. Configure a policy to check SQL against your rules.

Review

When no human approval is required, Review completes automatically. Enterprise Custom Approval flows can require a reviewer; if Review is waiting, follow the approval flow shown on the Plan.

Deploy

1. Click Run to deploy, or configure automatic rollout in environment settings.

2. The Plan is marked Deployed when complete.

Every change is recorded — open the database and check its Changelog tab. See Changelog for the full detail. Pro and Enterprise plans unlock Audit Log, which records who did each step of this quick start.

Seed a Row for Step 5

The same Plan → Review → Deploy flow works for data, not just schema — create another plan with an INSERT statement:

INSERT INTO test_table (id, name) VALUES (1, 'Alice');

Review and Approval on a Configured Workspace

The interactive demo shows SQL Review findings and human approval before rollout on a configured workspace.

For a fuller explanation, follow the UI tutorial. To deploy migration files from CI, follow the GitOps walkthrough.