What is Redgate SQL Prompt?

Redgate SQL Prompt is a tool used to write, format, analyze and refactor SQL. It features advanced IntelliSense-style code completion, a code snippet library, code analysis, SSMS SQL History, and a command palette to speed workflows. It is available standalone for an annual license, or as part of Redgate's flagship SQL Toolbelt Essentials.

Verified User

Professional in Information Technology (51-200 employees employees)

Use Cases and Deployment Scope

I use this product daily to help me on my sql server. It's very useful in keeping our test data separate from production data by letting me know what system i'm currently working in. It also helps me find tables and joins quickly, even if i know the database. Couldn't see myself without this product.

Pros

Color code tabs based on connected server
Find joins easily
Find tables easily
code suggestions
Format sql

Cons

maybe licensing. I believe they went to a subscription based license and you have to renew each year. Would like it if you purchased it and paid for maintenance

Return on Investment

It speeds up writing queries and finding relationships in the db.
It helps with keeping connections separate when dealing with multiple servers

Usability

Other Software Used

Microsoft Visual Studio

Redgate SQL Prompt