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.
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.
In the Modify dialog, locate the toolbar of the table structure editor pane on the left side and click
AI Assistant.
In the AI Assistant dialog that opens, enter your prompt and click OK.
Once AI Assistant generates the SQL code for the action of your prompt, it will ask a permission to perform the action. Click Perform.
Review the generated code in the preview pane.
Apply the changes and close the dialog.

Last modified: 14 April 2025