Devart adds AI SQL upgrades and new PostgreSQL tools in dbForge 2026.1

By AI, Created 8:25 AM UTC, May 21, 2026, /AGP/ – Devart has released dbForge 2026.1 with stronger AI-powered SQL generation, new PostgreSQL visual query building and table editing tools, and expanded schema comparison features. The update is available now across the dbForge ecosystem for active subscribers and trial users.

Why it matters: - dbForge 2026.1 is aimed at making database work faster and less error-prone for developers, analysts, DBAs and BI teams. - The release combines AI-assisted SQL work with visual PostgreSQL design tools, which can reduce manual scripting and improve day-to-day database operations. - Expanded schema comparison and synchronization support can make PostgreSQL and Amazon Redshift deployment and migration work more flexible.

What happened: - Devart announced dbForge 2026.1, a major update to its AI-powered database development products. - The release adds improved AI SQL generation and optimization across supported database systems. - dbForge Studio for PostgreSQL now includes a visual Query Builder for SELECT, INSERT, UPDATE, DELETE and JOIN queries. - dbForge 2026.1 is available today for dbForge Edge, dbForge Studio for SQL Server, dbForge Studio for PostgreSQL, dbForge Studio for MySQL, dbForge Studio for Oracle and other dbForge products. - Customers with active subscriptions can get the update immediately. - New users can try the latest features through a free trial on Devart’s website.

The details: - dbForge AI Assistant now uses detailed database index metadata to improve SQL generation and optimization. - The metadata includes clustered, no clustered, composite, unique and B-tree indexes. - The AI Assistant supports natural language to SQL conversion, context-aware SQL generation, optimization of pre-written SQL, redundant or missing index detection, SQL explanations, error analysis, troubleshooting and integrated AI chat. - PostgreSQL development updates also include an enhanced SQL Editor, syntax highlighting for code blocks enclosed in dollar quotes, index name suggestions, document tab improvements and new workflow options. - The new visual Table Editor for PostgreSQL supports column management, primary and foreign keys, unique constraints, indexes and other table properties without manual SQL. - Pinned document tabs help users keep frequent SQL scripts, schema files and queries within reach during multi-tab sessions. - Schema comparison and synchronization now include broader support for PostgreSQL and related servers, new options, fuller schema and table mapping, and comparison and synchronization of indexes on tables and materialized views. - The release also extends PostgreSQL development capabilities across dbForge Studio for PostgreSQL and dbForge Edge. - Devart says the update helps teams simplify SQL development while maintaining stronger query performance and optimization standards. - More information is available in Devart’s release note.

Between the lines: - Devart is positioning dbForge as a unified environment for both AI-assisted SQL work and visual database design. - The product mix suggests a push to reduce friction for teams that want fewer separate tools for query building, schema work and administration. - The emphasis on index metadata signals a broader trend in AI database tools: better results depend on deeper awareness of the underlying schema and performance structure.

What’s next: - Devart will likely use the new release to draw more users into the dbForge ecosystem through trials and subscription upgrades. - PostgreSQL teams may see the biggest near-term impact from the visual query builder, table editor and schema synchronization improvements. - Active customers can adopt the update immediately, while new users can evaluate the features before committing.