Settings & shortcuts
Settings
| Setting |
Default |
What it does |
tablecloth.dataSources |
[] |
Data source definitions, managed through the dialog. Workspace settings hold Project sources, user settings hold Global ones. Never holds a password. |
tablecloth.dialogs.openIn |
floatingWindow |
Open the Data Sources and Import Data dialogs in a separate compact window or as an editor tab. The older tablecloth.dataSourceDialog.openIn is still honoured. |
tablecloth.grid.pageSize |
500 |
Rows per data grid page. Set as Default in the pager menu writes it. |
tablecloth.inspections.enabled |
true |
Flag unresolved tables and columns, and DELETE or UPDATE without WHERE, in consoles and attached SQL files. |
tablecloth.execution.warnWithoutWhere |
true |
Ask before running a DELETE or UPDATE that has no WHERE clause, naming the table and its row count. Changing it resets every console's "Don't ask again" choice. |
tablecloth.explorer.showSystemSchemas |
false |
Show pg_catalog, information_schema, mysql, sys and friends. |
tablecloth.export.nullText |
"" |
Text for NULL in CSV-family exports. |
tablecloth.export.csvQuoteAll |
false |
Quote every value in CSV-family exports. |
Editor shortcuts
These are VS Code keybindings, so they show in the Keyboard Shortcuts editor and can be rebound. Windows and Linux use Ctrl for ⌘.
| Keys |
Command |
Where |
| ⌘⏎ |
Run Statement |
Any SQL editor. Runs the selection if there is one. |
| ⌘⌥L |
Format SQL |
Any SQL editor. |
| ⌘F2 |
Cancel Running Statement |
A console, or an attached SQL file. |
| ⌘⇧O |
Go to Database Object… |
Explorer, Tablecloth panel, console or data editor focused. |
Grid shortcuts
These live inside the grid webview and follow IntelliJ's data editor.
| Keys |
Action |
| Enter / F2 |
Edit the focused cell; Esc cancels, Tab moves along the row |
| ⌘⏎ |
Submit changes (with the DML preview) |
| ⌘⌥Z |
Revert selected |
| ⌘⌥Insert |
Add row |
| ⌘D |
Clone the focused row |
| ⌘⌫ |
Delete selected rows |
| ⇧⏎ |
Show or hide the value editor |
| ⌘F12 |
Column list (hide and show columns) |
| ⌘F |
Find in page |
| ⌘R |
Reload page |
| ⌃Space |
Completion in the WHERE and ORDER BY fields |
| Alt-click a header |
Add the column to the ORDER BY instead of replacing it |
| Arrows, Page Up/Down, Home/End |
Move focus; hold Shift to extend the selection, ⌘-click to toggle rows |