DataGrip 2026.2: What's New in AI, CLI, and Data Source Management

The release of DataGrip 2026.2 marks a milestone in the evolution of integrated database development environments, with a renewed focus on artificial intelligence, workflow automation, and efficient data source management. This article takes an in-depth look at the most relevant developments, contextualizing them within the current needs of companies looking to optimize their operations with AI for business and cutting-edge tools.

AI agents and intelligent assistantsOne of the most disruptive additions is the inclusion of specific skills for AI agents within the IDE. Teams can now delegate tasks such as exploring schemas, generating SQL queries from natural language, and configuring connections. These AI agents act as contextual assistants that reduce friction between data analysis and technical action. For organizations developing artificial intelligence for enterprises, this functionality represents a step toward democratizing database access, allowing less technical profiles to interact with information without completely relying on the IT team.

In addition, agents now request confirmation before executing destructive operations, displaying the SQL highlighted with syntax for clarity. This additional control is vital in environments where cybersecurity and data integrity are a priority. The integration of MCP (Model Context Protocol) tools eliminates the need for additional configurations, making the experience seamless and secure.

Data Source Management from the Command LineDataGrip 2026.2 introduces CLI commands to manage connections and controllers, a feature that is in high demand by system administrators and developers working with automation pipelines. The batch processing approach allows you to pass a JSON file with multiple instructions, speeding up repetitive tasks such as setting up development environments or migrating databases. This capability aligns with modern infrastructure-as-code practices, where AWS and Azure cloud services play a central role.

Improved Connectivity and Session ModesThe new version offers three session control modes: single shared session, two sessions (one for introspection and one for everything else), and dedicated sessions. This flexibility allows you to adapt the use of connections to different scenarios, from collaborative development environments to intensive analytics. In addition, the inclusion of packaged JDBC drivers (Microsoft SQL Server, MongoDB, MySQL, PostgreSQL, Redis) speeds up initial setup, a detail that will be appreciated by those who manage multiple custom applications with different databases.

Editing Data with SQL ExpressionsThe Data Editor now allows you to assign values to cells using SQL expressions instead of literal values. For example, use NOW() to insert the current date. This feature simplifies maintenance and upgrade tasks, especially in custom software projects where data accuracy is critical. It also makes it easy to insert hex values without having to resort to complex SQL commands.

Redesigned Database ExplorerThe Database Explorer window has been revamped with a more intuitive empty state, a redesigned color system that works on both light and dark themes, and the ability to group objects by prefixes (using delimiters such as underscores or dollar signs). This organization improves navigation in large schemas, which is common in enterprise environments that handle hundreds of tables. The color settings have been moved to the main Settings dialog, making customization easier.

Expanded support for ClickHouse and SnowflakeDataGrip 2026.2 strengthens its support for analytic databases such as ClickHouse and Snowflake, adding new statements, hash functions, and role syntax. For teams working with business intelligence services such as Power BI, this enhancement enables more direct and efficient integration, reducing data preparation time and streamlining queries.

Conclusions and added value for professionalsThis update consolidates DataGrip as an indispensable tool for modern database development. The combination of AI agents, enhanced CLI, flexible session modes, and advanced data editing enables enterprises to reduce operational costs and accelerate value delivery. At Q2BSTUDIO, we understand that technology must be adapted to the needs of each business; That's why we offer custom application services, custom software, and AWS and Azure cloud services, complementing tools like DataGrip to build robust ecosystems. If your organization is exploring AI for business or needs to integrate power bi with your databases, our team can help you design solutions that maximize ROI.