What’s New in dbForge 2026.1: Enhanced SQL Tools

This article was originally published by LOGON’s partner Devart. Click here to view the original article.

The time has come to announce the release of dbForge 2026.1, a grand update that brings new features and enhancements to the entire dbForge ecosystem—with a special focus on PostgreSQL and related databases.

Key Highlights

Database Index Context for dbForge AI Assistant

The integrated AI Assistant now has access to database index metadata, helping it generate and optimize context-aware queries with greater precision.

Index Types Covered	What It Enables
B-tree, clustered, composite, unique	More accurate AI-generated SQL queries

Key AI Assistant Capabilities:

Convert natural language to SQL
Generate context-aware queries
Optimize and troubleshoot pre-written SQL
Explain query syntax and errors
Built-in web search for up-to-date information

Enhanced SQL Editor

Feature	Benefit
Quick add/remove brackets, backticks, quotes	Faster formatting for SQL Server, MySQL, Oracle, PostgreSQL
Syntax highlighting in dollar-quoted blocks	Cleaner, more readable PostgreSQL code

Extended Code Completion

Database	New Index Name Suggestions
Oracle	ALTER INDEX, DROP INDEX, ANALYZE INDEX VALIDATE STRUCTURE
MySQL/MariaDB	ALTER TABLE, DROP INDEX, RENAME INDEX, FORCE/USE/IGNORE INDEX
PostgreSQL	ALTER INDEX, DROP INDEX CONCURRENTLY, REINDEX INDEX

Document Tab Improvements

Pin frequently used tabs
Tabs maintain order after application restart

Session Restore

Restore entire last session at startup
Configurable in Options > Environment > General

Major Update: dbForge Studio for PostgreSQL

Visual Query Builder

Build queries of any complexity on intuitive diagrams
No manual SQL coding required

Visual Database Design

View, create, and modify database objects graphically
Design and modify database schemas visually

Enhanced Schema Compare & Synchronization

New Options page for flexible configurations
Ignore: object owners, white spaces, comments, case, constraint names, data types, permissions, foreign keys
Associate column names with 80% similarity
New Schema and Table Mapping pages

Index Comparison & Synchronization

Compare indexes on tables and materialized views (PostgreSQL, Greenplum, ElephantSQL)
Covers uniqueness, method, columns, sort order, included columns, storage parameters, WHERE predicates, comments

IDENTITY Column Support

Full support for GENERATED { BY DEFAULT | ALWAYS } AS IDENTITY
Properly handled by syntax check, compare, sync, and data generation

Ready to try dbForge 2026.1?

LOGON Software Asia – the trusted Devart partner in Asia – offers:

✅ Free Proof of Concept (POC)
✅ Preferred pricing
✅ Priority support
✅ Local expertise

Devart

Your trusted ally in data management

Solution Highlight

Get Started with Devart

Streamline complex data tasks and increase productivity with our expert solutions

Blog, Devart Blog