6 days ago
Devart launches dbForge 2025.1 with AI assistant & new UI
Devart has unveiled dbForge 2025.1, presenting new features including an AI assistant, updated user interface, and expanded connectivity options across its database development tool suite.
The new dbForge 2025.1 update introduces the dbForge AI Assistant, offering support for database professionals working with SQL Server, MySQL, Oracle, and PostgreSQL. With this release, Devart aims to address the evolving needs of those developing, managing, and optimising databases.
dbForge AI Assistant is described as an AI-powered co-pilot designed to enhance SQL development. Its features include context-aware query generation, natural language conversion to SQL, query optimisation, and advanced troubleshooting for a broad spectrum of database engines. The new functionality seeks to allow users, regardless of their expertise, to interact with databases via natural language while maintaining precise output for complex queries.
Oleksii Honcharov, Head of Engineering at Devart, commented on the introduction of the AI Assistant and the wider scope of the update: dbForge 2025.1 isn't just another version, it's a grand step forward for our entire product line. We believe technology should work for you, and with our AI-powered assistant, working with data is a breeze. This means fewer bottlenecks, high-quality answers, and smarter decisions across the board.
The AI Assistant is available across the dbForge product family, providing users with several functionalities aimed at accelerating and simplifying SQL development. Amongst its capabilities, the assistant can: Generate context-aware SQL queries by analysing database metadata, without accessing actual data.
Convert plain language commands directly into syntactically correct SQL queries, making database access more inclusive for non-experts or those seeking code-free interaction.
Optimise existing SQL code with performance suggestions designed for quicker and more efficient queries.
Offer explanations that deconstruct complex SQL statements into more comprehensible terms.
Troubleshoot problematic SQL queries, diagnosing issues and suggesting or implementing fixes.
Conduct error analysis with recommendations that account for the unique requirements and dialects of SQL Server, MySQL, MariaDB, Oracle, and PostgreSQL.
Support an interactive chat interface that provides conversational assistance for SQL, general database topics, and dbForge products, removing reliance on separate documentation.
The AI Assistant is fully integrated into all editions of dbForge products, including the free Express versions. New users receive a free 14-day trial period for the AI functions.
UI and UX upgrades
Enhancements to user interface and experience form another key aspect of dbForge 2025.1. The update features a redesigned interface that aims to be cleaner and more intuitive, improving navigation, panel management, and the discoverability of tools. These adjustments arise in response to feedback from users, with the goal of streamlining workflow and reducing potential friction within the application environment.
Expanded analysis and compatibility
Further improvements have been made to static code analysis capabilities in dbForge Studio for SQL Server and dbForge SQL Complete. The built-in T-SQL Analyzer receives an expanded set of rules, offering more customisation and deeper insight during code reviews.
Aligning with evolving cloud integration requirements, dbForge 2025.1 introduces support for dedicated and serverless SQL pools within Azure Synapse Analytics. This enhancement is intended to improve data integration and management workflows for teams who rely on Microsoft's analytics service.
Additionally, Devart has updated its support for PostgreSQL tools, which are now compatible with the recently released PostgreSQL 18. This ensures that users are able to leverage new database features as soon as they become available.
Product availability
dbForge 2025.1 is available for download or update across all core product lines, including dbForge Edge, the Studio series for SQL Server, MySQL, Oracle, and PostgreSQL, as well as dbForge SQL Complete and SQL Tools. Existing users can check for updates within their installed product, while new users may download and trial the full suite of dbForge tools.
