AI Assistant Help

Use AI with databases

Available in: DataGrip and IDEs with Database Tools and SQL plugin

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 tool window (Database Explorer in DataGrip), right-click the table that you want to modify and select Modify Table. Alternatively, select the table and press Ctrl+F6.

  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
Last modified: 14 April 2025
Generate terminal commandsAI Assistant in Jupyter notebooks