SQL Prompt Pro Releases

Redgate SoftwareCode Editors
Version 11.x (Jul 1, 2026)(4)

Learn what's new across releases, with details of features, enhancements, and resolved issues.

Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
SQL Prompt Pro 11.4.0.25545Major versionJul 1, 2026
Features
  • Released a new AI preview feature, Redgate Assistant, a chat based AI interface within SQL Prompt that can be used to generate SQL, fix bugs, and more.
    • Redgate Assistant can be enabled in the SQL Prompt options, on the AI page, under the preview section.
    • It can be accessed through the SQL Prompt menu button, or through the keybind Alt-A.
    • Redgate Assistant is able to read the information inside your query editor window, database information (but not contents), and schema information.
    • Due to a change in the licensing system, users will be logged out and need to log back in to SQL Prompt to continue using the product after this update.
SQL Prompt Pro 11.3.18.25519Jun 30, 2026
Features
  • Several improvements to reduce synchronization issues between client and server side access (Prompt AI and Query Index Analysis).
  • Added support for grouping Tables by Schema in Object Explorer.
  • Added support for new OPENROWSET BULK options in SQL Server 2005, SQL Server 2017, Azure SQL and Microsoft Fabric.
Fixes
  • Prompt AI now asks the end user to log in when necessary instead of giving confusing generic error messages.
  • Fixed an issue where Prompt AI would fail to load in SSMS 21
  • Fixed an issue where JSON_OBJECTAGG did not format key-value pairs correctly.
  • Fixed an issue where SQL Prompt was unable to disable the built-in SSMS IntelliSense in SSMS 22.6 and later versions.
SQL Prompt Pro 11.3.17.25200Jun 16, 2026
Features
  • The SQL Prompt installer no longer ships a FormatCommandLine.zip as this added more than 10MB to the installer size and the SqlPrompt.Format.CommandLine.exe is already present in the SQL Prompt install folder.
Fixes
  • Fixed an issue where JSON datatype was not being converted to uppercase during formatting.
  • Fixed an issue where tab coloring was not applied correctly in the vertical tab layout.
  • Fixed an issue where renaming an alias in the script caused one of the alias columns to be missed.
  • Fixed an issue where JSON_OBJECT did not format key-value pairs correctly.
SQL Prompt Pro 11.3.16.24782Jun 3, 2026
Fixes
  • Fixed an issue in SSMS 22.6 that could cause an unexpected error dialog to appear when accessing the SQL Prompt Manage License screen.
SQL Prompt Pro 11.3.15.24535May 28, 2026
Features
  • Added Open Data Modeler Object Explorer context-menu option for the selected database to show Redgate Data Modeler in the default system browser (SSMS only).
Fixes
  • Fixed an issue where SQL Prompt did not show suggestions for ORDER and columns while creating ORDERED CLUSTERED COLUMNSTORES INDEX.
  • Fixed UI issues that caused some pages to become unreadable when the dark theme was enabled.
SQL Prompt Pro 11.3.14.24187May 18, 2026
Fixes
  • Fixed problem that could permanently prevent usage of Prompt AI by having an always disabled Check Prompt AI availability command in the SQL Prompt main menu.
  • Fixed an issue that caused suggestions to fail in SQL Prompt when string concatenation was used with TRIM.
  • Fixed an issue in SSMS 22.6 where opening the Manage License screen in SQL Prompt could display an unexpected error dialog.
SQL Prompt Pro 11.3.13.23933May 12, 2026
Features
  • Updated the SQL Prompt SSMS Check for Updates (CFU) flow to launch the SQL Toolbelt Essentials installer instead of the standalone SQL Prompt installer.
Fixes
  • Fixed an issue where SQL Prompt did not auto-fill the default NUMERIC values for a stored procedure.
  • Fixed an issue where SQL Prompt suggestions failed to load on read-only replicas in Availability Groups.
  • Fixed issue where SQL History could cause errors and SSMS freezes when disabled or enabled via the SQL Prompt options.
  • Fixed an issue where the COPY AS IN clause in the result grid returned duplicate values when multiple cell with identical values were selected using Ctrl+Click.
  • Fixed an issue where the SQL Prompt right‑click context menu failed to appear in the Registered Servers window in SSMS 21 and SSMS 22 after signing out of SQL Prompt.
  • Fixed issue that could cause the Prompt AI availability check to always fail in the same IDE session, even if AI access was subsequently restored (e.g. temporary network blip or server-side downtime). This removes the need to restart SSMS/VS to be able to re-use Prompt AI in those scenarios.
  • Fixed an issue where SQL Prompt Table definition tooltip suggestions failed to load System-Versioning scripts for Temporal tables.
