AI query suggestion

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

Table of contents

• Using AI Auto Complete

AI Auto Complete 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 Auto Complete

1. Enable AI Auto Complete in the SQL Completion 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 -> AI Auto Complete. 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.