Improve your productivity with advanced IntelliSense-style SQL code completion

Free for Visual Studio Enterprise

  • Code completion for T-SQL commands and keywords as you type
  • Intelligent suggestions for JOIN conditions
  • Autocomplete INSERT and EXEC statements
  • Quickly refactor SELECT statements
  • Included free in Visual Studio Enterprise

Get SQL Prompt Core

Learn how to get started with SQL Prompt Core

Only available in Visual Studio Enterprise 2017

SQL Prompt Core Free

Increase productivity with advanced, IntelliSense-style, SQL code completion in Visual Studio.

See what’s included

Available in Visual Studio and SQL Server Management Studio

SQL Prompt Pro $369

Write, format, share, and refactor your SQL effortlessly.
Try it free for 28 days.

Find out more

“SQL Prompt Core is more than autocomplete though – it provides a myriad of other quality of life improvements that come together to simplify writing SQL code”


Key features

Expand wildcards

Avoid bad practice by placing your cursor after the SELECT * and hit tab. This’ll replace the * with all the columns available in the table, so you can be selective about the data you return.

Select only the columns you need

Pick and choose the columns you want using the Column Picker. Start typing the column name after SELECT then pick the columns you need from the suggestions window.

Write JOINs in a few keystrokes

SQL Prompt Core automatically suggests possible JOIN conditions based on foreign key relationships or column similarities, as you type.


Compare editions

Code Completion features Core Edition Pro
Code completion for databases, system objects, keywords, T-SQL commands (e.g. SELECT), stored procedures, parameters, closing parentheses and brackets, aliases
Expand singular wildcards
Offer suggestions from linked servers
CamelCase and mid-string suggestions
Code highlighting (matching BEGIN and END, for example)
Suggestions for INSERT statements with column lists
Auto-complete EXEC statements with parameter lists
Highlight matching objects (context-aware)
Rename variables and aliases
Code Formatting features
One click code formatting
Create and share customized formatting styles
Insert semicolons
Productivity features
Built in snippets (SSF = SELECT * FROM, for example)
Create, share, and customize frequently used snippets
Code navigation
Explore table and function definitions from code
Find unused parameters and variables
Object information
Summarize script in one click
Safely split tables
Find invalid objects
Result Grid shortcuts: Copy as IN clause, Script as INSERT, Open in Excel
Execute current statement
Execution warnings for DELETE and UPDATE statements
Search and reopen tabs (in SSMS only)
Tab coloring (in SSMS only)
Smart Rename refactoring (in SSMS only)
Supported technologies
Visual Studio 2017 Enterprise edition
SQL Server 2016, 2014, 2012, 2008, 2008 R2
Azure SQL Database
SQL Server on Amazon RDS
Visual Studio 2015, 2013, 2012, 2010
SQL Server 2005, 2000
SQL Server Management Studio 2017, 2016, 2014, 2012
Azure SQL Data Warehouse Partial Partial
Analytics Platform System Partial Partial
Technical Support
Technical Support Community support via forums & documentation Full Redgate support
Free in Visual Studio Enterprise

Find out more about Pro

Only available in Visual Studio Enterprise 2017

SQL Prompt Core Free

Increase productivity with advanced, IntelliSense-style, SQL code completion in Visual Studio.

Get SQL Prompt Core

Available in Visual Studio and SQL Server Management Studio

SQL Prompt Pro $369

Write, format, share, and refactor your SQL effortlessly.
Try it free for 28 days.

Find out more