DataGrip 2024.3 Help

Use AI with databases

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 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: 19 July 2024
Chat with AIUse AI prompts to explain and refactor your code