Release notes

Attaching database objects to AI chat

The database context you provide to AI chat can now be more specific. Now, you can attach the database object you need to work with instead of attaching the whole schema. For example, a table or a view. This can be particularly useful when you’re working with larger schemas.

To attach a database object, type @ or # in the input field, start typing or select dbObject:, the select the object you want to attach.

Cloud-based code completion

DataGrip now supports cloud-based code completion. It uses cloud resources to offer more precise code completion, leveraging greater computational power than local resources can provide. This feature allows the IDE to autocomplete single lines, blocks of code, and even entire scripts in real time based on the available context. The generated SQL is similar to how you would write your statements, matching your style and naming conventions.

With cloud-based code completion, DataGrip shows suggestions in the editor as you type, and you can also invoke them by pressing Alt+Shift+\. To disable this feature, go to Settings | Editor | General | Inline Completion, and then deselect the Enable cloud completion suggestions checkbox.

To use the cloud-based code completion feature, you need to have the AI Assistant plugin installed in your IDE. Once the plugin is installed, the feature is enabled by default.

[PostgreSQL, Microsoft SQL Server] Introspection by levels

Introspection by levels is now available for the PostgreSQL and Microsoft SQL Server databases. DataGrip now automatically adjusts the amount of loaded metadata for these databases based on your database size. This means that for a larger database, you don’t have to wait till all the metadata is loaded to start working with it.

For more information about introspection by levels, refer to the Introspection levels topic.

[PostgreSQL] Smart refresh

DataGrip now supports the smart refresh mechanism for PostgreSQL databases. With this mechanism, the IDE analyzes which objects could be potentially modified by the query and refreshes only that specific set of objects.

For more information about introspection, refer to the Metadata and introspection topic.

[SQLite] WSL database file path

DataGrip supports WSL file paths for SQLite database files. You can now access your SQLite database in WSL and work with it without the database file being locked for you. To do this, in the Ctrl+Alt+Shift+S, use the following file path format: \\wsl$\<os>\home\<username>\<database_file_name>.sqlite. For example, \\wsl.localhost\Ubuntu-24.04\home\alexey\identifier.sqlite.

For more information about configuring an SQLite data source, refer to the SQLite topic.

[MongoDB] Support of the Read preference and Replica set connectivity settings

You can now set the way read operations are routed to the members of a MongoDB replica set, and also define the replica set to be used. To do this, enable the corresponding option in the Ctrl+Alt+Shift+S under More Options when configuring the connection to your MongoDB database. Once you select either of them from the list, a new field appears for you to specify the setting. To specify read preference, select the one you need in the Read preference field. To define your replica set, type its name in the Replica set field.

For more information about configuring a MongoDB data source, refer to the MongoDB topic.

Editable multi-table JOIN results

Previously, the result set grid for the SELECT queries with JOIN clauses was read-only. Now, you can run such queries, view the result set, and then edit cell values in the query results grid. To do this, double-click the cell or select it and press Enter. Also, same as in any other grid, you can right-click the cell and select Open in Value Editor to edit the value in a separate pane.

Data editor allows you to edit the values both in the in-editor results and in the Services tool window tab. Once you edit a cell value, the following buttons become active on the Services tool window results tab toolbar: Revert Selected, Preview Pending Changes, Submit.

In the in-editor results pane, an additional toolbar with the buttons appears at the bottom.

When you submit your changes to the database, DataGrip displays the DML Preview dialog for you to check the generated statements first. To edit your changes, click Cancel and proceed with editing. To submit the changes, click Submit.

This feature is not supported for the SQL UNION operator, table self-join operation results, result sets with calculation result columns (for example, CONCAT), or NoSQL databases. To ensure proper results, the feature also requires a way to uniquely identify rows.

Grid heatmap

Data editor now supports a grid heatmap with two color-scheme options: Diverging and Sequential. To enable the heatmap for your grid, click Table Coloring Options on the toolbar and select one of the schemes.

• The Diverging color scheme emphasizes variation relative to a norm. It consists of two contrasting colors that deviate from a central value in two opposite directions.

  

• The Sequential color scheme consists of a single color or a range of closely related colors that vary in intensity.

  

You can apply the heatmap color schemes to the whole table or to each column separately, or you can use coloring only for Boolean values.

One action for clearing all local filters in a grid

Now, you can clear the local filter for all columns in your grid using one action. To do this, invoke the Find Action popup by pressing Ctrl+Shift+A, start typing Clear Local Filter For All Columns, then select the action from the list.

For more information about local filters, refer to the Filter data topic.

Floating toolbar

DataGrip now displays a set of context-based and AI-driven actions available for a piece of code. Select any code in your code editor to make the toolbar appear.

To customize the floating toolbar, use the kebab menu (three vertical dots). To hide it, you can either use the same menu or go to Settings | Advanced Settings | Editor and check the Hide floating toolbar for code editing option.

For more information about floating toolbar, refer to Floating toolbar.

Cancel Running statements button in the gutter

For a running statement, the progress icon in the gutter now transforms into the Cancel Running Statement button on mouse hover.

For more information about running statements, refer to the Run queries topic.

Data sources attachment to files

• Previously, the data sources attached to SQL files were detached after the IDE restart. Now, the attachment persists.

  

• The Files tool window tool window now displays the attached data source name near the SQL file name in the file tree.

  

For more information about attaching data sources to SQL files, refer to the Run SQL files topic.

Quick access to SQL code style settings

The code reformat popup message now includes a link to the SQL code style settings page in the IDE Settings dialog.