2026.1
AI
AI agents have been integrated into the AI chat.
The MCP server has been extended with database-specific capabilities.
Files created from a snippet have the SQL dialect and data source attached. Query files and consoles
The redesigned workflow allows you to use query files and query consoles - either separately or at the same time.
A new way to create a query file has been implemented.
In the database explorer, query files associated with a data source are displayed in the Query Files folder under the data source node.
The presentation of query files can now be tailored to your needs with the files' display settings. Connectivity
Data sources can now be saved as templates in your JetBrains Account.
You can create a new data source from a template in other IDEs with database functionality provided through your JetBrains Account.
PostgreSQL 18 is now supported.
The Data Sources and Drivers dialog has received a few improvements. Explain Plan
In the Services tool window, the query execution plan tab has been renamed to Query Plan and assigned a new icon.
A separate panel has been implemented on the right-hand side of the tab to display details of each plan row.
A quick documentation popup is displayed when you hover the cursor over a table name in the row details panel.
The Total Cost and Startup Cost flame graphs are now displayed in the sub-tabs located at the bottom of the Query Plan tab.
The query plan can now be copied in the database's native format using the Copy Original Query Plan button. Code editor
The Suppress for back label references option can now be toggled using intention actions.
A given chunk of code can now be executed using the Execute Selection as Single Statement context menu action for a code selection.
Two movement animation modes have been introduced for the editor caret. Working with data
JSON indexes are now supported for Microsoft SQL Server.
The Show Geo Viewer button has been moved to the data editor toolbar. Working with files
A new IDE setting has been added that defines whether a deleted file is moved to the bin or deleted permanently.