dbForge Studio for SQL Server v2025.1 release notes

dbForge 2025.1 is a major release focused on enhancing productivity and the quality of code produced using the Studio. This update brings the integrated dbForge AI Assistant, refreshed UI/UX, an expanded T-SQL Analyzer rule set, and new connectivity for Azure Synapse Analytics (dedicated and serverless SQL pools).

What’s new

dbForge AI Assistant

With this release, we introduce a built-in AI assistant to improve your coding experience — helping you work faster, write cleaner SQL, and stay in flow from draft to deploy, all without leaving the Studio.

Capabilities

  • Context-aware SQL generation — dbForge AI Assistant generates queries based on your schema metadata after you attach a database.

  • Conversion of natural language to SQL — The Assistant converts plain-text prompts into SQL statements (with or without schema context).

  • Query optimization — AI suggests performance improvements (better join strategies, predicate tuning, index usage, etc.).

  • SQL explanations — You can ask dbForge AI Assistant to explain SQL statements and clauses and receive instant, plain-language explanations.

  • SQL troubleshooting — The Assistant quickly identifies syntax and dialect issues and suggests fixes.

  • AI Chat — Use AI Chat to ask about SQL, databases, and dbForge features without leaving the IDE.

UI/UX improvements

We refreshed visuals across the board so code stands out, errors are easier to spot, and getting to your next task takes fewer clicks.

  • We have updated Light/Dark palettes for higher contrast and better readability across editors, grids, and tool windows.

You can adjust the environment to your preferences in Tools > Options > Environment > Fonts and Colors.

  • We have also refined font rendering and the coloring of syntax errors to improve your experience and speed up issue detection.

  • And finally, on the Start Page, we have added Brief View to switch from the display of the full path to recent files to a more compact list.

Brief View

T-SQL Analyzer: expanded rule set

T-SQL Analyzer now includes more rules for flexible reviews across style, best practices, and performance.

You can configure the behavior of T-SQL Analyzer in Tools > Options > Code Analysis > Profiles.

T-SQL Analyzer

Connectivity support for Azure Synapse Analytics

We’ve added support for Azure Synapse Analytics — including both dedicated and serverless SQL pools — so you can connect, browse objects, write and run queries, and use editor features (formatting, code completion, analysis) directly in the IDE.