{"id":688400,"date":"2026-03-26T18:38:16","date_gmt":"2026-03-26T17:38:16","guid":{"rendered":"https:\/\/blog.jetbrains.com\/?post_type=datagrip&p=688400"},"modified":"2026-03-27T14:32:38","modified_gmt":"2026-03-27T13:32:38","slug":"datagrip-2026-1-redesigned-query-files-data-source-templates-in-your-jetbrains-account-ai-agents-in-the-ai-chat-explain-plan-flow-enhancements-and-more","status":"publish","type":"datagrip","link":"https:\/\/blog.jetbrains.com\/en\/datagrip\/2026\/03\/26\/datagrip-2026-1-redesigned-query-files-data-source-templates-in-your-jetbrains-account-ai-agents-in-the-ai-chat-explain-plan-flow-enhancements-and-more","title":{"rendered":"DataGrip 2026.1: AI Agents in the AI Chat, Redesigned Query Files, Data Source Templates in Your JetBrains Account, Explain Plan Flow Enhancements, and More!"},"content":{"rendered":"\n

DataGrip 2026.1, the first major update of the year, is here! Let\u2019s take a look at what\u2019s inside.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Download DataGrip 2026.1<\/a><\/p>\n\n\n\n

Query files and consoles<\/h2>\n\n\n\n

In this release, we are redesigning the flow for working with query files side by side with query consoles. This way, you can use either or both of them, depending on your tasks and workflow. We have implemented a new way to create a query file, allowing you to define the file name and location yourself. By default, the file is created in the current project directory and associated with the project.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Next, all query files attached to a data source are displayed under the Query Files<\/em> folder in the database explorer. This simplifies navigation and helps you focus on a data source\u2019s context. <\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Speaking of focusing and making the UI more informative, we have implemented several display settings located in the IDE Settings<\/em> dialog under Database <\/em>| Query Execution<\/em> | Query Files<\/em>. You can use these settings to make sure you have query file details shown right where you need them.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

AI<\/h2>\n\n\n\n

You can create a file from a code snippet suggested by AI Assistant when chatting with it in the AI Chat<\/em> tool window. Previously, the created file wouldn\u2019t have a data source attached or a SQL dialect defined. Now, if you provide any context about the database you\u2019re working with, DataGrip will attach the data source you mention and set the SQL dialect for the new file automatically. Also, when you ask AI Assistant questions about a SQL file that already has a data source attached, the IDE will attach that same data source to the newly created file.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

In addition, you can now work with AI agents in the AI Chat<\/em> tool window. Currently, DataGrip supports Claude Agent and Codex. So, if your task requires assistance from a certain agent, you can work with it right in the IDE.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Additionally, database-specific capabilities have been implemented for the MCP server. With this enhancement, built-in AI agents and third-party tools can work with databases in a more structured way. For example, executing and cancelling running SQL queries is possible now, as is obtaining connection configurations and testing them. Also, to ensure security, four levels of user consent for data and schema access are required by default.<\/p>\n\n\n\n

Connectivity<\/h2>\n\n\n\n

You can now reuse your data source settings by creating data source templates. The templates are stored in your JetBrains Account<\/a> and include settings from the General<\/em> and Advanced<\/em> tabs of the Data Source and Drivers<\/em> dialog, but exclude your database credentials. If you need to reuse some data source settings in another IDE in which you are signed in to your account, you can simply use a template. Just open the template list in the Data Source Templates<\/em> tab of the Data Sources and Drivers<\/em> dialog, select the one you need, and create a data source from it.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

We\u2019ve also added support for PostgreSQL 18, including OLD<\/code> and NEW<\/code> resolution in RETURNING<\/code> clauses, WITHOUT OVERLAPS<\/code> in primary and unique constraints, and other newly introduced keywords and commands.<\/p>\n\n\n\n

Finally, the General <\/em>tab of the Data Sources and Drivers<\/em> dialog has also received a few improvements. First, we\u2019ve turned the Data Sources<\/em>, Drivers<\/em>, and other sections into the main tabs that you can see on the left-hand side. Next, the Comment<\/em> field is hidden by default and only appears after you click Add Comment<\/em> and add one. The Driver<\/em> dropdown now informs you if a driver has not been downloaded, in which case a Download<\/em> button appears next to the dropdown. Also, the Connection type<\/em> options are displayed as tabs if fewer than three options are available. And finally, we have removed the Create DDL Mapping<\/em> button from this tab.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Explain Plan<\/em> UI and UX improvements<\/h2>\n\n\n\n

Now you have a more informative tab for working with query execution plans in the Services<\/em> tool window. The tab is now called Query Plan<\/em> and contains sub-tabs for the Total Cost<\/em> and Startup Cost<\/em> flame graphs.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

In the Operations Tree<\/em> tab with the plan, you can find detailed information for each row in a separate panel on the right-hand side of the tab. If there\u2019s a table name in one of the cells, quick documentation for the table is available in a popup.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Code editor<\/h2>\n\n\n\n

It is now easier to suppress the resolve inspection for back label references, as we have added it to the list of intention actions. You can now toggle this option under the Enable option \u201cSuppress for back label references\u201d<\/em> intention action. <\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Executing a chunk of code is easier now, too \u2013 even when DataGrip isn\u2019t parsing it properly. Just select the chunk, right-click it, and select Execute Selection as Single Statement<\/em>. <\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

The code editor has also been improved with new caret movement animation modes: Snappy<\/em> and Gliding<\/em>. We hope these modes improve your typing experience and make it more enjoyable. Our team developed the first mode, Snappy<\/em>, to account for how different animations might feel to different people. <\/p>\n\n\n\n