AI query suggestion

Note: This feature is available in Lite, Enterprise, and Ultimate editions only.

Table of contents

• Using AI 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.

Using AI query suggestion

1. Enable AI query suggestion in the SQL Competition preferences.

2. Start writing a query in the SQL Editor.

3. Add a comment above the query to guide the AI.

   Example:

   -- 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.

4. 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).

     

5. 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.