SQL Prompt Reviews & Product Details

Redgate creates ingeniously simple software to help data professionals get the most value out of any database, anywhere, through the provision of end-to-end Database DevOps. More than 200,000 people globally, including 92% of the Fortune 100, trust Redgate to deliver ingeniously simple software. 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 Promp

Seller

Redgate Software

Product Description

SQL Prompt enables you and your team to write, format, analyze, and refactor your SQL effortlessly in SQL Server Management Studio and Visual Studio.

Overview by

Louise Domeisen

Pricing

Pricing provided by SQL Prompt.

SQL Prompt

Starting at $168.00

1 user Per Year

View More Pricing Information

Top-Rated Alternatives

View All Alternatives

SQL Prompt Integrations

(1)

Integration information sourced from real user reviews.

SQL Prompt Media

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

Speed up your workflow 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. Control both SSMS and SQL Prompt The command palette helps you use functionality in Prompt, and shows ...

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

SQL Prompt Reviews (20)

G2 reviews are authentic and verified.

Here's how.

Jason S.

Architect

Small-Business (50 or fewer emp.)

11/10/2024

"Coding without it is like wearing handcuffs!"

5/5

What do you like best about SQL Prompt?

The ease of use and speed at which you can write code is exponentially faster. I'll never NOT use it. Review collected by and hosted on G2.com.

What do you dislike about SQL Prompt?

There isn't really anything that I would change. Review collected by and hosted on G2.com.

Adrian M.

Small-Business (50 or fewer emp.)

8/8/2024

"The best tool for T-SQL Development"

5/5

What do you like best about SQL Prompt?

It's ease of use, wide variety of features (Intellisense, SQL History and Snippets being in the top, Code Formatting), and the excellent and seamless SSMS integration. Review collected by and hosted on G2.com.

What do you dislike about SQL Prompt?

Formatting could use a bit more flexibility in defining the style.

And the fact that Azure Data Studio still doesn't have a full version... And possibly never will? :( Review collected by and hosted on G2.com.

Michael B.

Computer Guru, Photographer, Musician

Small-Business (50 or fewer emp.)

8/8/2024

"Invaluable tool to reduce typing and make formatting consistent"

5/5

What do you like best about SQL Prompt?

It is vastly superior to SSMS' built-in tool for command completion.

It saves me a LOT of typing. Review collected by and hosted on G2.com.

What do you dislike about SQL Prompt?

SQL Format has changed recently and now sticks tabs in odd places. I have to review any script that I have re-formatted using SQL Format. Review collected by and hosted on G2.com.

Verified User in Non-Profit Organization Management

Enterprise (> 1000 emp.)

8/8/2024

"Good product undone by refusal to support current technology"

2.5/5

What do you like best about SQL Prompt?

Very useful formatter with solid customisation rules. Review collected by and hosted on G2.com.

What do you dislike about SQL Prompt?

No support for Azure Synapse rendering core functionality useless. After years of the product being around and RedGate refusing to support Synapse, it has become clear that they have no intention to incorporate support for a market leading platform. Review collected by and hosted on G2.com.

Verified User in Health, Wellness and Fitness

Enterprise (> 1000 emp.)

11/9/2024

"good product"

3.5/5

What do you like best about SQL Prompt?

Helps to write TSQL faster. Intellisense is great. Review collected by and hosted on G2.com.

What do you dislike about SQL Prompt?

Occasionally has to be re-configured to work. Installing on a new computer is a drag. Review collected by and hosted on G2.com.

Remko v.

Business Intelligence Specialist

Enterprise (> 1000 emp.)

10/23/2023

"As a data warehouse developer I use SQL Prompt which increases my productivity by a lot"

5/5

What do you like best about SQL Prompt?

You can expand all columns under a SELECT * with one button

Pressing F2 enables you to rename the aliases you currently have your cursor on for the entire query.

When you want to see or edit the definition of a procedure you simply type ALTER PROCEDURE with the name of the procedure and Prompt gets the definition in your query screen. I hardly use the object explorer of SSMS anymore.

Sql Prompt can fill out GROUP BY statements automatically for you.

It Highlights for you which INSERT INTO line belongs to which SELECT line.

Hovering over objects gives all info about an object and makes it possible to copy the definition

The intellisense is better than standard in SSMS. Review collected by and hosted on G2.com.

What do you dislike about SQL Prompt?

The button for updating SQL Prompt intellisense is different than the SSMS intellisense.

There is a shortcut to only execute the statement under the cursor. But this doesn't work if there are any syntax errors in your query even is it unrelated to the current. Review collected by and hosted on G2.com.

Verified User in Financial Services

Small-Business (50 or fewer emp.)

8/12/2024

"Very helpful"

4.5/5

What do you like best about SQL Prompt?

enables quick and fluent coding of queries and sql objects including history Review collected by and hosted on G2.com.

What do you dislike about SQL Prompt?

sometimes causes ssms to stop working (locked) Review collected by and hosted on G2.com.

Khijar S.

Junior DevOps Engineer

Mid-Market (51-1000 emp.)

11/28/2023

"Inhance the productivity with SQL Prompt"

4/5

What do you like best about SQL Prompt?

As I give title it enhance the productivity and development and reduce production cost and timing Review collected by and hosted on G2.com.

What do you dislike about SQL Prompt?

There are some flaws and cons like every tool and SQL Prompt cons like it's dependency, it required more time to learn just because of its wide verities of features it should have some friendly user working for new user Review collected by and hosted on G2.com.

Tomas H.

Data Warehouse Developer

Enterprise (> 1000 emp.)

3/9/2023

"The best SQL coding tool I've used"

5/5

What do you like best about SQL Prompt?

You increase your coding speed by a factor of 10x. The snappiness of the suggestions for columns, tables, and joins. SQL also makes adhering to a consistent coding style easy, making reviewing and fault tracing much more efficient. Review collected by and hosted on G2.com.

What do you dislike about SQL Prompt?

Not much. Sometimes, the coding style could be a little more "dynamic" depending on the amount of code in the script. The coding style examples might not always apply to significant amounts of code. Review collected by and hosted on G2.com.