# 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

When typing opening characters, closing pairs are automatically inserted:

- `(` → `()`
- `[` → `[]`
- `{` → `{}`
- `'` → `''`
- `"` → `""`
- ``` → ````
- `$` → `$$` (SQL)

Backspace inside empty pair deletes both characters.

### 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)