The mission

To help database professionals to write accurate SQL faster and win back time in their day.

Double coding speed with IntelliSense-style code completion, one-click SQL formatting, customizable code snippets, SQL query history, and more.

Improve accuracy and resolve errors before they cause complex problems using as-you-type code analysis, auto-fixes, and SQL refactoring.

What's new

SQL History - Bulk Delete

Added option to configure retention period and delete SQL history query versions based on set days.

Results Grid Aggregates

Added the ability to show the aggregate values of a selection of cells in the results grid. Also, added distinct count functionality in aggregate results.

SQL History - Sort Options

Added sort options inside SQL History

SQL History

Keep a copy of all queries that you write, along with a searchable history of each

Password breach check

Added command to the command palette to check connections password breach

Support

SQL Server 2022 and Visual Studio 2022 support

Autofix with shortcut

Added ability to autofix using keyboard shortcut

See the full release notes

What's next

In Development

SQL History improvements

SSM21 Support

Further improvements to SQL Prompt performance and features

Researching

New and improved team-based capabilities

Integrating SQL Prompt capabilities into other Redgate tools

Generative AI (Prompt+)

Prompt+ brings together the power of a generative AI model, context-based insights and expertise in SQL coding to collaborate with you as you code. Prompt+ is an Early Access Program (EAP).

Learn more

Suggest a new feature