Overview
Koala Data Explorer Extension includes essential keyboard shortcuts to improve your productivity when writing and executing SQL queries. The shortcuts work within the VS Code environment alongside standard VS Code shortcuts.Essential Shortcuts
The following shortcuts are implemented and available in Koala Data Explorer:Query Execution
Editor Features
Results Management
Editor Navigation
Standard VS Code Shortcuts
Koala Data Explorer works within VS Code, so all standard VS Code shortcuts also apply:File Operations
- New File:
Ctrl+N/Cmd+N - Open File:
Ctrl+O/Cmd+O - Save:
Ctrl+S/Cmd+S - Save As:
Ctrl+Shift+S/Cmd+Shift+S
Text Editing
- Undo:
Ctrl+Z/Cmd+Z - Redo:
Ctrl+Y/Cmd+Y - Cut:
Ctrl+X/Cmd+X - Copy:
Ctrl+C/Cmd+C - Paste:
Ctrl+V/Cmd+V - Select All:
Ctrl+A/Cmd+A
Customizing Shortcuts
You can customize any shortcuts through VS Code’s keyboard shortcuts settings:- Open Command Palette:
Ctrl+Shift+P/Cmd+Shift+P - Type “Preferences: Open Keyboard Shortcuts”
- Search for specific commands to modify
Productivity Tips
Essential Shortcuts for Koala
Focus on these key shortcuts for maximum productivity:Ctrl+Enter/Cmd+Enter- Execute queries (most important)Ctrl+S/Cmd+S- Save your work frequentlyCtrl+//Cmd+/- Comment/uncomment SQL linesCtrl+F/Cmd+F- Find text in large queriesEscape- Clear result selections
Workflow Tips
- Partial Execution: Select SQL text and press
Ctrl+Enter/Cmd+Enterto run only the selection - Line Management: Use
Alt+↑/↓to move lines up/down when organizing queries - Duplicate Lines: Use
Shift+Alt+↓to quickly duplicate useful query patterns
Next Steps
Bind Variables
Use parameters in queries
Writing Queries
SQL query best practices