Keyboard Shortcuts
- F5 - Execute query
- Ctrl+N - New query tab
- Ctrl+S - Save database
- Ctrl+W - Close current tab
- Ctrl+Tab - Switch to next tab
Drag & Drop
Drag CSV, JSON, or SQL files anywhere in the window to import them automatically.
Object Explorer
Click on a table to expand and see columns. Right-click for quick actions:
- Preview - Shows first 100 rows
- SELECT - Inserts SELECT statement into editor
SQL Functions
tinySQL supports standard SQL plus extended functions like MINMAX_BY, window functions, and more.