Write, format, analyze, and refactor your SQL effortlessly

Supercharge productivity with features to increase coding speed and accuracy. SQL Prompt helps you to double coding speed with IntelliSense-style code completion, one-click SQL formatting, customizable code snippets, SQL query history, and more. As well as saving you hours of effort, SQL Prompt reduces errors by analyzing code as-you-type, auto-fixing issues, safely refactoring SQL, and simplifying standardization.

Key features for SSMS and Visual Studio

Try formatting your own SQL code below

Use predefined styles, or create and share your own with the full formatting options in SQL Prompt.

IntelliSense-style code completion

SQL Prompt’s smart code completion works as-you-type, providing suggestions to help you write SQL 50% faster.

Customizable code snippets

Accelerate coding by saving frequently used SQL into your customizable code snippet library. Share snippets with your team to further improve efficiency and consistency.

Command Palette

Quickly navigate SQL Prompt and SSMS functionality via a single keyboard shortcut.

SQL History (SSMS only)

Search and recover your work with a full history of all queries you write in SSMS.

Tab colouring (SSMS only)

See at-a-glance what environment you’re working in within SSMS by setting different colours for your groups, servers and databases.

Code analysis

Discover code issues as-you-type with SQL Prompt’s built in rules. Customize the rules to only apply those you find useful and share these settings with your team to encourage code consistency.

Auto-fixes

Once SQL Prompt’s code analysis has highlighted problematic code, you can apply an auto-fix to quickly bring your code up to standard.

Safely rename objects in your script

You can use SQL Prompt to rename all occurrences of a variable or alias in a query.

Smart rename (SSMS only)

Within SSMS, you can create a script that allows you to rename objects in your database without breaking dependencies.

Encapsulate SQL as a new stored procedure

Create a new stored procedure from any block of valid SQL.

Split a table in your database

With SQL Prompt, you can split a table in your database into two tables. This is useful if you want to normalize a database, improve database performance, or change the database design.