The Command Palette provides access to actions that can be performed in Coginiti. This post consists of commands that can improve your productivity when writing SQL in the Query Editor.
Command Palette
To access the Command Palette, press Command+Shift+P (Mac) / Ctrl+Shift+P (Windows). To open the Command Palette via UI, go to View -> Command Palette
or select Command Palette from the right click context menu within a query editor tab
In addition, it's possible to define a keyboard shortcut suitable for you to view the Command Palette. To do this, go to Coginiti top menu -> Keybindings..., search for the Command Palette keybindings, double click on it and set key combination.
Command Palette Actions
Add Cursor Above
Open the Command Palette and select the Add Cursor Above action
or press Option+Command+Up (Mac) / Alt+Control+Up (Windows)
Add Cursor Below
Option+Command+Down (Mac) / Alt+Control+Down (Windows)
Add Cursors to Bottom
Open the Command Palette and select the Add Cursors to Bottom action
Add Cursors to Top
Open the Command Palette and select the Add Cursors to Top action
Add Selection to Next Find Match
Command+D (Mac) / Control+D (Windows)
Change All Occurrences
Command+F2 (Mac) / Control+F2 (Windows)
Copy Expanded SQL Code
Open the Command Palette and select the Copy Expanded SQL Code action
Copy Line Down
Option+Shift+Down (Mac) / Alt+Shift+Down (Windows)
Copy Line Up
Option+Shift+Up (Mac) / Alt+Shift+Up (Windows)
Delete All Left
Open the Command Palette and select the Delete All Left action (Command+Delete (Mac) / Control+Backspace (Windows))
Delete All Right
Open the Command Palette and select the Delete All Right action (Control+K (Mac) / Control+K (Windows))
Delete Line
Open the Command Palette and select the Delete Line action (Shift+Command+K (Mac) / Shift+Control+K (Windows))
Editor Font Zoom In
Open the Command Palette and select the Editor Font Zoom In action
Editor Font Zoom Out
Open the Command Palette and select the Editor Font Zoom Out action
Editor Font Zoom Reset
Open the Command Palette and select the Editor Font Zoom Reset action
Find and Replace
Command+F (Mac) / Control+F (Windows)
Find and Replace with Regex
Command+F (Mac) / Control+F (Windows)
Fold
Option+Command+[ (Mac) / Alt+Control+[ (Windows)
Unfold
Option+Command+] (Mac) / Alt+Control+] (Windows)
Fold All
Option+Command+0 (Mac) / Alt+Control+0 (Windows)
Unfold All
Option+Command+J (Mac) / Alt+Control+J (Windows)
Fold All Block Comments
Option+Command+/ (Mac) / Alt+Control+/ (Windows)
Fold All Regions
Option+Command+8 (Mac) / Alt+Control+8 (Windows)
Unfold All Regions
Option+Command+9 (Mac) / Alt+Control+9 (Windows)
Fold Recursively
Option+Command+R (Mac) / Alt+Control+R (Windows)
Format Document
Option+Shift+F (Mac) / Alt+Shift+F (Windows)
Format Selection
Option+Command+S (Mac) / Alt+Control+S (Windows)
Indent Line
Command+] (Mac) / Control+] (Windows)
Outdent Line
Command+[ (Mac) / Control+[ (Windows)
Insert Line Above
Shift+Command+Enter (Mac) / Shift+Control+Enter (Windows)
Insert Line Below
Shift+Enter (Mac) / Shift+Enter (Windows)
Move Line Down
Option+Down (Mac) / Alt+Down (Windows)
Move Line Up
Option+Up (Mac) / Alt+Up (Windows)
Multiple Selection
Hold Option (Mac) / Alt (Windows) and double-click a word
Select Text
Hold Shift+Option (Mac) / Shift+Alt (Windows) and drag holding the left mouse button
Toggle Block Comment
Option+Shift+A (Mac) / Alt+Shift+A (Windows)
Toggle Line Comment
Command+/ (Mac) / Control+/ (Windows)
Transform to Lowercase
Open the Command Palette and select the Transform to Lowercase action
Transform to Uppercase
Open the Command Palette and select the Transform to Uppercase action
Trigger Suggest
Open the Command Palette and select the Trigger Suggest action (Control+Space (Mac) / Control+Space (Windows))
Trim Trailing Whitespace
Option+Command+X (Mac) / Alt+Control+X (Windows)
Additional useful features
Find Database Objects
- Open the Search sidebar by clicking the the search mark icon in the top right corner of the application.
- Click the filter icon to select DB Objects option
Find Query History
- Open the Search sidebar by clicking the the search mark icon in the top right corner of the application.
- Click the filter icon to select SQL history option
Get Object Structure
Place the cursor to the object