SQL Prompt Pro 11.3.12.23605Apr 28, 2026
Features
  • SQL Prompt 11.3.10 and later are compatible with SSMS 22.5.
Fixes
  • Fixed incorrect issue highlighting for queries containing IS DISTINCT predicate.
  • Fixed SQLPrompt crash that occurred when applying changes from Copilot Chat.
  • Fixed An unexpected error occurred. Try again later or contact Redgate support if issue persists when gathering initial AI suggestions if SQL History was disabled.
  • Fixed an issue where SQL Prompt could freeze or hang SSMS and Visual Studio when switching tabs or opening files.
  • Fixed low-contrast SQL text in SQL History under dark mode, improving readability.
  • Fixed formatting issues for REGEXP and CURRENT_DATE when connected to Azure SQL Database.
SQL Prompt Pro 11.3.11.23448Apr 21, 2026
Features
  • Added link to the new Redgate AI trust & transparency hub in SQL Prompt AI options, which provides a live public portal showing how data is processed per Redgate product, who has access, and what policies govern AI usage.
  • Added suggestion support for functions - JSON_QUERY, JSON_ARRAYAGG and JSON_OBJECTAGG.
  • Added support for theme switching, aligned with SSMS 21 (modern preview themes) and SSMS 22.
  • Added support for Azure SQL Managed Instance.
Fixes
  • Fixed an issue where restored SQL History queries forget save path.
  • Fixed incorrect suggestions for BACKUP DATABASE, RESTORE DATABASE, and CREATE LOGIN in Azure SQL Managed Instance.
  • Fixed SQLCMD syntax query formatting issue while using COLLATE clause.
SQL Prompt Pro 11.3.10.22862Apr 3, 2026
Fixes
  • Fixed compatibility issues with SSMS 22.5.
SQL Prompt Pro 11.3.9.22706Mar 30, 2026
Fixes
  • Fixed Index was outside the bounds error when expanding stored procedures.
  • Fixed duplicate entries in the Registered Servers and Object Explorer context menus for Tab Color.
SQL Prompt Pro 11.3.8.22342Mar 19, 2026
Fixes
  • Fixed SQL Prompt not loading correctly on start up in SSMS 22.4.
SQL Prompt Pro 11.3.7.21945Mar 12, 2026
Features
  • Prompt AI requests now include the SQL Server version of the connected database alongside its schema.
    • This significantly increases the chance of the AI-generated T-SQL being fully compatible with the current version and not using newer language features.
  • The Prompt AI window now displays the SQL Server version of the connected database as a gray suffix after the database name.
  • Several improvements to the categorization and display of items in the SSMS/VS command palette.
Fixes
  • Fixed registration of Select Synonym in Object Explorer command in SSMS and command palette.
  • Fixed Exception has been thrown by the target of an invocation error that could be shown when saving SQL Prompt options while the SSMS registered servers tool window was active.
  • Fixed inconsistent formatting when Check constraint is used.
  • Fixed an issue where SQL Prompt did not insert a space before the NOT LIKE keyword when formatting SQL.
  • Fixed an issue where Registered Server tab colors were not displayed in SSMS 21 and 22.
  • Fixed display of friendly-name hyperlinks in SQL Prompt options interactive help dialogs (? buttons).
  • Fixed issue that could cause non-SQL errors (e.g. connection timeouts) to incorrectly trigger the Prompt AI fix suggestion popup dialog.
  • Fixed an issue where SQL Prompt menu was not shown on menu bar in SSMS 21 and SSMS 22 after installation/upgrade.
  • Prompt AI fix now respects GO batches and will no longer try to incorrectly remove them or flag them as syntax errors when executing SQL if the Show fix suggestions popup dialog option is enabled.
  • Prevent unnecessary AI requests when the SQL query editor window is not connected to a database or when its schema is empty.
  • Several tweaks to Prompt AI fix behavior to improve outcome (especially in cases where multiple syntax errors occur in the same T-SQL statement).
SQL Prompt Pro 11.3.6.21421Feb 13, 2026
Features
  • Added support for SQL Server 2025 database-scoped configuration preview features.
