Write, format, share and refactor your SQL effortlessly

in SQL Server Management Studio and Visual Studio

Download free trial What's new in version 8

Introduction to SQL Prompt Pro

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

So we made SQL Prompt Pro, which isn’t.

Available as 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 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 for both SSMS and Visual Studio

Formatting your code

Try formatting your own SQL code below with a few predefined styles, or create and share your own styles with the full formatting options in SQL Prompt Pro. Download a 28-day free trial.

Styles

SELECT CompanyName,AddressType,AddressLine1 FROM Customer JOIN CustomerAddress ON (Customer.CustomerID=CustomerAddress.CustomerID) JOIN Address ON (CustomerAddress.AddressID=Address.AddressID) WHERE CompanyName='ACME Corporation'

Format or press Ctrl+Enter

Easily switch between styles in one click

Work in your own preferred style, then switch to your shared team style for co-working, and on to your company-wide style when you are ready to ship.

Fine-tune your formatting

Our advanced options allow you to fine-tune your formatting styles to get them exactly how you like them, and you can even share them with your friends and colleagues.

Format only what you need

Select a fragment of SQL script you want formatting simply by selecting it, or disable formatting for certain blocks by using our handy actions shortcut.

Navigating your code

Our smart code completion works as you type, providing suggestions to help make your coding fast and accurate.

Code completion with statement expansion

Our smart code completion works as you type, providing suggestions to help make your coding fast and accurate.

Use SQL Prompt to script out an object in a query simply by right clicking and choosing Script Object as ALTER from the menu.

Scripting an object as ALTER

Use SQL Prompt to script out an object in a query simply by right clicking and choosing Script Object as ALTER from the menu.

With SQL Prompt you can select an object or synonym from Object Explorer directly from the query window.

Select an object in the Object Explorer

With SQL Prompt you can select an object or synonym from Object Explorer directly from the query window.

Use SQL Prompt to find invalid objects in your database, such as if you want to know if any objects are referencing other objects that have been dropped.

Find invalid SQL Server objects

Use SQL Prompt to find invalid objects in your database, such as if you want to know if any objects are referencing other objects that have been dropped.

SQL Prompt can find and highlight any parameters or variables that are unused in a script.

Find unused variables and parameters

SQL Prompt can find and highlight any parameters or variables that are unused in a script.

Access your schema information and view a summary of the actions that a SQL script performs, in the order in which they occur.

Instant access to schema information and summarize scripts

Access your schema information and view a summary of the actions that a SQL script performs, in the order in which they occur.

Refactoring your code

Safely rename objects in your script

You can use SQL Prompt to rename all occurrences of a variable or alias in a query.

Encapsulate SQL as a new stored procedure

With SQL Prompt, you can create a new stored procedure from any block of valid SQL.

Split a table in your database

SQL Prompt can split a table in your database into two tables. This is useful if you want to normalize a database, improve database performance or change the database design.

Features only 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.

Save and recover lost tabs

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.

Set different colors for different groups, servers and databases, so you can quickly and easily identify which environment you’re working in within SSMS.

Tab coloring

Set different colors for different groups, servers and databases, so you can quickly and easily identify which environment you’re working in within SSMS.

Create a script that allows you to rename objects in your database without breaking dependencies.

Smart rename refactoring

Create a script that allows you to rename objects in your database without breaking dependencies.

SQL Prompt Pro in action

See how quick and easy code completion, formatting, and refactoring can be with SQL Prompt Pro

Watch the video

Watch how SQL Server MVPs Steve Jones and Grant Fritchey fared at coding with – and without – SQL Prompt Pro

Watch the coding challenge

SQL Prompt

Get started with SQL Prompt

Download a 28-day free trial, and find out just how effortless coding SQL can be.

Download free trial

Need a hand?

If you'd like any help, or have a question about our tools or purchasing options, just get in touch.

SQL Prompt Pro is part of the SQL Toolbelt

Sync data, deploy from version control, and more, with all our SQL Server tools.

See what's included

Database DevOps

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.

Learn about the benefits