Skip to main content

Documentation Index

Fetch the complete documentation index at: https://docs.tablepro.app/llms.txt

Use this file to discover all available pages before exploring further.

​
Change Tracking

Changes in TablePro are queued in memory, not applied immediately. Edit cells, insert rows, delete rows, then review everything before committing. Nothing touches the database until you say so.
Change Tracking
Change tracking is per-tab. Switching tabs preserves your edits.

​
Data Changes

TablePro tracks three types of data changes: cell edits, row insertions, and row deletions.

​
Editing Cells

Double-click any cell to edit (see Data Grid). Changes queue immediately.
Modified cells
Changing a value back to its original automatically removes it from the queue.

​
Adding Rows

To insert a new row:
  1. Click the + button in the toolbar or use the keyboard shortcut
  2. A new row appears at the bottom of the data grid, marked with an insertion indicator
  3. Fill in the values for each column
  4. Columns with default values are pre-filled with DEFAULT
Edits to cells in a new row are folded into the insertion, not tracked as separate updates.
Newly added row with insertion indicator

​
Deleting Rows

Select rows and press Delete. Deleted rows show a strikethrough indicator and stay visible until commit or discard.
Deleted row with deletion indicator
Batch deletion of multiple rows is tracked as a single undo action. Undoing a batch deletion restores all rows at once.

​
Commit & Discard

​
Committing Changes

Click Commit or press Cmd+S. TablePro generates parameterized SQL, executes it, clears the queue, and refreshes the grid. Generated SQL:
Change TypeSQL Generated
Cell editUPDATE ... SET column = ? WHERE pk = ?
Row insertionINSERT INTO ... (columns) VALUES (?)
Row deletionDELETE FROM ... WHERE pk = ?
UPDATE statements require a primary key on the table. If no primary key is defined, TablePro shows an error when you try to commit updates. DELETE statements can work without a primary key by matching all column values.

​
Discarding Changes

Click Discard to revert all pending changes and clear the undo/redo stack.

​
Previewing Data SQL

Click the Preview SQL button (eye icon) or press Cmd+Shift+P to see the exact SQL before committing. Use Copy All to copy to clipboard.
The preview inlines parameter values so you can verify exactly what will run. Destructive operations are highlighted with a warning banner.
Commit and Discard buttons with pending changes count

​
Undo & Redo

ActionShortcut
UndoCmd+Z
RedoCmd+Shift+Z
Context-aware: Cmd+Z undoes text edits when the SQL editor is focused, data changes when the grid is focused.
Stacks are per-tab. Committing or discarding clears both stacks.

​
Schema Changes

Table structure changes (columns, indexes, foreign keys) use the same queue-based approach.

​
Tracked Schema Operations

OperationWhat Is Tracked
Add columnNew column definition (name, type, nullable, default, etc.)
Modify columnOld and new column definitions
Delete columnColumn marked for removal
Add indexNew index definition (name, columns, type, uniqueness)
Modify indexOld and new index definitions
Delete indexIndex marked for removal
Add foreign keyNew FK definition (columns, references, actions)
Modify foreign keyOld and new FK definitions
Delete foreign keyFK marked for removal
Modify primary keyOld and new primary key columns

​
Visual Indicators

  • New items: highlighted with an insertion color
  • Modified items: changed fields are marked
  • Deleted items: shown with a deletion indicator
Schema changes highlighted in Structure tab

​
Previewing Schema SQL

Before applying schema changes, preview the generated SQL: Make your changes in the Structure tab, then click Commit (Cmd+S). A preview sheet shows the ALTER TABLE statements. Click Apply Changes to execute or Cancel to go back.
Schema Preview
Copy individual SQL statements from the preview sheet using the copy button next to each statement.

​
SQL Generation

Data changes use parameterized statements. Schema changes produce database-specific ALTER TABLE statements: 
UPDATE `users` SET `name` = ? WHERE `id` = ? LIMIT 1
INSERT INTO `users` (`name`, `email`) VALUES (?, ?)
DELETE FROM `users` WHERE `id` = ? OR `id` = ?

ALTER TABLE `users` ADD COLUMN `phone` VARCHAR(20) NOT NULL
ALTER TABLE `users` MODIFY COLUMN `name` VARCHAR(200) NOT NULL