Fixes
  • Fixed an incompatibility between SQL Prompt and SSMS 22.3 which caused SSMS to consistently crash when SQL Prompt was installed.
  • Fixed an issue where aggregate totals were calculated incorrectly when using the German language/region settings.
  • Fixed an issue that caused code completion to fail for user‑defined stored procedures in Microsoft Fabric SQL Databases.
SQL Prompt Pro 11.3.5.21197Feb 5, 2026
Features
  • Two SQL Prompt suggestion-based opt-in experimental settings have been promoted to regular options and moved from the Labs > Experimental features options pane to the Suggestions > Behavior one:
    • Automatically refresh suggestions:
      • When this option is on, SQL Prompt automatically refreshes the suggestion list when a change to a connected database is detected (e.g. modification to its schema). This is equivalent to manually calling the Refresh Suggestions command (Ctrl+Shift+D).
    • Refresh Microsoft IntelliSense cache when refreshing suggestions (SSMS only):
      • By default, SSMS's IntelliSense functionality doesn't react to database objects created by another connection after your editor window has connected to the database (e.g. running a script that does CUD operations such as ALTER, CREATE or DROP). When this option is on, it will override this behavior when refreshing SQL Prompt suggestions (either manually or automatically with the previous option) to also automatically refresh the Microsoft IntelliSense cache (equivalent to calling Edit > IntelliSense > Refresh Local Cache in SSMS).
  • Opt-in setting to prevent Excel's rounding of numerical values with more than 15 digits when exporting SQL query results -- introduced as an experimental feature in version 10.14.12.11.347 -- has now been promoted to a regular option in the new Query Results options pane.
Fixes
  • Fixed issue where a GUI notification about SQL Prompt product usage could be shown incorrectly on SSMS/VS startup.
  • Fixed issue that could cause SQL Prompt to fail to load on startup if some of its configuration settings could not be read from disk.
SQL Prompt Pro 11.3.4.20814Jan 20, 2026
Features
  • Failure to retrieve the database schema no longer prevents AI requests from completing. They will instead be performed without schema-awareness.
    • If this happens, a warning will be displayed in the Prompt AI window to offer contextual information.
Fixes
  • Fixed issue where failure to perform an AI request (e.g. Explain SQL) could leave the work in progress spinner UI element visible and would not surface the problem in the Prompt AI window (other than a cryptic -- ERROR comment in the SQL editor window).
  • Fixed an issue where SQL Prompt repeatedly displayed error messages for unsupported authentication types.
  • Fixed an issue where clicking the 'Snippet Manager' caused a null reference error when on a non-query tab.
  • Fixed enablement and disablement of SQL Prompt suggestions and code analysis features in main menu and options in all Visual Studio versions.
  • Fixed issue where intermittent failures to retrieve database schema would not recover unless the Prompt AI window was closed and re-opened.
  • Fixed an issue in Code Analysis where extended stored procedures were incorrectly suggested to use named parameter style.
  • Fixed an issue in Code Analysis where SYSUTCDATETIME was incorrectly identified as a user-defined function (UDF).
  • Fixed an issue in SQL Prompt where script containing JSON_OBJECT would not get formatted.
  • Fixed issue that would prevent SQL Prompt from reacting to database connection modifications if suggestions were disabled.
  • Prompt AI window will no longer wrongly claim you are not connected to a database when clicking in non SQL editor windows (e.g. "Object Explorer").
  • The list of AI suggestions (initial or follow-up) will now only be re-generated when necessary (e.g. if the database connection changed) to avoid needless processing and server-side network requests.
  • Fixed an issue where SSMS 22 freezes during the initial import of user settings with SQL Prompt already installed.
SQL Prompt Pro 11.3.3.20567Jan 7, 2026
Features
  • Query Index Analysis main menu entry now appears under the AI section.
Fixes
  • Fixed SQL History panel in the options menu from disappearing when you reset options to default in SSMS.
  • Fixed an issue where restoring default options would only restore one option at a time.
  • Fixed performance issue in SQL Prompt when the active formatting style was not stored locally.
  • Fixed and enhanced Prompt AI features availability checks. More information will be provided in the options if they are not available.
  • Fixed InvalidOperationException that could be thrown when trying to launch Prompt AI features.
  • Disabling Prompt AI now correctly disables Query Index Analysis (which uses an internal AI model).
  • Fixed logging in all supported versions of Visual Studio.
  • Fixed several use cases where the connected database schema was not being sent as part of the AI request.
  • Fixed formatting inconsistencies when the "Collapse Short Control Statement" option is enabled containing 'ELSE BEGIN' clause.