# SQL Prompt Reviews **Vendor:** Redgate Software **Category:** [Relational Databases](https://www.g2.com/categories/relational-databases) **Average Rating:** 4.7/5.0 **Total Reviews:** 21 ## About 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 Pros & Cons **What users like:** - Users love the **powerful T-SQL formatting** and snippets, which enhance their productivity and speed in writing code. (4 reviews) - Users find SQL Prompt's **ease of use** and speed to significantly enhance their coding efficiency and daily workflow. (3 reviews) - Users rave about the **super-fast autocomplete** of SQL Prompt, making coding significantly quicker and easier. (3 reviews) - Users appreciate the **seamless integration with SSMS** , matching DBA expectations for efficient database management. (1 reviews) - Users love the **super-fast autocomplete** in SQL Prompt, enhancing their coding efficiency and experience significantly. (1 reviews) - Software Updates (1 reviews) **What users dislike:** - Users find the **complex configuration** process cumbersome, especially when installing SQL Prompt on new computers. (1 reviews) - Users find the **difficult setup** of SQL Prompt frustrating, especially when reinstalling on new computers. (1 reviews) - Users report **downtime issues** during SQL upgrades, causing crashes and disruptions in their workflow. (1 reviews) - Users experience **upgrade issues** with SQL Prompt, particularly crashes after transitioning to SQL 2022. (1 reviews) ## SQL Prompt Reviews ### 1. SQL Prompt is the tool you need as T-SQL developer ! **Rating:** 5.0/5.0 stars **Reviewed by:** Aristide B. | SQL developer, Enterprise (> 1000 emp.) **Reviewed Date:** March 30, 2026 **What do you like best about SQL Prompt?** SQL Prompt helps me and my team to save time while coding by using snippets, column picker, shortcuts and format code in a very simple and intuitive way **What do you dislike about SQL Prompt?** With new SSMS22 and GitHub for Copilot, Redgate and AI now conflicts. I hope this will be solved in the coming releases. Otherwise, there is nothing to say about SQL Prompt, this is a tool designed by developers, for developers **What problems is SQL Prompt solving and how is that benefiting you?** While coding using SSMS, the default intellisense is very poor. SQL prompt helps developers to gain time with suggestions, snippets, code formatting and much more ### 2. SQL Prompt: I Can't Live Without It **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Real Estate | Enterprise (> 1000 emp.) **Reviewed Date:** November 11, 2025 **What do you like best about SQL Prompt?** I’ve been using Redgate tools for nearly a decade, and they’ve become essential to my workflow. SQL Prompt alone saves me hours every week. The updates are seamless, the features keep improving, and honestly, the value far outweighs the cost. I always recommend Redgate to colleagues—it's a must-have for SQL developers at any experience level. **What do you dislike about SQL Prompt?** Honestly, I haven’t experienced any downsides to SQL Prompt. It just works - simple as that. **What problems is SQL Prompt solving and how is that benefiting you?** SQL Prompt is crucial to my SQL coding speed and accuracy. I can finish projects in at least half the time it would take me to do it manually. The interface works so seamlessly - it's almost as if it's a built-in feature of SSMS. ### 3. SQL Prompt is Pretty Much a Necessity for SQL Server **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Computer Software | Mid-Market (51-1000 emp.) **Reviewed Date:** June 12, 2025 **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. **What do you dislike about SQL Prompt?** It doesn't work with VS Code is the only complaint I have. **What problems is SQL Prompt solving and how is that benefiting you?** Not only does it make it faster/easier to write code, it is also great for exploring/understanding new data sets. ### 4. Can't live widouth **Rating:** 5.0/5.0 stars **Reviewed by:** Damir M. | Microsoft Data Platform MVP, Small-Business (50 or fewer emp.) **Reviewed Date:** July 08, 2025 **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. **What do you dislike about SQL Prompt?** Nothing because the tool is perfect! I really enjoy it. **What problems is SQL Prompt solving and how is that benefiting you?** SQL Prompt is the best tool on the market for auto complete, make coding faster and help the developer. ### 5. Everything SSMS Should Have Been OOTB **Rating:** 5.0/5.0 stars **Reviewed by:** James C. | Developer, Small-Business (50 or fewer emp.) **Reviewed Date:** August 08, 2024 **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. **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. **What problems is SQL Prompt solving and how is that benefiting you?** Time saving, code efficiency, formatting, and environment control. All of these things are paramount in my work environment, and make what would be a 10 minute task, into a 2 minute task. This adds up over a day. I'm also a stickler for clean and concise code, and SQL Prompt really helps in that endeavour. ### 6. I won't work without it **Rating:** 5.0/5.0 stars **Reviewed by:** Brian W. | Data Analyst, Mid-Market (51-1000 emp.) **Reviewed Date:** November 13, 2024 **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. **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. **What problems is SQL Prompt solving and how is that benefiting you?** With consistent formatting, I maintain a style that is easy to read and helps me quickly identify issues. ### 7. A must-have in everey project **Rating:** 5.0/5.0 stars **Reviewed by:** Heimo H. | Senior Business Intelligence Architect, Enterprise (> 1000 emp.) **Reviewed Date:** August 09, 2024 **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. **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. **What problems is SQL Prompt solving and how is that benefiting you?** Code writing. Just way faster and fewer mistakes. ### 8. Fantastic, must-have Utility **Rating:** 5.0/5.0 stars **Reviewed by:** Bruce K. | Principal Programmer/Analyst, Enterprise (> 1000 emp.) **Reviewed Date:** August 10, 2024 **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. **What do you dislike about SQL Prompt?** I can't think of any downsides. Just a great product and company. **What problems is SQL Prompt solving and how is that benefiting you?** The format feature helps make long procedures more readable and maintainable. The tab colors add a visual cue to discerning Dev from Staging from Production connections. ### 9. I’d buy this JUST for the code formatting **Rating:** 5.0/5.0 stars **Reviewed by:** Jennifer M. | CEO, Enterprise (> 1000 emp.) **Reviewed Date:** November 08, 2024 **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. **What do you dislike about SQL Prompt?** Nothing, really. It's a truly great product. **What problems is SQL Prompt solving and how is that benefiting you?** SQL Prompt is unparalleled for looking into existing code: stored procedures and the like written by others. And, it keeps my own code set up the way I like. ### 10. Very useful addition to SSMS **Rating:** 5.0/5.0 stars **Reviewed by:** Mikey B. | Leader, Enterprise (> 1000 emp.) **Reviewed Date:** November 11, 2024 **What do you like best about SQL Prompt?** SQL Prompt is where I need it. It's quick and helpful. **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. **What problems is SQL Prompt solving and how is that benefiting you?** Writing tsql ### 11. Very intuitive for a SQL Server DBA **Rating:** 4.0/5.0 stars **Reviewed by:** Greg B. | Senior Sql Server Database Administrator, Mid-Market (51-1000 emp.) **Reviewed Date:** November 13, 2024 **What do you like best about SQL Prompt?** It integrates with SSMS the way a DBA would expect. **What do you dislike about SQL Prompt?** Really no negatives, very straightforward as a tool. **What problems is SQL Prompt solving and how is that benefiting you?** Its intellisense is VERY responsive ### 12. Coding without it is like wearing handcuffs! **Rating:** 5.0/5.0 stars **Reviewed by:** Jason S. | Architect, Small-Business (50 or fewer emp.) **Reviewed Date:** November 10, 2024 **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. **What do you dislike about SQL Prompt?** There isn't really anything that I would change. **What problems is SQL Prompt solving and how is that benefiting you?** Smootheh intellisence, query completion. ### 13. The best tool for T-SQL Development **Rating:** 5.0/5.0 stars **Reviewed by:** Adrian M. | Small-Business (50 or fewer emp.) **Reviewed Date:** August 08, 2024 **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. **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? :( **What problems is SQL Prompt solving and how is that benefiting you?** Writing code really fast, formatting and remebering the closed tabs via SQL History (a must have). ### 14. Invaluable tool to reduce typing and make formatting consistent **Rating:** 5.0/5.0 stars **Reviewed by:** Michael B. | Computer Guru, Photographer, Musician, Small-Business (50 or fewer emp.) **Reviewed Date:** August 08, 2024 **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. **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. **What problems is SQL Prompt solving and how is that benefiting you?** It helps me build and consistently format T-SQL scripts. It helps to ensure completeness and readability. It saves me a LOT of typing. ### 15. Good product undone by refusal to support current technology **Rating:** 2.5/5.0 stars **Reviewed by:** Verified User in Non-Profit Organization Management | Enterprise (> 1000 emp.) **Reviewed Date:** August 08, 2024 **What do you like best about SQL Prompt?** Very useful formatter with solid customisation rules. **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. **What problems is SQL Prompt solving and how is that benefiting you?** Code consistency between team members. ### 16. good product **Rating:** 3.5/5.0 stars **Reviewed by:** Verified User in Health, Wellness and Fitness | Enterprise (> 1000 emp.) **Reviewed Date:** November 09, 2024 **What do you like best about SQL Prompt?** Helps to write TSQL faster. Intellisense is great. **What do you dislike about SQL Prompt?** Occasionally has to be re-configured to work. Installing on a new computer is a drag. **What problems is SQL Prompt solving and how is that benefiting you?** To write TSQL faster. ### 17. As a data warehouse developer I use SQL Prompt which increases my productivity by a lot **Rating:** 5.0/5.0 stars **Reviewed by:** Remko v. | Business Intelligence Specialist, Enterprise (> 1000 emp.) **Reviewed Date:** October 23, 2023 **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. **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. **What problems is SQL Prompt solving and how is that benefiting you?** Faster datawarehouse development and analysis ### 18. Very helpful **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Financial Services | Small-Business (50 or fewer emp.) **Reviewed Date:** August 12, 2024 **What do you like best about SQL Prompt?** enables quick and fluent coding of queries and sql objects including history **What do you dislike about SQL Prompt?** sometimes causes ssms to stop working (locked) **What problems is SQL Prompt solving and how is that benefiting you?** readable and safe sql code ### 19. Inhance the productivity with SQL Prompt **Rating:** 4.0/5.0 stars **Reviewed by:** Khijar S. | Junior DevOps Engineer, Mid-Market (51-1000 emp.) **Reviewed Date:** November 28, 2023 **What do you like best about SQL Prompt?** As I give title it enhance the productivity and development and reduce production cost and timing **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 **What problems is SQL Prompt solving and how is that benefiting you?** It reduce code complexity by formating it. It always suggest name and structure of tables and other things and analys it ### 20. The best SQL coding tool I've used **Rating:** 5.0/5.0 stars **Reviewed by:** Tomas H. | Data Warehouse Developer, Enterprise (> 1000 emp.) **Reviewed Date:** March 09, 2023 **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. **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. **What problems is SQL Prompt solving and how is that benefiting you?** It helps me to keep my mind on the problem I am trying to solve instead of how to format the code for later reference. The new "AI" function that predicts what tables and columns I probably want to access is also working really well. ### 21. Absolute no-brainer **Rating:** 5.0/5.0 stars **Reviewed by:** S S. | Mid-Market (51-1000 emp.) **Reviewed Date:** March 08, 2023 **What do you like best about SQL Prompt?** SQL Prompt saves us a lot of time and effort. **What do you dislike about SQL Prompt?** Pricing can be a bit steep for a small shop. **What problems is SQL Prompt solving and how is that benefiting you?** Time saving, less errors, on the fly error-checking. - [View SQL Prompt pricing details and edition comparison](https://www.g2.com/products/redgate-software-sql-prompt/reviews?section=pricing&secure%5Bexpires_at%5D=2026-05-25+16%3A12%3A29+-0500&secure%5Bsession_id%5D=35c111f6-3c15-4a8e-bd5b-cf4678f2ef54&secure%5Btoken%5D=d43b549ef39e6fbeb806053bd973cb11150258cd0d09baba14eb37fb5442a3cf&format=llm_user) ## SQL Prompt Integrations - [Microsoft SQL Server](https://www.g2.com/products/microsoft-sql-server/reviews) ## SQL Prompt Features **Management ** - Data Schema - Query Language - ACID - Complaint - Data Replication **Support ** - Text Search - Data Types - Languages - Operating Systems **Security** - Database Locking - Access Control - Encryption - Authentication **Performance ** - Disaster Recovery - Data Concurrency - Workload Management - Advanced Indexing - Query Optimizer **Database Features** - Storage - Availability - Stability - Scalability - Security - Data Manipulation - Query Language ## Top SQL Prompt Alternatives - [Microsoft SQL Server](https://www.g2.com/products/microsoft-sql-server/reviews) - 4.4/5.0 (2,118 reviews) - [PostgreSQL](https://www.g2.com/products/postgresql/reviews) - 4.4/5.0 (645 reviews) - [MySQL](https://www.g2.com/products/mysql/reviews) - 4.4/5.0 (1,576 reviews)