redgate SQL Prompt

Write, format, and refactor SQL effortlessly

IN SQL SERVER MANAGEMENT STUDIO AND VISUAL STUDIO

IntelliSense-style code completion

Customizable code formatting

Code snippet library

Refactor SQL code

SSMS tab history

New: SSMS tab coloring

Writing SQL code by hand, even with IntelliSense, is frankly pretty dull

So we made SQL Prompt, which isn’t

An add-in for SQL Server Management Studio and Visual Studio, SQL Prompt strips away the repetition of coding.

As well as autocompleting your code, SQL Prompt takes care of formatting, object renaming, and other distractions, so you can concentrate on how the code actually works.

Key features

 

 

Autocomplete does the work for you – even for JOINs

As well as making the most common queries, such as SELECTs and INSERTs, quick to write, SQL Prompt completes JOIN conditions for you automatically. You don't have to remember any column names or aliases.

 

Share your snippets

Type even less by adding your own code snippets to the customizable library and sharing them with your team. That way, everyone can enjoy even faster, easier coding.

 

Save and recover lost tabs in SSMS

With tab history, you can save, preview, and rename tabs – and restore tabs previously opened in SSMS. You can pick up work where you left off and start coding again in seconds.

Safely refactor SQL code

 

Rename objects without breaking dependencies and encapsulate SQL code as a stored procedure.

 

 

 

One-click SQL code formatting

Make code readable and keep developers working to the same standards, with SQL Prompt's single-click, customizable code reformatting.

 

 

New: Actions list

Wrap your code in a block, toggle comments, and more with SQL Prompt's new Ctrl-key actions list.

 

SQL Prompt's beta is updated regularly based on feedback from the forums and SQL Prompt UserVoice. If there's a feature you'd love to see, just let us know.

Redgate’s Database DevOps solution lets you extend your DevOps practices to SQL Server databases so that you can optimize productivity, agility and performance across the full database lifecycle and become a truly high performing IT organization.

From safely making a change in development through to monitoring its impact in production, Redgate is with you every step of the way. We gives you the tools and insight you need to optimize your development processes, so you can keep your team moving, keep adding value and keep your data safe.