Skip to content

Query suggestion

AI query suggestion helps you finish entire SQL statements based on what you’ve started typing. It works inside the SQL Editor and shows suggestions as ghost text.

Show the suggestion

To use the AI query suggestion:

  1. Activate the AI assistant.
  2. Enable AI query suggestion in the SQL Competition preferences.
  3. Start writing a query in the SQL Editor.
  4. Add a comment above the query to guide the AI.

    -- find flight with flight_id equal or less then 1230
    SELECT
    

    Note

    You need to place your cursor where you want the query to appear.

  5. Right-click anywhere in the Script panel to open the context menu, then select AI commands -> Show AI Suggestion Text. Or use the shortcut:

    • ⌄+⌘+→ (macOS).
    • Alt+Ctrl+→ (Windows).

  6. Do one of the following:

    • Press →, Tab, or Enter to insert the suggestion.
    • Press Esc to dismiss it.

Tip

To change the background and foreground colors of the suggestion hint, navigate to Window -> Preferences -> User Interface -> Appearance -> Colors and Fonts.