dbForge 2025.3: AI Assistant in SQL Complete, Expanded Connectivity, and Smarter SQL Workflows

in #sqlyesterday

Do you ever feel like SQL development is a juggling act? One minute you’re in SQL Server, the next in Oracle or MySQL, trying to track queries, optimize execution plans, and make sense of complex schema logic. Sounds familiar? You’re not alone—and now, there’s a smarter way to work.

dbForge 2025.3 brings the world's most advanced SQL-focused AI right into SSMS expands connectivity for the latest Oracle and MySQL versions, offers integration with SSMS 22 and Visual Studio 2026, and delivers improvements across database diagrams, PostgreSQL-specific syntax support, and query profiling.

This release is part of the official dbForge 2025.3 rollout across the entire product ecosystem, bringing productivity-focused updates, UI/UX improvements, and enhanced connectivity for SQL Server, MySQL, Oracle, and PostgreSQL users.

dbForge AI Assistant Now Available in SQL Complete

The AI Assistant is now integrated directly into SQL Server Management Studio — no extra tools, no switching between environments.
It understands your schemas, optimizes queries, generates SQL code from natural language, and explains even the most complex SQL logic clearly and easily.
Result: 30–50% faster development thanks to schema-aware AI working inside your native workflow.

This marks the first time dbForge AI Assistant has been integrated into an SSMS add-in, bringing the conversion of natural language to SQL, query optimization, and in-context explanations directly into SQL Complete.

Support for Oracle 26ai

Added full compatibility with the newest Oracle release.
After upgrading your database, all tooling remains fully accessible—schema work, querying, and admin tasks continue without disruption.
Result: Zero downtime for teams adopting Oracle’s latest AI-enhanced features.

Support for MySQL 9.5 & MariaDB 12.2

Full connectivity with the latest MySQL and MariaDB versions—without workflow gaps after upgrades.
Result: Uninterrupted development, profiling, and administration on cutting-edge deployments.

Integration With SSMS 22 and Visual Studio 2026

SQL Complete now works seamlessly with Microsoft’s newest versions.
Result: Autocompletion, formatting, refactoring, and AI assistance are available on day one—no waiting for compatibility patches.

Database Diagram Improvements

Added object search directly inside database diagrams.
Result: Instant navigation across large ER diagrams, eliminating endless scrolling and speeding up design reviews.

PostgreSQL-Specific Enhancements

Expanded support for modern PostgreSQL syntax, including:
WITH MATERIALIZED, MERGE, cursors, WITH TIES, procedural elements, and more.
Result: Fewer parsing issues, smarter autocompletion, cleaner formatting, and faster, more reliable development.

Visual EXPLAIN Tree for MySQL
Query Profiler now visualizes EXPLAIN plans as an intuitive tree diagram.
Result: Immediate insight into join order, nested loops, and expensive operations—making query optimization faster and clearer.

Alongside AI-driven workflows, dbForge 2025.3 also expands support for newly released database versions, introduces additional PostgreSQL and Oracle syntax constructs, and delivers UI/UX improvements requested by the community.

Why This Matters

Whether you’re switching between SQL Server, Oracle, MySQL, MariaDB, or PostgreSQL, dbForge 2025.3 keeps you in flow. The AI Assistant acts as an invisible teammate—spotting errors, explaining logic, and helping you move faster across platforms.

Fewer mistakes. Smarter queries. Faster results.

More details, screenshots, and practical tips:
https://blog.devart.com/whats-new-in-dbforge-2025-3-enhanced-connectivity-updated-ui-ux-newly-supported-syntax-constructs-and-much-more.html

The update is live — check it via Help → Check for Updates inside dbForge tools.

New to dbForge? Start with a free trial and explore the full ecosystem: https://www.devart.com/dbforge/

Already using dbForge? Update now and explore what’s new in dbForge 2025.3 across your entire database stack.