Security and compliance
Ensure data security and compliance with monitoring and change traceability
Add-in for SQL Server Management Studio & Visual Studio
The fast and easy way to write, format and debug SQL
SQL Prompt is Redgate's SQL code completion and formatting add-in for SQL Server Management Studio and Visual Studio - the original SQL autocomplete tool, used by the SQL Server community for nearly 20 years. It adds context-aware IntelliSense-style completion, one-shortcut formatting to shared team styles, code analysis with auto-fixes, refactoring, and optional AI-powered assistance for writing and explaining queries - all without leaving SSMS. Users report writing SQL up to 50% faster. SQL Prompt is included in SQL Toolbelt Essentials.
Writing SQL can be time-consuming, repetitive and frankly dull. SQL Prompt changes that. It works alongside you to make your SQL coding fast, accurate and effortless, whether your SQL Server databases are on-premises, in the cloud, or both.
SQL Prompt enhances SSMS and Visual Studio by automatically completing, analyzing and fixing your code, as well as taking care of formatting, refactoring, and query history. Best of all, it’s ingeniously simple to use, so you can get started in minutes.
Download free trial1 Year Subscription
Save time and effort writing SQL
Write SQL up to 50% faster and win time back in your day. SQL Prompt speeds up coding by auto-completing your code with valid, context-aware suggestions. Say goodbye to repetitive typing with customizable code snippets and comprehensive query history.
Improve code quality as-you-type
Avoid last-minute rework by writing error-free code by default. Smart code completion reduces syntax errors, while real-time code analysis and auto-fixes debugs code. Tab coloring helps keep your changes in the right environment, and refactoring helps you to confidently optimize your queries, code objects and databases.
Keep code consistent without breaking a sweat
With SQL Prompt, you don’t have to worry about structuring your code as you write it. Simply write SQL your own way and use a shortcut to format your code into a team standard instantly. Same applies for reformatting legacy code, just press CTRL+K+Y to improve readability.
AI-enhanced coding, on your terms
SQL Prompt includes optional AI-powered features designed to support your workflow. Write or modify queries using natural language, get clear explanations for unfamiliar code, and fix and optimize SQL with ease—all without leaving SSMS.
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.
Styles
or press Ctrl+Enter
Format SQL in seconds
Effortlessly format your code to match your team's style, or update legacy code for better readability, with just one click or a simple keyboard shortcut (CTRL+K+Y).
Customize your formatting
Advanced options allow you to fine-tune your formatting styles to get them exactly how you like them, and you can even share them with your team to keep code consistent.
Try the free online formatter
Bookmark our online SQL formatter for access to SQL Prompt's formatting on any device.
SQL Prompt users say
Over 200,000 people rely on Redgate to deliver ingeniously simple software.
The essential tool for serious SQL Server database development. Don't use SSMS without it.
I use SQL Prompt constantly. I refuse to work without it. It has become so engrained in muscle memory. Snippets save me so much time. My favorite thing is how it enforces consistency, such that I can take any SQL code written by anyone and format it to be clean and understandable instantly.
Read full reviewGreat tool for all SQL Developers
I have used SQL Prompt for day-to-day development work in my office. It has been a great experience and a good tool for all the developers. It offers great features like query formatter and code standardization.
Read full reviewI refuse to work on SQL Server without SQL Prompt installed
SQL Prompt makes my work much easier. I spend a lot less time typing, looking up tables/columns, or performing standard queries. I get so much more done - I can't imagine doing SQL coding without it.
Read full reviewSQL Prompt Feels Like an Out-Of-The-Box Product
SQL Prompt provides an important set of time-saving features that integrate so well, you would think they should come out of the box with SSMS.
Read full reviewThe product every SQL developer must have!
SQL Prompt is a MUST HAVE for an SQL Developer. The amount of time saved from its many capabilities is amazing...
Read full reviewSQL Prompt is a game changer
SQL prompt has been a real time-saver and really helps me write more efficiently
Read full review
SQL Prompt is Pretty Much a Necessity for SQL Server
Not only does it make it faster/easier to write code, it is also great for exploring/understanding new data sets.
Read full reviewEverything SSMS Should Have Been OOTB
I use SQL prompt every day as it slices the amount of development time for tasks… I'm also a stickler for clean and concise code, and SQL Prompt really helps in that endeavour.
Read full reviewCoding without it is like wearing handcuffs!
The ease of use and speed at which you can write code is exponentially faster. I'll never NOT use it.
Read full reviewI won't work without it
When I changed organizations and lost access to SQL Prompt, I immediately decided to purchase it myself.
Read full reviewGartner and Peer Insights™ are trademarks of Gartner, Inc. and/or its affiliates.
All rights reserved.Gartner Peer Insights content consists of the opinions of individual end users based on their own experiences, and should not be construed as statements of fact, nor do they represent the views of Gartner or its affiliates. Gartner does not endorse any vendor, product or service depicted in this content nor makes any warranties, expressed or implied, with respect to this content, about its accuracy or completeness, including any warranties of merchantability or fitness for a particular purpose.
SQL Prompt
$210 per user, per year
Double coding speed and improve the accuracy of your SQL code.
Includes:
- IntelliSense-style SQL code completion
- One-click, customizable SQL formatting
- SQL refactoring
- Customizable SQL snippets
- SQL code analysis and auto-fixes
- SSMS SQL history and tab colouring
- AI powered features: Text-to-SQL, Explain SQL, Intelligent Suggestions and Query Index Analysis
SQL Toolbelt Essentials
$1,410 per user, per year
Increase efficiency and code quality throughout your entire SQL Server database development cycle with 11 essential tools.
Includes SQL Prompt plus:
- Bulk formatting, code analysis and auto-fixes
- Team sharing of formatting styles and code snippets in SSMS via the Redgate Platform
Additional products
- SQL Source Control
- SQL Compare
- SQL Data Compare
- SQL Test
- SQL Data Generator
- SQL Doc
- SQL Dependency Tracker
- SQL Multi Script
- SQL Search
Supported SQL Server & Microsoft Data Platforms
SQL Server-based platforms
- SQL Server 2025, 2022, 2019, 2017, 2016, 2014
- SQL Server on Azure VM
- Amazon RDS for SQL Server & Virtual Machines
- Google Cloud SQL for SQL Server & Virtual Machines
Microsoft cloud data services
- Azure SQL Database
- Azure Synapse Dedicated & Serverless SQL Pools
- Microsoft Fabric (SQL endpoints)
Development environments
- SQL Server Management Studio 22, 21, 20, 19, 18, 2017
- Visual Studio 2026, 2022, 2019
Frequently Asked Questions
What does SQL Prompt add to SSMS?
SQL Prompt enhances SSMS and Visual Studio by automatically completing, analyzing and fixing your code, as well as taking care of formatting, refactoring, and query history. Best of all, it’s ingeniously simple to use, so you can get started in minutes.
Which SSMS and Visual Studio versions are supported?
SQL Prompt works in SQL Server Management Studio 22, 21, 20, 19, 18, 2017, and Visual Studio 2026, 2022, 2019.
Does SQL Prompt include AI features?
Our own AI chat Redgate Assistant (preview) is built into SSMS, is now in preview for SQL Prompt: ask it about your query or your database in plain language, and it fixes errors, optimizes queries, and explains SQL in your own style. It pulls in the context it needs on demand, so you get to the answer faster. AI features are opt‑in and available only in SSMS. AI‑generated code is context‑aware and integrates with SQL Prompt's formatting, refactoring, and code‑analysis rules so your SQL stays accurate and consistent.
Is SQL Prompt included in SQL Toolbelt Essentials?
SQL Prompt is included as part of SQL Toolbelt Essentials. When you get SQL Prompt as part of SQL Toolbelt Essentials, you’ll get even more from SQL Prompt with team sharing of formatting styles and snippets, bulk formatting and code analysis, and integrations with SQL Dependency Tracker and SQL Compare. Learn more about SQL Toolbelt Essentials.