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.
Only table names from the current database are suggested after the FROM keyword.
Column names from the current table are suggested after the WHERE clause.
Insert statement will suggest the column names.
Aliases in the query are resolved and the columns from the table aliases are suggested.
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:
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: