DataGrip
 
2024.3
Shortcuts: Windows
Get DataGrip
  1. AI Assistant
  2. Use AI with databases

Use AI with databases

Last modified: 19 July 2024

Get AI assistance in modifying tables

You can use a natural language to ask AI Assistant to modify a database table in the Modify dialog.

  1. In Database Explorer, right-click the table that you want to modify and select Modify Table. Alternatively, select the table and press CtrlF6.

  2. In the Modify dialog, locate the toolbar of the table structure editor pane on the left side and click the UI AI Assistant icon AI Assistant.

  3. In the AI Assistant dialog that opens, enter your prompt and click OK.

    Prompt for modifying a table

  4. Once AI Assistant generates the SQL code for the action of your prompt, it will ask a permission to perform the action. Click Perform.

  5. Review the generated code in the preview pane.

  6. Apply the changes and close the dialog.

AI Assistant generated code for modifying a table