in SQL Server Management Studio and Visual Studio
Writing and formatting SQL code by hand, even with IntelliSense, is frankly pretty dull
So we made SQL Prompt, which isn't.
Available as 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 trial
1 Year Subscription
$198 per user
1 Year Subscription
$168 per user
1 Year Subscription
$159 per user
Part of SQL Toolbelt Essentials
Contact us for a personalized quote
“I have always been a huge fan of Redgate’s software, and I can confidently say that SQL Prompt is a masterpiece. It has super-enhanced my SQL scripting abilities and has cut my scripting time down to a quarter or less. The tool is very intuitive, and the comprehensive settings allow me to tailor it to my own coding style.”
“If you take SQL Prompt away from me, I'll have to quit!”
“The ability to have every DB developer’s code formatted the same way with the execution of a simple command is incredibly helpful to making code reviews more efficient, and to reducing long-term product maintenance costs.”
“Working smarter is one of the reasons I'm such a fanboy of Redgate's products…One of my favorite tools is SQL Prompt, an SSMS plugin that adds "missing" functionality, or has similar features which work better. Either way, if you use SSMS, SQL Prompt will make your life better.”
“I love SQL Prompt. The speed and friendly, intuitive nature of the tool is excellent. The way it handles autocompletion for eg CTEs and combinations of
APPLYand variables makes it a great tool for improving speed and quality for our development efforts. I've recommended it across the entire development team and it is loved by all.”
“It saves huge amounts of time, boosts productivity, enforces common layout and coding standards, and means I can focus fully on the task in hand, while letting the syntax and code take care of themselves.”
“I use SQL Prompt whenever I write any SQL, simple or complex, because it's such a powerful programming aid. I no longer have to constantly look up or memorize obscure object names and SQL commands – instead, I can just browse for them.”
“I am a consultant who specializes in backend systems. I normally spend about 50% of my day in SQL Server Management Studio. Since I started using SQL Prompt, I am at least 30% more productive. Even my clients are starting to notice. I honestly cannot comprehend how I managed to write Transact-SQL prior to this tool.”
“SQL History is a huge productivity booster; I use it daily. I've changed the way I work within SSMS, just so I can leverage SQL History.”
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. Download a 28-day free trial.
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
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.
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.
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.
The command palette gives you a speedy way to get to the things you use everyday using a single keyboard shortcut, while helping you find new and useful stuff to try.
The command palette helps you use functionality in Prompt, and shows you the most used menu items from SSMS.
When opened in a database, all objects from the schema of the database will appear in the command palette.
Code completion with statement expansion
Our smart code completion works as you type, providing suggestions to help make your coding fast and accurate.
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.
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.
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.
Find unused variables and parameters
SQL Prompt can find and highlight any parameters or variables that are unused in a script.
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.
You can use SQL Prompt to rename all occurrences of a variable or alias in a query.
With SQL Prompt, you can create a new stored procedure from any block of valid SQL.
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.
Over 90 rules are available out-of-the-box, all manageable from the Options menu. Code issues are underlined with quick tips on hover, and further details when you click on the lightbulb icon.
Once SQL Prompt’s code analysis has highlighted problematic code, you can select the orange lightbulb icon and apply an auto-fix to bring your code up to standard.
The side panel gives you more information about the issue and how you can fix it, plus get links to further reading online.
View a whole list of code issues detected in a SQL script, group them by type, and export them. This makes it much easier for a team to perform code reviews, or analyse a legacy code base for possible refactoring improvements.
You can choose which suggestions you see, save them in a shared drive or a source control folder, and share with your team.
New Feature: Quickly keep track of, search and recover your work by accessing a history of all the queries you’ve written and executed in SSMS.
Set different colors for different groups, servers and databases, so you can quickly and easily identify which environment you’re working in within SSMS.
Smart rename refactoring
Create a script that allows you to rename objects in your database without breaking dependencies.
See how quick and easy code completion, formatting, and refactoring can be with SQL PromptWatch the video
Watch how SQL Server MVPs Steve Jones and Grant Fritchey fared at coding with – and without – SQL PromptWatch the coding challenge
Get started with SQL Prompt
Download a 28-day free trial, and find out just how effortless coding SQL can be.
If you'd like any help, or have a question about our tools or purchasing options, just get in touch.