Inline Editing

Inline editing lets you modify table data directly in the grid cells without writing SQL. tpaw generates the appropriate UPDATE, INSERT, or DELETE statement, shows you the SQL, and asks for confirmation before executing any mutation.

Editing a cell

1. Unlock the grid by clicking the lock icon in the toolbar (if it's in read-only mode)
2. Double-click any cell to enter edit mode
3. Modify the value
4. Press Enter or click another cell to commit the change

tpaw validates the input against the column's data type:

• Numeric columns — rejects non-numeric input
• JSON/JSONB columns — validates JSON syntax before accepting
• Boolean columns — shows a checkbox instead of a text field

When you commit a change, a confirmation modal appears with the generated UPDATE SQL. Click Confirm (or press Cmd+Enter) to execute. Press Escape to cancel.

Editing NULL values

To set a cell to NULL, clear the cell value and commit. tpaw will include = NULL in the generated UPDATE statement.

Inserting a row

Click the + (Add Row) button in the toolbar to open the Insert Row modal. The modal shows all columns with their types and nullability. Fill in values for any non-nullable columns and click Insert.

For tables with a primary key, tpaw generates:

INSERT INTO table_name (col1, col2, ...) VALUES ($1, $2, ...) RETURNING id;

The new row appears in the grid immediately after insertion.

Deleting a row

Select one or more rows (click row numbers, or Shift+Click for range) and click the Delete button in the toolbar. A confirmation modal shows the DELETE FROM ... WHERE id = ... SQL. Pressing Delete/Backspace on the keyboard clears the focused cell value.

Right-click any row → Delete Row for single-row deletion.

Undo

tpaw tracks recent mutations and shows an Undo option after each successful edit. Click Undo in the success toast to generate and execute the reverse operation.

Pending changes

When you have uncommitted cell edits (before confirming the mutation modal), tpaw highlights modified cells with a yellow background. You can revert individual changes by pressing Escape while the cell is in edit mode.

Keyboard shortcuts