Find and fix problems with AI

1. Select a code fragment and click in the popup that appears.

2. In the menu, click Find Problems.

   

   The AI Chat will open, where the model will analyze the selected code fragment, identifying potential issues and suggesting possible solutions.

   

1. Place the caret at a highlighted error in the editor. Then click the red light bulb icon or press Alt+Enter to open the list of suggestions.

2. Click Fix with AI (in DataGrip, Fix with AI Assistant).

   

   AI Assistant uses the Edit mode to gather all required context and sends it to the LLM to determine the fix for your problem.

   The model then provides reasoning for the changes in the AI Chat and lets you decide whether you want to apply the suggested changes or not.

3. Process the changes either in the diff that opens in the editor, or directly in the chat.

   

   • Discard All – click to discard the proposed changes.

   • Accept All – click to apply changes to all affected files.

   • Show Changes in Toolbar – click to display the list of affected files in a separate toolbar.

   • Show Diff – click to open the diff viewer for the selected file. Diff viewer is used to visually compare and review differences between the file versions, helping you to understand what has changed.

   • ± Create Patch – click to create a .patch file containing the changes. This file can be applied to your sources later.

   • Accept – click to apply changes to the selected file.

   • Discard – click to discard changes proposed for the selected file.

   • Group By – click to select how you want to group the modified files – by directory or module.

   • Compare Previous/Next File – compare changes in the previous or next file.

   • Previous/Next Difference – jump to the previous or next difference.

   • Accept all in the current file – apply all suggested changes.

   • Discard all in the current file – discard all suggested changes.

   • Revert – available in the gutter, click to revert a specific change.

   • Accept – available in the gutter, click to accept a specific change.

1. In the editor, invoke the intention actions by placing the caret at the highlighted code and pressing Alt+Enter, then select AI Actions.

2. In the AI Actions dialog, select Fix SQL problem under caret.

AI Assistant will provide its fix in editor.

• In the editor, invoke the intention actions by placing the caret at the highlighted code and pressing Alt+Enter, then select Fix with AI Assistant.

AI Assistant will provide its fix in editor.

Explain SQL errors

AI Assistant can explain the SQL execution error in your code. You can also ask further questions about the error in AI chat.

This feature may require attaching the database schema to suggest proper explanations.

1. After running an SQL query and encountering a query execution error, click Explain with AI in the error message area.

   

2. AI Assistant opens AI chat with an automatically sent prompt and AI Assistant’s response, providing an explanation of the error.

   

Fix SQL errors

AI Assistant can fix the SQL execution error in your code.

This feature may require attaching the database schema to suggest proper fixes.

1. After running an SQL query and encountering a query execution error, click Fix with AI in the error message area.

   

2. AI Assistant generates a fix for the query execution error in the editor.