SQL Editor Keyboard Shortcuts

Complete reference for Valentina Studio SQL Editor keyboard shortcuts

Navigation

Cursor Movement

Action	Mac	Windows/Linux	Description
Arrow Keys	← ↓ ↑ →	← ↓ ↑ →	Move cursor by character/line
Word Jump	⌥ Option + ← →	Ctrl + ← →	Jump to previous/next word
Line Start	⌘ Cmd + ← or ⌃ Ctrl + A	Home	Move to first non-whitespace or line start
Line End	⌘ Cmd + → or ⌃ Ctrl + E	End	Move to end of line
Document Start	Home or ⌘ Cmd + ↑	Ctrl + Home	Jump to beginning of document
Document End	End or ⌘ Cmd + ↓	Ctrl + End	Jump to end of document
Page Up/Down	Page Up / Page Down	Page Up / Page Down	Scroll one page up/down
Word Part	⌃ Ctrl + / / \	Ctrl + / / \	Jump by word parts (camelCase)

Scrolling (without moving cursor)

Action	Mac	Windows/Linux	Description
Scroll Line	⌃ Ctrl + ↓ ↑	Ctrl + ↓ ↑	Scroll viewport by one line

Selection

Basic Selection

Action	Mac	Windows/Linux	Description
Select All	⌘ Cmd + A	Ctrl + A	Select entire document
Extend Selection	⇧ Shift + Arrow	Shift + Arrow	Extend selection by character/line
Select Word	⇧ Shift + ⌥ Option + ← →	Shift + Ctrl + ← →	Extend selection by word
Select to Line Start	⇧ Shift + ⌘ Cmd + ←	Shift + Home	Extend selection to line start
Select to Line End	⇧ Shift + ⌘ Cmd + →	Shift + End	Extend selection to line end
Select to Document Start	⇧ Shift + Home or ⇧ Shift + ⌘ Cmd + ↑	Shift + Ctrl + Home	Extend selection to document start
Select to Document End	⇧ Shift + End or ⇧ Shift + ⌘ Cmd + ↓	Shift + Ctrl + End	Extend selection to document end
Select Page	⇧ Shift + Page Up/Down	Shift + Page Up/Down	Extend selection by page
Select Paragraph	⇧ Shift + ⌘ Cmd + [ / ]	Shift + Ctrl + [ / ]	Extend selection by paragraph

Multiple Cursors / Multiple Selections

Action	Mac	Windows/Linux	Description
Add Cursor Above	⌃ Ctrl + ⇧ Shift + ↑	Ctrl + Shift + ↑	Add cursor on line above
Add Cursor Below	⌃ Ctrl + ⇧ Shift + ↓	Ctrl + Shift + ↓	Add cursor on line below
Add Cursor at Click	⌥ Option + Click	Alt + Click	Add cursor at arbitrary position
Find Next Occurrence	⌘ Cmd + D	Ctrl + D	Add next occurrence of selection
Clear Extra Cursors	Esc	Esc	Remove all cursors except main

Search & Replace

Action	Mac	Windows/Linux	Description
Find	⌘ Cmd + F	Ctrl + F	Open find panel

Editing

Basic Editing

