Writing SQL code by hand, even with IntelliSense, is frankly pretty dull. So we made SQL Prompt, which isn't. 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.

Autocomplete does the work for you even for JOINs
As well as making the most common queries, such as SELECTs and INSERTs, quick to write, SQL Prompt 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, even easier coding.

Save and recover lost tabs in SSMS
With tab history, you can save, preview, and rename tabs and restore tabs previously opened in SSMS. Letting you pick up work where you left off and start coding again in seconds.

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's single-click, customizable code reformatting.

Eliminate invalid objects
Keep your databases tidy and reliable with a complete list of any invalid objects, and unused variables and parameters. To fix them, you can script objects as ALTER directly from queries.

New: Actions list
Wrap your code in a block, toggle comments, and more with SQL Prompt's new Ctrl-key actions list.