Write, format, and refactor SQL effortlessly

in SQL Server Management Studio and Visual Studio

  • IntelliSense-style code completion
  • Code snippet library
  • Refactor SQL code
  • SSMS tab history
  • SSMS tab coloring
  • Updated: Customizable code formatting
    Read more
Download free trial

SQL Prompt Pro - a short introduction (4:14)

Introduction to SQL Prompt Pro

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

So we made SQL Prompt Pro, which isn’t

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

As well as autocompleting your code, SQL Prompt Pro 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 Pro makes it effortless by trying it free for 28 days.

Download free 28 day trial

$369 per user

Buy now

$315 per user

15% discount for 5-9 users

Buy now

$295 per user

20% discount for 10+ users

Buy now

If you’re looking to license your whole team of 20 or more users, get in touch.

SQL Prompt is part of the SQL Toolbelt. See the benefits.

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 Pro 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 Pro's single-click, customizable code reformatting.

New: Create, share and switch between multiple styles.

Actions list

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

Updated support for Visual Studio

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

Updated frequently, based on your feedback

SQL Prompt Pro's beta is updated regularly based on feedback from the forums and SQL Prompt Pro 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 Pro.

Features

FeatureSSMSVisual Studio
Code completion with statement expansion
Instant access to schema information
Shareable SQL snippets
Find invalid SQL Server objects
Select column dependencies
Auto-generation of aliases
Script as ALTER from query window
Expand wildcards
Format SQL code
Save and share your formatting styles   Read more
Try out styles used by other SQL professionals   Read more
Decrypt encrypted objects
Summarize scripts
Find unused variables and parameters
Qualify object names
Split table
Encapsulate as stored procedure
Uppercase keywords
Tab history – save, search, and recover tabs
Tab coloring
Smart rename refactoring

SQL Prompt Labs

SQL Prompt Pro includes Labs, experimental features you can turn on from the SQL Prompt options. SQL Prompt Labs features are still in development, so might be unstable.

Create, share, and switch between formatting styles

Our latest update lets you create, share, and save multiple code formatting styles. You can switch effortlessly between them and try out new styles created by others.

To start using the new formatting styles:

  1. On the SQL Prompt menu, select Options
  2. Go to the Labs > Experimental Features page
  3. Select the "Use new formatting styles" checkbox

The new formatting styles replace the old formatting system. When this box is checked, your old formatting options will not be available. To revert back to the old formatting options, untick the experimental feature.

Part of our Database DevOps solution

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 give 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.

Learn more about the benefits