Action	Mac	Windows/Linux	Description
New Line	Enter / Return	Enter / Return	Insert new line (with auto-indent)
Tab	Tab	Tab	Insert tab or indent
Untab	⇧ Shift + Tab	Shift + Tab	Remove indent
Indent	⌘ Cmd + ]	Ctrl + ]	Increase indent
Unindent	⌘ Cmd + [	Ctrl + [	Decrease indent
Delete	Delete	Delete	Delete character forward
Backspace	Backspace	Backspace	Delete character backward
Toggle Overtype	Insert	Insert	Toggle insert/overwrite mode

Word/Line Deletion

Action	Mac	Windows/Linux	Description
Delete Word Left	⌥ Option + Backspace	Ctrl + Backspace	Delete word to the left
Delete Word Right	⌥ Option + Delete	Ctrl + Delete	Delete word to the right
Delete Line Left	⌘ Cmd + Backspace	Ctrl + Shift + Backspace	Delete from cursor to line start
Delete Line Right	⌘ Cmd + Delete	Ctrl + Shift + Delete	Delete from cursor to line end

Line Operations

Action	Mac	Windows/Linux	Description
Cut Line	⌘ Cmd + L	Ctrl + L	Cut current line to clipboard
Delete Line	⇧ Shift + ⌘ Cmd + L	Shift + Ctrl + L	Delete current line
Copy Line	⇧ Shift + ⌘ Cmd + T	Shift + Ctrl + T	Copy current line (without selection)
Transpose Line	⌘ Cmd + T	Ctrl + T	Swap current line with line above

Line/Code Movement

Action	Mac	Windows/Linux	Description
Move Line Up	⇧ Shift + ⌥ Option + ↑	Shift + Alt + ↑	Move current line(s) up
Move Line Down	⇧ Shift + ⌥ Option + ↓	Shift + Alt + ↓	Move current line(s) down
Move Element Left	⌘ Cmd + ⇧ Shift + ⌥ Option + ←	Ctrl + Shift + Alt + ←	Move SQL element (column, expression) left
Move Element Right	⌘ Cmd + ⇧ Shift + ⌥ Option + →	Ctrl + Shift + Alt + →	Move SQL element (column, expression) right
Move Statement Up	⌘ Cmd + ⇧ Shift + ↑	Ctrl + Shift + ↑	Move SQL statement up
Move Statement Down	⌘ Cmd + ⇧ Shift + ↓	Ctrl + Shift + ↓	Move SQL statement down

SQL Editing

Action	Mac	Windows/Linux	Description
Complete Word	⌃ Ctrl + .	Ctrl + Space	Show autocomplete menu
Toggle Comment	⌘ Cmd + /	Ctrl + /	Comment/uncomment selected lines
Duplicate Line(s)	⌘ Cmd + ⇧ Shift + D	Ctrl + Shift + D	Duplicate current line(s) or selection

Executing Queries

Action	Mac	Windows/Linux	Description
Execute All	⌘ Cmd + E	Ctrl + E	Execute all SQL in editor
Execute Current	⌘ Cmd + ⌥ Option + E	Ctrl + Alt + E	Execute current SQL statement at cursor
Execute Selection	⌘ Cmd + ⇧ Shift + E	Ctrl + Shift + E	Execute selected SQL only

Clipboard

Action	Mac	Windows/Linux	Description
Copy	⌘ Cmd + C	Ctrl + C	Copy selection to clipboard
Cut	⌘ Cmd + X	Ctrl + X	Cut selection to clipboard
Paste	⌘ Cmd + V	Ctrl + V	Paste from clipboard

Undo/Redo

Action	Mac	Windows/Linux	Description
Undo	⌘ Cmd + Z	Ctrl + Z	Undo last change
Redo	⇧ Shift + ⌘ Cmd + Z	Ctrl + Y	Redo last undone change

View & Zoom

Action	Mac	Windows/Linux	Description
Zoom In	⌘ Cmd + Plus (+)	Ctrl + Plus (+)	Increase editor font size
Zoom Out	⌘ Cmd + Minus (−)	Ctrl + Minus (−)	Decrease editor font size
Reset Zoom	⌘ Cmd + 0	Ctrl + 0	Reset zoom to 100%

Text Transform

Action	Mac	Windows/Linux	Description
Lowercase	⌘ Cmd + U	Ctrl + U	Convert selection to lowercase
Uppercase	⇧ Shift + ⌘ Cmd + U	Shift + Ctrl + U	Convert selection to UPPERCASE

Autocomplete & Tooltips

Action	Mac	Windows/Linux	Description
Show Autocomplete	⌘ Cmd + Space	Ctrl + Space	Show autocomplete menu
Cancel	Esc	Esc	Close autocomplete/tooltip

Special Features

Auto-pairing

Placeholders (SQL Snippets)

Action	Mac	Windows/Linux	Description
Next Placeholder	Tab	Tab	Jump to next placeholder field
Previous Placeholder	⇧ Shift + Tab	Shift + Tab	Jump to previous placeholder field
Delete Placeholder	Delete / Backspace	Delete / Backspace	Delete entire active placeholder
Replace Placeholder	Type any character	Type any character	Replace placeholder with typed text

Click'n'Go Mode

Action	Mac	Windows/Linux	Description
Enable Hotspot	Hold ⌃ Ctrl / ⌥ Option / ⌘ Cmd	Hold Ctrl / Alt	Enable clickable identifiers (tables/columns)