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
Download free 28 day trial

Introduction to SQL Prompt

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.

Whether you need to write, refactor, or explore database code, find out how SQL Prompt makes it effortless by trying it free for 28 days.

Download free 28 day trial

Pricing information

per user

Buy now

with volume discounts of up to 30%

SQL Prompt is part of the SQL Toolbelt

Version control your work & speed up deployment, with all our SQL Server tools

See what’s included

Watch the 12 SQL Finger Tips

SQL Finger Tips

Have you got SQL fingers?

Watch these free tips videos to get top SQL writing tips from SQL Server MVPs Steve Jones and Grant Fritchey, as well as Redgate's own Tom Crossman.

Don't just take our word for it

Key features of SQL Prompt

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, even 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. Letting you 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.

Eliminate invalid objects

Keep your databases tidy and reliable with a complete list of any invalid objects, and unused variables and parameters.

To fix them, you can script objects as ALTER directly from queries.

New: Actions list

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

Updated support for Visual Studio

You can now use even more of SQL Prompt's features in Visual Studio 2015. Check out the Features Grid for more detail.

Updated frequently, based on your feedback

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.

Still not convinced?

There aren’t many people more qualified at programming SQL than SQL Server MVPs Steve Jones and Grant Fritchey.

Watch how they fared at coding with – and without – SQL Prompt.


FeatureSSMSVisual Studio
Code completion with statement expansionxx
Instant access to schema informationxx
Shareable SQL snippetsxx
Find invalid SQL Server objectsx
Tab history – save, search, and recover tabsx
Select column dependenciesxx
Auto-generation of aliasesxx
Script as ALTER from query windowxx
Expand wildcardsxx
Format SQL codexx
Tab coloringx
Decrypt encrypted objectsxx
Summarize scriptsxx
Find unused variables and parametersxx
Qualify object namesxx
Smart rename refactoringx
Split tablexx
Encapsulate as stored procedurexx
Uppercase keywordsxx

Case study

"We no longer need to memorize column names, and joining tables is now just a click away"

— Arnold Dieterle, Development Manager, VEGA Grieshaber

Find out how the 12-man development team at VEGA Grieshaber, a German instrumentation company, save time writing SQL, cut errors in their code, and respond to user requests fast, with Redgate SQL Prompt.

Read the case study (PDF)


SQL Prompt quick reference guide

This handy quick reference guide includes our top 12 snippets, and shortcuts and tips for code-completion, formatting, navigation, and refactoring SQL code in SSMS and Visual Studio.

Download the quick reference guide (PDF 374K)

SQL Prompt vs. Native IntelliSense

Compare SQL Prompt feature-by-feature with SQL Server's native IntelliSense.

Download the feature comparison (PDF 391K)

SQL Prompt ROI Guide

This paper shows you how SQL Prompt helps your development and DBA teams, and how that translates into ROI for your business.

Download the ROI guide (PDF 136K)