Search Shortcut cmd + k | ctrl + k
Search cmd+k ctrl+k
1.0 (stable)
Autocomplete

The shell offers context-aware autocomplete of SQL queries through the autocomplete extension. autocomplete is triggered by pressing Tab.

Multiple autocomplete suggestions can be present. You can cycle forwards through the suggestions by repeatedly pressing Tab, or Shift+Tab to cycle backwards. autocompletion can be reverted by pressing ESC twice.

The shell autocompletes four different groups:

  • Keywords
  • Table names and table functions
  • Column names and scalar functions
  • File names

The shell looks at the position in the SQL statement to determine which of these autocompletions to trigger. For example:

SELECT s
student_id
SELECT student_id F
FROM
SELECT student_id FROM g
grades
SELECT student_id FROM 'd
'data/
SELECT student_id FROM 'data/
'data/grades.csv
About this page

Last modified: 2024-06-12