11.5.0.26718 - Released on 11 August 2026 (Standalone installer)

Features

• Added a button to open the Redgate Assistant window in SSMS toolbar.
• Added an option to open the Redgate Assistant window in SSMS query editor window context menu.
• Changed the model for AI autocompletion from Alibaba Cloud's Qwen3-Coder to Mistral AI's Devstral 2.
• The Redgate Assistant chat window will now automatically detect state changes without requiring to be closed and reopened.
• Turning on Prompt AI now also turns on Redgate Assistant if it is not already enabled.

• Added information on all the new AI features in SQL Prompt. Check it out in SQL Prompt > Help > What's new in SQL Prompt? menu option.

  Fixes

• Fixed an issue where SELECT statements in views containing Common Table Expressions (CTEs) were formatted incorrectly.
• Fixed an issue where users authenticated with Microsoft Entra MFA were repeatedly prompted for re-authentication on Visual Studio 2026
• Fixed an issue where Redgate Assistant chat shows up as a blank window if the user is logged out when opening SSMS.
• Fixed an issue that could incorrectly throw an ObjectDisposedException when Redgate Assistant's MCP server was stopped.
• Fixed an issue that caused an execution timeout when viewing the script of a database object in Azure Synapse.
• Fixed an issue where function call formatting was not getting applied to JSON_OBJECT and JSON_OBJECTAGG.
• Fixed an issue where JSON_OBJECT did not suggest the ABSENT ON NULL or NULL ON NULL clauses.
• Fixed an issue where renaming an alias in a CTE could result in mismatched references and invalid SQL.

• Redgate Assistant will now provide better and faster guidance if there are any issues retrieving the query execution plan (e.g. malformed T-SQL, database mismatches, etc.) for the current active query.