Write, format, and refactor SQL effortlessly in Visual Studio and SQL Server Management Studio

  • IntelliSense-style code completion
  • Customizable code formatting
  • Code snippet library
  • Work quickly with data from the Results grid
  • New: Included in Visual Studio Enterprise 2017

Video: SQL Prompt in Visual Studio

SQL Prompt comes in two editions

SQL Prompt Core Edition is available in Visual Studio Enterprise 2017.

Get it in the Data storage and processing workload in the VS installer.

See what’s included.

SQL Prompt Pro lets you standardize SQL with formatting and snippets, and a host of features to improve productivity.

If you’re already using SQL Prompt Core Edition, select ‘Upgrade’ in the tools to try SQL Prompt Pro for 28 days.

Not using Visual Studio Enterprise 2017?

You can still try SQL Prompt Pro for 28 days.

Download SQL Prompt

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 extension for Visual Studio and SQL Server Management 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 get back to the task in hand.

Whether you need to write, format, or explore database code, SQL Prompt makes it effortless.

Get it free in Visual Studio 2017 Enterprise, or download a free 28-day trial of SQL Prompt Pro to benefit from a host of additional features to help you and your team be more productive.

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

Write SQL 50% faster

Write SQL quickly and accurately with the help of intelligent code completion.

Standardize the layout of your SQL code

Customize and share formatting styles to improve readability, quickly identify errors, and more easily make edits without introducing mistakes.

Strip away the repetition of coding

Create and share frequently used snippets of SQL.

Work wherever you’re most comfortable

Work in SQL Server Management Studio as well as Visual Studio. Support in SSMS includes tab management so you can save and recover lost tabs, and tab coloring by environment so you don’t accidentally execute against Production.

Increase productivity

Benefit from a host of features to save you time. For example, take data from the Results Grid and choose to ‘Copy as an IN clause’, ‘Script as an INSERT statement’, or ‘Open results in Excel’, at the click of a button.


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.

Compare editions

Code Completion FeaturesCore EditionPro
Code completion for databases, system objects, keywords, T-SQL commands (e.g. SELECT), stored procedures, parameters, closing parentheses and brackets, aliases
Expand singular wildcards
Offer suggestions from linked servers
CamelCase and mid-string suggestions
Code highlighting (matching BEGIN and END, for example)
Suggestions for INSERT statements with column lists
Auto-complete EXEC statements with parameter lists
Highlight matching objects (context-aware)
Rename variables and aliases
Code FormattingCore EditionPro
One click code formatting
Create and share customized formatting styles
Insert semicolons
Productivity FeaturesCore EditionPro
Built in snippets (SSF = SELECT * FROM, for example)
Create, share, and customize frequently used snippets
Code navigation
Explore table and function definitions from code
Find unused parameters and variables
Object information
Summarize script in one click
Safely split tables
Find invalid objects
Result Grid shortcuts: Copy as IN clause, Script as INSERT, Open in Excel
Execute current statement
Execution warnings for DELETE and UPDATE statements
Search and reopen tabs (in SSMS only)
Tab coloring (in SSMS only)
Smart Rename refactoring (in SSMS only)
Supported technologiesCore EditionPro
Visual Studio 2017 Enterprise edition
SQL Server 2016, 2014, 2012, 2008, 2008 R2
Azure SQL Database
Visual Studio 2015, 2013, 2012, 2010
SQL Server 2005, 2000
SQL Server Management Studio 2016, 2014, 2012, 2008 R2, 2008, 2005, Express edition
Azure SQL Data WarehousePartialPartial
Analytics Platform SystemPartialPartial
Technical SupportCore EditionPro
Technical SupportCommunity support via forums, documentationFull Redgate support:
email, telephone, forums, documentation
Core$369

DevOps for SQL Server

If you’re looking to implement DevOps for your SQL Server databases and you’re not sure where to start, get in touch.

We're here to help

Contact us to find out how Redgate’s Database DevOps Solution can help your team deliver value quicker and keep your data safe

Industry standard tools

Redgate has specialized in database software for 17 years. Our products are used by 804,000 IT professionals, in more than 100,000 companies.

World-class support

Redgate offers comprehensive documentation and a friendly, helpful support team. An average 87% of customers rate our support 'Excellent'.

Contact us