Skip to main content

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:
  1. Open Command Palette: Ctrl+Shift+P / Cmd+Shift+P
  2. Type “Preferences: Open Keyboard Shortcuts”
  3. Search for specific commands to modify

Productivity Tips

Essential Shortcuts for Koala

Focus on these key shortcuts for maximum productivity:
  1. Ctrl+Enter / Cmd+Enter - Execute queries (most important)
  2. Ctrl+S / Cmd+S - Save your work frequently
  3. Ctrl+/ / Cmd+/ - Comment/uncomment SQL lines
  4. Ctrl+F / Cmd+F - Find text in large queries
  5. Escape - Clear result selections

Workflow Tips

  • Partial Execution: Select SQL text and press Ctrl+Enter / Cmd+Enter to 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