Database explorer<\/strong><\/h2>\n\n\n\nQuick filter<\/h3>\n\n\n\n
A long-awaited feature is finally here! Now, when using quick search, you also have the ability to filter objects. All non-matching objects will be hidden.<\/p>\n\n\n\n![\"\"](\"https:\/\/blog.jetbrains.com\/wp-content\/uploads\/2022\/10\/FilterExplorer.gif\")
<\/figure>\n\n\n\n<\/p>\n\n\n\n
Pattern-based schema filtering<\/h3>\n\n\n\n
If you have lots of different schemas, this is for you. It’s now possible to choose databases or schemas for introspection based on regular expression patterns. To do this, click on Add pattern <\/em>and define a regular expression pattern in the new node. The databases\/schemas will be chosen according to that pattern.<\/p>\n\n\n\n![\"\"](\"https:\/\/blog.jetbrains.com\/wp-content\/uploads\/2022\/10\/image-11.png\")
<\/figure>\n\n\n\nAdding multiple patterns will combine multiplicities, not create an intersection of them.<\/p>\n\n\n\n
The All<\/em> node now behaves differently from previous versions: It doesn’t select the default schema automatically. You now need to choose between All schemas<\/em>, default schema<\/em>, or applying a regexp filter.<\/p>\n\n\n\n<\/p>\n\n\n\n
Colors for global data sources<\/h3>\n\n\n\n
Now when you set the color for the global data source, it is shared along with its data source.<\/p>\n\n\n\n![\"\"](\"https:\/\/blog.jetbrains.com\/wp-content\/uploads\/2022\/10\/ColorsGlobal.png\")
<\/figure>\n\n\n\n<\/p>\n\n\n\n
Drag and drop for script files<\/h3>\n\n\n\n
To run the script against any schema, you can now just drag and drop your script file from the Files<\/em> tool window.<\/p>\n\n\n\n![\"\"](\"https:\/\/blog.jetbrains.com\/wp-content\/uploads\/2022\/10\/image.gif\")
<\/figure>\n\n\n\nData editor<\/strong><\/h2>\n\n\n\nFormats for date and time data types<\/h3>\n\n\n\n
It’s now possible to customize how fields of date and time types will be displayed in the data editor. The settings are located in Database | Data Editor and Viewer.<\/em><\/p>\n\n\n\n![\"\"\/](\"https:\/\/blog.jetbrains.com\/wp-content\/uploads\/2025\/09\/Q-YEUo93Lx3rri6P2dVXzHF9OiiFZmo0DpeVCtgFWv1gP8l1eWaGug85F8WH2pIiQYLXkTo5tEt3fF2PP6bmloql5CbAY6mQXkxbE6_i2giLLcW5rPErV_DJts_FC9buD68TmSrjytp5LAImPppRBUCtQPAtRsYG0aHDbsvmZ_AGKjJgGJb6SHF9Rw.png\")
<\/figure>\n\n\n\nThis is now available for three types of fields: Datetime\/timestamp<\/em>, Time,<\/em> and Date. <\/em>We are going to add support for Zoned time<\/em> and Zoned timestamp<\/em> types, as well.<\/p>\n\n\n\n![\"\"](\"https:\/\/blog.jetbrains.com\/wp-content\/uploads\/2022\/10\/image-13.png\")
<\/figure>\n\n\n\n<\/p>\n\n\n\n
New extractor: WHERE clause<\/h3>\n\n\n\n
A selected range of values can be now extracted as part of the WHERE clause:<\/p>\n\n\n\n
\n- Values within one column are combined with the OR operator.<\/li>\n\n\n\n
- Values within one row are combined with the AND operator.<\/li>\n\n\n\n
- If values of only one column are extracted, they are combined into an IN operator.<\/li>\n<\/ul>\n\n\n\n
<\/p>\n\n\n\n![\"\"](\"https:\/\/blog.jetbrains.com\/wp-content\/uploads\/2022\/10\/image-1.gif\")
<\/figure>\n\n\n\n<\/p>\n\n\n\n
SQL filtering by multiple values<\/h3>\n\n\n\n
The Filter by<\/em> action now generates a condition if you select several values.<\/p>\n\n\n\n![\"\"](\"https:\/\/blog.jetbrains.com\/wp-content\/uploads\/2022\/10\/FilterMultiple.gif\")
<\/figure>\n\n\n\n<\/p>\n\n\n\n
Text search field: populate with selection<\/h3>\n\n\n\n
If you press Ctrl\/Cmd+F<\/em> for text search, the search fields will be automatically populated with the value under the cursor. This is similar to the well-known logic of the text editor.<\/p>\n\n\n\n![\"\"](\"https:\/\/blog.jetbrains.com\/wp-content\/uploads\/2022\/10\/image-2.gif\")
<\/figure>\n\n\n\n<\/p>\n\n\n\n
[Big Query] Struct values are displayed correctly<\/h3>\n\n\n\n
Struct values are now displayed in a readable way: Each nested value is displayed as a separate column.<\/p>\n\n\n\n![\"\"](\"https:\/\/blog.jetbrains.com\/wp-content\/uploads\/2022\/10\/image-14.png\")
<\/figure>\n\n\n\n<\/p>\n\n\n\n
Working with code<\/strong><\/h2>\n\n\n\nIntention action preview<\/h3>\n\n\n\n
Now you can instantly see how your query will be altered once you apply the IDE\u2019s suggestions. The preview appears when you open the list of available intention actions and hover over an option. You can disable the preview feature by pressing F1\/ Ctrl+Q<\/em> while the list of intention actions is open.<\/p>\n\n\n\n![\"\"](\"https:\/\/blog.jetbrains.com\/wp-content\/uploads\/2022\/10\/image-3.gif\")
<\/figure>\n\n\n\n<\/p>\n\n\n\n
Single line copy-paste<\/h3>\n\n\n\n
If there is no selection, pressing Ctrl\/Cmd+C<\/em> automatically selects and copies the entire line. It worked like this before, but now we have completed the entire flow of the single line copy-paste. This copied line will be pasted as a new line with carriage return if there is no selection, as shown in this video:<\/p>\n\n\n\n![\"\"](\"https:\/\/blog.jetbrains.com\/wp-content\/uploads\/2022\/10\/image-4.gif\")
<\/figure>\n\n\n\nWorking with tables<\/strong><\/h2>\n\n\n\nMultiple edit in the Modify<\/em> window<\/h3>\n\n\n\nOur new Modify Table<\/em> dialog lets you edit several objects at a time! You can set the type for several columns or rename multiple columns at once with the numeric sequence.<\/p>\n\n\n\n![\"\"](\"https:\/\/blog.jetbrains.com\/wp-content\/uploads\/2022\/10\/image-5.gif\")
<\/figure>\n\n\n\n<\/p>\n\n\n\n
[MySQL, PostgreSQL] Table size in quick documentation<\/h3>\n\n\n\n
The size of the table is now displayed in the quick documentation popup for MySQL and PostgreSQL. To see it, click on Show table preview<\/em>.<\/p>\n\n\n\n![\"\"](\"https:\/\/blog.jetbrains.com\/wp-content\/uploads\/2022\/10\/image-15.png\")
<\/figure>\n\n\n\nOther<\/strong><\/h2>\n\n\n\nNew UI available via settings<\/h3>\n\n\n\n
In May, we announced a closed preview program for the new UI for IntelliJ-based IDEs. DataGrip is no exception!<\/p>\n\n\n\n
With this first step, we aimed to introduce the reworked look and feel of our products to a limited number of users. The preview program helped us accumulate and process a lot of insightful feedback, and now we\u2019re ready to invite everyone to try out the new UI.<\/p>\n\n\n\n
You can switch to the new UI in Settings \/ Preferences | Appearance & Behavior | New UI Preview<\/em>, take it for a test drive, and share your thoughts with us.<\/p>\n\n\n\n![\"\"\/](\"https:\/\/blog.jetbrains.com\/wp-content\/uploads\/2025\/09\/SJ_Y-Xj4DP9lntxfZ2gINCpvxOE_ZdHC9UsGT_sj4EHc-ULumMBNlT6ShnDzjUgn_K0ot4W6kayc6lPlUqi5bEO4ukZzeCbXcuz50bTaWI7oIrVM9y2AP4j1FHVX_F-O_PhFLqR9yNfYWBq2dxn_yGN7SusXezv80Q3pI8tgipyuN8vwShQD5KMBDg.png\")
<\/figure>\n\n\n\nWe are still in the process of making the new UI more useful for DataGrip. For instance, creating a Run Configuration, which is crucial for other IDEs, may not be the number one action to use a bright blue button for. If you have any ideas about customizing the top toolbar, please share them with us.<\/p>\n\n\n\n
<\/p>\n\n\n\n
Navigation in diagrams<\/h3>\n\n\n\n
Diagram elements are now fully navigable. All major navigation actions can be performed there:<\/p>\n\n\n\n
\n- Open DDL:<\/strong> Ctrl\/Cmd+B<\/li>\n\n\n\n
- Open data:<\/strong> F4<\/li>\n\n\n\n
- Select in the database explorer:<\/strong> Alt\/Opt+Shift+B<\/li>\n\n\n\n
- Modify<\/strong>: Cmd\/Ctrl+F6<\/li>\n<\/ul>\n\n\n\n
![\"\"\/](\"https:\/\/blog.jetbrains.com\/wp-content\/uploads\/2025\/09\/7FrERAzxmG6OSqh5X4bigJz8ehmYs7mxWnl4Cfni6aWYpbV2yOf0qskG4qgPLBJsQlHqGDsSZfK2H55kA-VHHj9SeStMFvKIgw_30caUPFEMgwCDVkOOVgk1gpB9wDUIEkfva0ETY_wBd8JpkXBIP8fVGPIRA3tUV3nYOm8n6WZJD-RuBG22_DiABw.png\")
<\/figure>\n\n\n\n<\/p>\n\n\n\n
[MongoDB] Authentication options<\/h3>\n\n\n\n
We added many authentication mechanisms to the connection dialog for MongoDB. To use them, update your driver to version 1.16.<\/p>\n\n\n\n![\"\"](\"https:\/\/blog.jetbrains.com\/wp-content\/uploads\/2022\/10\/image-18.png\")
<\/figure>\n\n\n\nImportant fixes<\/strong><\/h2>\n\n\n\n\n- DBE-16117<\/a>: Edit as Table<\/em> works correctly for CSV with values starting from a single quote.<\/li>\n\n\n\n
- DBE-16203<\/a>: [Big Query] Introspection works if the port is not specified in the URL.<\/li>\n\n\n\n
- DBE-15784<\/a>: The data editor tabs no longer steal focus.<\/li>\n\n\n\n
- DBE-13987<\/a>: The All related rows<\/em> option has been returned to navigation.<\/li>\n\n\n\n
- DBE-6156<\/a>: [Oracle] SET ROW is now supported.<\/li>\n\n\n\n
- DBE-12766<\/a>: [SQL Server] $PARTITION is now supported.<\/li>\n\n\n\n
- IDEA-264269<\/a>: Search Everywhere<\/em> results don’t jump when more options are found.<\/li>\n<\/ul>\n","protected":false},"author":395,"featured_media":286953,"comment_status":"closed","ping_status":"closed","template":"","categories":[826,89],"tags":[],"cross-post-tag":[],"acf":[],"_links":{"self":[{"href":"https:\/\/blog.jetbrains.com\/zh-hans\/wp-json\/wp\/v2\/datagrip\/286633"}],"collection":[{"href":"https:\/\/blog.jetbrains.com\/zh-hans\/wp-json\/wp\/v2\/datagrip"}],"about":[{"href":"https:\/\/blog.jetbrains.com\/zh-hans\/wp-json\/wp\/v2\/types\/datagrip"}],"author":[{"embeddable":true,"href":"https:\/\/blog.jetbrains.com\/zh-hans\/wp-json\/wp\/v2\/users\/395"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.jetbrains.com\/zh-hans\/wp-json\/wp\/v2\/comments?post=286633"}],"version-history":[{"count":9,"href":"https:\/\/blog.jetbrains.com\/zh-hans\/wp-json\/wp\/v2\/datagrip\/286633\/revisions"}],"predecessor-version":[{"id":628832,"href":"https:\/\/blog.jetbrains.com\/zh-hans\/wp-json\/wp\/v2\/datagrip\/286633\/revisions\/628832"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.jetbrains.com\/zh-hans\/wp-json\/wp\/v2\/media\/286953"}],"wp:attachment":[{"href":"https:\/\/blog.jetbrains.com\/zh-hans\/wp-json\/wp\/v2\/media?parent=286633"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.jetbrains.com\/zh-hans\/wp-json\/wp\/v2\/categories?post=286633"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.jetbrains.com\/zh-hans\/wp-json\/wp\/v2\/tags?post=286633"},{"taxonomy":"cross-post-tag","embeddable":true,"href":"https:\/\/blog.jetbrains.com\/zh-hans\/wp-json\/wp\/v2\/cross-post-tag?post=286633"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
<\/figure>\n\n\n\n<\/p>\n\n\n\n
Pattern-based schema filtering<\/h3>\n\n\n\n
If you have lots of different schemas, this is for you. It’s now possible to choose databases or schemas for introspection based on regular expression patterns. To do this, click on Add pattern <\/em>and define a regular expression pattern in the new node. The databases\/schemas will be chosen according to that pattern.<\/p>\n\n\n\n Adding multiple patterns will combine multiplicities, not create an intersection of them.<\/p>\n\n\n\n The All<\/em> node now behaves differently from previous versions: It doesn’t select the default schema automatically. You now need to choose between All schemas<\/em>, default schema<\/em>, or applying a regexp filter.<\/p>\n\n\n\n <\/p>\n\n\n\n Now when you set the color for the global data source, it is shared along with its data source.<\/p>\n\n\n\n <\/p>\n\n\n\n To run the script against any schema, you can now just drag and drop your script file from the Files<\/em> tool window.<\/p>\n\n\n\n It’s now possible to customize how fields of date and time types will be displayed in the data editor. The settings are located in Database | Data Editor and Viewer.<\/em><\/p>\n\n\n\n This is now available for three types of fields: Datetime\/timestamp<\/em>, Time,<\/em> and Date. <\/em>We are going to add support for Zoned time<\/em> and Zoned timestamp<\/em> types, as well.<\/p>\n\n\n\n <\/p>\n\n\n\n A selected range of values can be now extracted as part of the WHERE clause:<\/p>\n\n\n\n <\/p>\n\n\n\n <\/p>\n\n\n\n The Filter by<\/em> action now generates a condition if you select several values.<\/p>\n\n\n\n <\/p>\n\n\n\n If you press Ctrl\/Cmd+F<\/em> for text search, the search fields will be automatically populated with the value under the cursor. This is similar to the well-known logic of the text editor.<\/p>\n\n\n\n <\/p>\n\n\n\n Struct values are now displayed in a readable way: Each nested value is displayed as a separate column.<\/p>\n\n\n\n <\/p>\n\n\n\n Now you can instantly see how your query will be altered once you apply the IDE\u2019s suggestions. The preview appears when you open the list of available intention actions and hover over an option. You can disable the preview feature by pressing F1\/ Ctrl+Q<\/em> while the list of intention actions is open.<\/p>\n\n\n\n <\/p>\n\n\n\n If there is no selection, pressing Ctrl\/Cmd+C<\/em> automatically selects and copies the entire line. It worked like this before, but now we have completed the entire flow of the single line copy-paste. This copied line will be pasted as a new line with carriage return if there is no selection, as shown in this video:<\/p>\n\n\n\n Our new Modify Table<\/em> dialog lets you edit several objects at a time! You can set the type for several columns or rename multiple columns at once with the numeric sequence.<\/p>\n\n\n\n <\/p>\n\n\n\n The size of the table is now displayed in the quick documentation popup for MySQL and PostgreSQL. To see it, click on Show table preview<\/em>.<\/p>\n\n\n\n In May, we announced a closed preview program for the new UI for IntelliJ-based IDEs. DataGrip is no exception!<\/p>\n\n\n\n With this first step, we aimed to introduce the reworked look and feel of our products to a limited number of users. The preview program helped us accumulate and process a lot of insightful feedback, and now we\u2019re ready to invite everyone to try out the new UI.<\/p>\n\n\n\n You can switch to the new UI in Settings \/ Preferences | Appearance & Behavior | New UI Preview<\/em>, take it for a test drive, and share your thoughts with us.<\/p>\n\n\n\n We are still in the process of making the new UI more useful for DataGrip. For instance, creating a Run Configuration, which is crucial for other IDEs, may not be the number one action to use a bright blue button for. If you have any ideas about customizing the top toolbar, please share them with us.<\/p>\n\n\n\n <\/p>\n\n\n\n Diagram elements are now fully navigable. All major navigation actions can be performed there:<\/p>\n\n\n\n <\/p>\n\n\n\n We added many authentication mechanisms to the connection dialog for MongoDB. To use them, update your driver to version 1.16.<\/p>\n\n\n\n<\/figure>\n\n\n\nColors for global data sources<\/h3>\n\n\n\n
<\/figure>\n\n\n\nDrag and drop for script files<\/h3>\n\n\n\n
<\/figure>\n\n\n\nData editor<\/strong><\/h2>\n\n\n\n
Formats for date and time data types<\/h3>\n\n\n\n
<\/figure>\n\n\n\n<\/figure>\n\n\n\nNew extractor: WHERE clause<\/h3>\n\n\n\n
\n
<\/figure>\n\n\n\nSQL filtering by multiple values<\/h3>\n\n\n\n
<\/figure>\n\n\n\nText search field: populate with selection<\/h3>\n\n\n\n
<\/figure>\n\n\n\n[Big Query] Struct values are displayed correctly<\/h3>\n\n\n\n
<\/figure>\n\n\n\nWorking with code<\/strong><\/h2>\n\n\n\n
Intention action preview<\/h3>\n\n\n\n
<\/figure>\n\n\n\nSingle line copy-paste<\/h3>\n\n\n\n
<\/figure>\n\n\n\nWorking with tables<\/strong><\/h2>\n\n\n\n
Multiple edit in the Modify<\/em> window<\/h3>\n\n\n\n
<\/figure>\n\n\n\n[MySQL, PostgreSQL] Table size in quick documentation<\/h3>\n\n\n\n
<\/figure>\n\n\n\nOther<\/strong><\/h2>\n\n\n\n
New UI available via settings<\/h3>\n\n\n\n
<\/figure>\n\n\n\nNavigation in diagrams<\/h3>\n\n\n\n
\n
<\/figure>\n\n\n\n[MongoDB] Authentication options<\/h3>\n\n\n\n
<\/figure>\n\n\n\nImportant fixes<\/strong><\/h2>\n\n\n\n
\n