AutoCompletion

Context-sensitive

Auto-completion is on by default. The REPL will pop up a suggestion menu as soon as you start typing. The suggestions are context sensitive based on the position of the cursor.

Table

Only table names from the current database are suggested after the FROM keyword.

Column

Column names from the current table are suggested after the WHERE clause.

Insert

Insert statement will suggest the column names.

Alias

Aliases in the query are resolved and the columns from the table aliases are suggested.

Fuzzy Match

The completions are matched using a fuzzy algorithm. For example typing ‘djmi’ will match the table ‘django_migrations’ because ‘djmi’ has parts of matching substrings. Here’s an example:

Auto-Suggestion

Suggest commands from the history that can be auto-completed by pressing the right arrow key (or Ctrl-F). If you have used Fish-shell you will be familiar with this feature. Here is an example: