Review dialogs

Seqora stops for review before four kinds of write.

Unlock connection?

Eyebrow WRITE ACCESS, then the connection and environment. Body: "Writes, schema changes, and other mutations will be enabled for this connection." Keep locked (Esc) or Unlock connection (Enter).

Review high-risk SQL

A panel inside the editor, not a dialog. It opens before DDL, an UPDATE or DELETE without a WHERE, and anything Seqora cannot prove read-only. It names the environment, connection and database, then asks for RUN or a click, as set in Settings. The RUN box takes focus, so what you type never lands in the SQL. Esc or Cancel run declines. Run, cancel, and transactions has the full list.

Review staged changes

Opened by Review on the Pending changes bar. Visual diff tags each row UPDATE, DELETE or INSERT with before and after, and JSON cells as Original JSON and Proposed JSON. SQL script shows the "Atomic transaction script for this change set". The footer reads "One transaction · rolls back if any row changed since it loaded". Keep editing (Esc) or Apply 3 changes. Enter applies, except with deletes or on production, where it takes Mod-Enter.

Review changes

Opened by Review and apply in a design. The eyebrow is Review changes, the title the design's name. Three steps, Checks, Dry run and Apply:

• Checks: read-only probes for empty values, duplicates, orphans and dependents, plus design issues. Some need I understand. Check again runs them once more. Rebase onto the live schema appears when "The live schema changed since this design started".
• Dry run: PostgreSQL and SQLite run every statement in a transaction and roll back. MySQL and MariaDB replay on empty copies in a scratch database.
• Apply 4 statements: on production, first type the database name ("This is a production connection. Type <db> to apply."). Afterwards: Changes applied, Save as .sql.

On Free the footer reads "The dry run and apply are part of Pro. This design and its SQL stay saved.", and the apply button carries the Pro badge.

Read: Design a schema change