Introducing G2.ai, the future of software buying.Try now
SQL Prompt
Save to My Lists
Claimed
Claimed

Top Rated SQL Prompt Alternatives

PostgreSQL
(638)
4.4 out of 5

SQL Prompt Reviews & Product Details

SQL Prompt Overview

What is SQL Prompt?

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

SQL Prompt Details
Show LessShow More
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.

Seller
Description

Redgate offers end-to-end Database DevOps to help organizations streamline software development and get value from their data faster. Redgate’s portfolio of solutions helps organizations reliably solve the complex challenges of database management across the DevOps lifecycle on any database, anywhere. We make life easier for IT leaders, development and operations teams, increasing efficiency, reducing errors and safeguarding business-critical data. More than 200,000 people globally, including 92% of the Fortune 100, trust Redgate to deliver ingeniously simple software.

Overview Provided by:

SQL Prompt Integrations

(1)
Integration information sourced from real user reviews.

SQL Prompt Media

SQL Prompt Demo - Formatting your code
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 ...
SQL Prompt Demo - Command Palette
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 ...
SQL Prompt Demo - 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...
Product Avatar Image

Have you used SQL Prompt before?

Answer a few questions to help the SQL Prompt community

19 SQL Prompt Reviews

4.7 out of 5
The next elements are filters and will change the displayed results once they are selected.
Search reviews
Hide FiltersMore Filters
The next elements are filters and will change the displayed results once they are selected.
The next elements are filters and will change the displayed results once they are selected.
19 SQL Prompt Reviews
4.7 out of 5
19 SQL Prompt Reviews
4.7 out of 5

SQL Prompt Pros and Cons

How are these determined?Information
Pros and Cons are compiled from review feedback and grouped into themes to provide an easy-to-understand summary of user reviews.
Pros
Cons
G2 reviews are authentic and verified.
Verified User in Computer Software
UC
Mid-Market (51-1000 emp.)
"SQL Prompt is Pretty Much a Necessity for SQL Server"
What do you like best about SQL Prompt?

The autocomplete is super-fast, it auto-suggests joins when there is a PK/FK relationship, formats my code the way I want. Just so many things. I'm in the camp of "I'll never work on SQL Server without it again, even if I have to switch jobs". If you haven't used it before, sign up for a free trial and see what it can do. Review collected by and hosted on G2.com.

What do you dislike about SQL Prompt?

It doesn't work with VS Code is the only complaint I have. Review collected by and hosted on G2.com.

Damir M.
DM
Microsoft Data Platform MVP
Small-Business (50 or fewer emp.)
"Can't live widouth"
What do you like best about SQL Prompt?

Once a user learns to use SQL Prompt, and if by any chance they no longer have that option, they feel lost. The tool is so perfect that it simply makes work easier and faster. Review collected by and hosted on G2.com.

What do you dislike about SQL Prompt?

Nothing because the tool is perfect! I really enjoy it. Review collected by and hosted on G2.com.

James C.
JC
Developer
Small-Business (50 or fewer emp.)
"Everything SSMS Should Have Been OOTB"
What do you like best about SQL Prompt?

A no-hassle tool. SQL Prompt provides useful intellisense suggestions that go way beyond the scope of what the bog-standard SSMS environment provides. Redgate have found a niche in the market where Microsoft refuses to elaborate, and I commend them for that. There are a plethora of features, most of which I probably don't use to the full extent, but suggestions for the sprocs to call, auto-filling of code, auto-formatting, casing, efficiency/code-standard suggestions, and even allowing to peek at sprocs if you need to just quickly view some previously written code are invaluable for saving time. On top of that, the environmental feature that allow you to colour-coordinate your environments is an underrated perk that's useful for when you are making SQL changes in different areas. I use SQL prompt every day as it slices the amount of development time for tasks. Some would argue that SQL prompt is a crutch, and I have to admit I wouldn't be without it now, but there's a reason for that, and that's simply because it's too good to pass up. Review collected by and hosted on G2.com.

What do you dislike about SQL Prompt?

SQL Prompt can be quite resources intensive at times. I have no issues with the product as a whole, but the SQL history feature can really bog down my workstation.This is definitely a minor greviance in the scope of the product however. Review collected by and hosted on G2.com.

BW
Data Analyst
Mid-Market (51-1000 emp.)
"I won't work without it"
What do you like best about SQL Prompt?

When I changed organizations and lost access to SQL Prompt, I immediately decided to purchase it myself. I rely on its formatting and snippets every day. My new team also started using Prompt. Review collected by and hosted on G2.com.

What do you dislike about SQL Prompt?

Maybe I use it too much now. If I have to write all syntax correctly without it, I might lose my job. Review collected by and hosted on G2.com.

Heimo H.
HH
Senior Business Intelligence Architect
Enterprise (> 1000 emp.)
"A must-have in everey project"
What do you like best about SQL Prompt?

SQL Prompt's SQL syntax type-ahaead, smart column suggestions, alias resolution... you name it: these features come in so handy and natural you only immediately notice when they're not there (because you launched the wrong instance of SSMS). I don't want to work without it.

As for time saved, this thing literally pays for itself. Review collected by and hosted on G2.com.

What do you dislike about SQL Prompt?

With the usual underpowered terminal server virtual desktop session, performance can be just a tad sluggish at times, particularly at startup. Review collected by and hosted on G2.com.

BK
Principal Programmer/Analyst
Enterprise (> 1000 emp.)
"Fantastic, must-have Utility"
What do you like best about SQL Prompt?

I've been using SQL Prompt for years. The autocompletion, formatting, tab colors, snippets and other features are fantastic. I can't imagine using SSMS without it. Review collected by and hosted on G2.com.

What do you dislike about SQL Prompt?

I can't think of any downsides. Just a great product and company. Review collected by and hosted on G2.com.

Jennifer M.
JM
CEO
Enterprise (> 1000 emp.)
"I’d buy this JUST for the code formatting"
What do you like best about SQL Prompt?

It has quite a few useful features, but my favorite by far is the T-SQL formatting. Review collected by and hosted on G2.com.

What do you dislike about SQL Prompt?

Nothing, really. It's a truly great product. Review collected by and hosted on G2.com.

Mikey B.
MB
Leader
Enterprise (> 1000 emp.)
"Very useful addition to SSMS"
What do you like best about SQL Prompt?

SQL Prompt is where I need it. It's quick and helpful. Review collected by and hosted on G2.com.

What do you dislike about SQL Prompt?

It does not handle well SQL upgrades. Recently upgraded instances to SQL 2022 and users reporting crashes. Need to upgrade SQL Prompt, but this could be potentially handled better. Review collected by and hosted on G2.com.

Greg B.
GB
Senior Sql Server Database Administrator
Mid-Market (51-1000 emp.)
"Very intuitive for a SQL Server DBA"
What do you like best about SQL Prompt?

It integrates with SSMS the way a DBA would expect. Review collected by and hosted on G2.com.

What do you dislike about SQL Prompt?

Really no negatives, very straightforward as a tool. Review collected by and hosted on G2.com.

Jason S.
JS
Architect
Small-Business (50 or fewer emp.)
"Coding without it is like wearing handcuffs!"
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.

SQL Prompt