Documentation/Productivity

Keyboard Shortcuts

Productivity

Keyboard Shortcuts

Tablen provides comprehensive keyboard shortcuts for efficient navigation and operation. All shortcuts follow macOS conventions.

General Shortcuts

Shortcut Action Description
Cmd+T New Tab Create a new query tab
Cmd+W Close Tab Close the active tab
Cmd+1 Switch to Tab 1 Navigate to the first tab
Cmd+2 Switch to Tab 2 Navigate to the second tab
Cmd+3 Switch to Tab 3 Navigate to the third tab
Cmd+4 Switch to Tab 4 Navigate to the fourth tab
Cmd+5 Switch to Tab 5 Navigate to the fifth tab
Cmd+6 Switch to Tab 6 Navigate to the sixth tab
Cmd+7 Switch to Tab 7 Navigate to the seventh tab
Cmd+8 Switch to Tab 8 Navigate to the eighth tab
Cmd+9 Switch to Tab 9 Navigate to the ninth tab
Cmd+L Toggle Sidebar Show or hide the sidebar
Cmd+Shift+N New Connection Open the new connection dialog
Cmd+, Settings Open the Settings window
Cmd+Shift+P Command Palette Open the Command Palette
Cmd+/ Keyboard Shortcuts Show this keyboard shortcuts reference

Query Shortcuts

Shortcut Action Description
Cmd+Return Execute Query Run the current query or selected text
Cmd+E Toggle SQL Editor Show or hide the query editor pane
Cmd+Shift+F Format SQL Format the SQL code with proper indentation
Cmd+Shift+R Refactor SQL Apply SQL refactoring suggestions
Cmd+Y Query History Open the query history panel
Cmd+Shift+B Favorite Queries Open the favorite queries panel
Cmd+Shift+D Add to Favorites Save the current query as a favorite
Cmd+Shift+Q Visual Query Builder Open the visual query builder
Cmd+Option+F Quick Filter Toggle the quick filter bar in the result table

Data Shortcuts

Shortcut Action Description
Cmd+S Commit Changes Save all pending inline edits to the database
Undo Cell Change Revert the last uncommitted cell edit (Edit menu; no dedicated shortcut — Cmd+Z is the system Undo)

Navigation

Shortcut Action Description
Cmd+L Toggle Sidebar Show or hide the sidebar table/connection list
Arrow Keys Navigate Move through sidebar items or result table cells
Enter Select/Confirm Open a selected item or confirm a cell edit
Escape Cancel/Dismiss Cancel editing, close dialogs, dismiss Command Palette
Tab Next Field Move to the next field in forms
Shift+Tab Previous Field Move to the previous field in forms

Result Table

Shortcut Action Description
Click Select Cell Select a single cell
Shift+Click Range Select Select a range of cells or rows
Cmd+Click Toggle Select Add/remove a cell from the selection
Double-Click Edit Cell Enter inline editing mode for a cell
Enter Confirm Edit Accept the current cell edit
Escape Cancel Edit Discard the current cell edit
Cmd+S Commit Commit all pending changes

How Shortcuts Are Handled

Keyboard shortcuts in Tablen are implemented through:

  1. Menu Commands: Defined in DBClientApp.swift using SwiftUI's .commands modifier
  2. NotificationCenter: Menu command triggers are sent as notifications
  3. ContentView: Receives notifications and executes the corresponding actions

This architecture ensures shortcuts work globally regardless of which view has focus.

Customization

Currently, keyboard shortcuts are not customizable. They follow macOS standard conventions and Tablen-specific additions for database operations.

Quick Reference Card

Most Used

Cmd+Return     Execute Query
Cmd+T          New Tab
Cmd+W          Close Tab
Cmd+Shift+P    Command Palette
Cmd+E          Toggle Editor
Cmd+S          Commit Changes
Cmd+L          Toggle Sidebar
Cmd+Shift+N    New Connection
Cmd+,          Settings

SQL Editing

Cmd+Shift+F    Format SQL
Cmd+Shift+R    Refactor SQL
Cmd+Y          Query History
Cmd+Shift+B    Favorites
Cmd+Shift+D    Add to Favorites
Cmd+Shift+Q    Visual Builder
Cmd+Option+F   Quick Filter
Was this page helpful?
Report an issue