in SQL Server Management Studio and Visual Studio
Writing 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 28 day trial
“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.”
“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.”
Autocomplete does the work for you – even for
As well as making the most common queries, such as
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.
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.
Updated support for Visual Studio
You can now use even more of SQL Prompt Pro's features in Visual Studio 2017. Check out the Features Grid for more detail.
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.
|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|
|Format SQL code|
|Save and share your formatting styles Read more|
|Try out styles used by other SQL professionals Read more|
|Decrypt encrypted objects|
|Find unused variables and parameters|
|Qualify object names|
|Encapsulate as stored procedure|
|Tab history – save, search, and recover tabs|
|Smart rename refactoring|
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.
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:
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.
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