Skip to content

Keyboard shortcuts ​

⌘ / shows this list inside the app (also Help › Keyboard Shortcuts).

Queries ​

ShortcutAction
⌘ ↵Run the selection, the statement under the cursor, or the tab
⌥ ⌘ ↵Run in a transaction
⇧ ⌘ FFormat SQL
⌘ LComment or uncomment
⌘ SSave staged edits (also in the Redis, MongoDB and notebook editors)
TabExpand a snippet
EscShow autocomplete

Editor and files ​

ShortcutAction
⌘ OOpen a SQL file
⌥ ⌘ SSave the query as a SQL file
⌥ ⌘ FFind in the editor
⌘ = / ⌘ -Zoom the editor in and out
⌘ 0Reset the editor zoom
ShortcutAction
⌘ KCommand palette
⇧ ⌘ OGlobal search for tables and columns
⌘ FFind in the table
↑ ↓Previous and next match, or row in the row detail
⌘ YQuery history (from a query tab)
⌘ BQuery Library (from a query tab)
⇧ ⌘ AAsk your data (from a query tab)

Tabs and connections ​

ShortcutAction
⌘ TNew query tab
⌘ WClose the tab (pinned tabs stay)
⌘ RRefresh: reload the table, re-run the query, reload the schema
⌘ ,Settings

Mouse ​

ActionResult
Double-click a connection cardConnect
Double-click a cellEdit it (editable grid) or inspect it (read-only grid)
⌥-click a column headerAggregate the column (read-only grid)
⇧-click, ⌘-click rowsSelect several rows

Lily DB is free for personal and commercial use.