Database: Insert (Updater)
Use the Database Updater dialog (opened from a dbupdater INSERT step) to set values and review conceptual SQL preview.
The Demo Projects HQ INSERT action opens
Section titled “The Demo Projects HQ INSERT action opens”This step loads the real clients/insert.json action from Demo Projects HQ so the Updater dialog uses the project’s live database connection and schema.
The Server Connect editor is now the focus
Section titled “The Server Connect editor is now the focus”The action now opens in the dedicated Server Connect editor. Collapse the manager so the workflow tree and Properties panel become the clear focus before selecting the database step.
The INSERT step is selected
Section titled “The INSERT step is selected”This step selects the insert_client workflow step so its SQL/Updater options are shown in the Properties panel.
Locate the “Insert Options” button
Section titled “Locate the “Insert Options” button”In the Properties panel, locate the “Insert Options” button for the selected INSERT step. This step matters because Locate the “Insert Options” button is part of Serverconnecteditor Properties Control Sql, and understanding that context makes the next action easier to repeat in your own project.
The Updater dialog opens
Section titled “The Updater dialog opens”The “Insert Options” control opens the Database Updater dialog for this INSERT step. This step matters because The Updater dialog opens is part of Serverconnecteditor Properties Control Sql, and understanding that context makes the next action easier to repeat in your own project.
Database Updater dialog (INSERT)
Section titled “Database Updater dialog (INSERT)”This dialog configures the INSERT query: choose the target table, set column values, and optional RETURNING. The SQL shown in Preview is a conceptual representation of the generated statement, not a data preview.
Values
Section titled “Values”The Values pane maps columns to values (constants or expressions). This example uses $_POST inputs from the action to build the inserted row.
Preview
Section titled “Preview”Use Preview to inspect the generated SQL structure. In Updater dialogs this is conceptual SQL preview only; Preview Data/testing is available in Query Builder dialogs.
Close the Updater dialog
Section titled “Close the Updater dialog”When finished reviewing, you can close the Database Updater dialog to return to the Server Connect editor.
Next steps
Section titled “Next steps”Continue with UPDATE or DELETE (where rules), or return to the Database actions hub.