SQL Prompt’s AI-powered features help you to write, review, and optimize SQL faster by combining its understanding of your database schema and SQL expertise, with the power of generative AI and machine learning.  Write and modify SQL accurately using natural language, get clear explanations of unfamiliar code, and uncover performance-boosting index suggestions in seconds — all without leaving SSMS. The AI-powered features are opt-in to give you control over how and when you adopt AI into your workflow.

We have two AI-powered features in SQL Prompt: SQL Prompt AI and Query Index Analysis.

SQL Prompt AI uses public AI models and provides the following functionality:

• Natural language AI prompts (Text-to-SQL) - Write and modify SQL using natural language. SQL Prompt AI transforms your words into schema-aware AI requests that will create a response from our Prompt AI services that will be directly inserted into your SSMS query window. Modifying SQL is easy too, just highlight your code and instruct SQL Prompt to change it using natural language in your query window. AI responses will work with SQL Prompt’s formatting, refactoring and code analysis features to ensure code is consistent and accurate. 
• Explain SQL - Make sense of legacy code, complex logic, or someone else’s work fast. With SQL Prompt’s Explain SQL feature you can highlight your chosen SQL and get an instant translation of what the code does in everyday language.

• Intelligent context-aware suggestions -  Prompt AI offers two types of contextual-aware suggestions to help you form your AI prompts:
  • Initial personalized suggestions - If Generate initial suggestions using SQL History option is enabled, SQL Prompt AI will create context-aware suggestions based on randomly selected recent SQL queries from SQL History.
  • Follow-up suggestions - These are automatically generated in the Prompt AI window after you first AI prompt is processed and provide contextual-aware potential continuations to your previous AI prompts (e.g. introduce additional filters on a SELECT statement).

Please see working with SQL Prompt AI for more details on existing functionality.

Query Index Analysis uses an internal Redgate LLM and offers the following functionality:

• Improve SQL query performance - Get clear, actionable advice on what indexes you need to improve query performance. Powered by Redgate’s machine learning model, Query Index Analysis evaluates the potential impact of different indexes and delivers smart recommendations for improvement.  

SQL Prompt AI features are powered by three different public AI models in combination to provide the best possible outcome. These are all hosted on Redgate’s Amazon Bedrock server.   

• Claude-3-7-Sonnet 
• Cohere.Embed-multilingual-v3 
• Amazon.nova-lite-v1:0

Query Index Analysis uses an internal Redgate LLM.

• Built into SQL Prompt: the industry-leading SQL code completion tool - For nearly 20 years, SQL Prompt has been a favorite among database professionals, thanks to its ability to make SQL coding faster, easier, and error-free from day one. The new AI-powered capabilities join a range of productivity-enhancing features — such as smart code completion, reusable code snippets, instant formatting, refactoring and code analysis — all grounded in SQL best practices and a deep understanding of your database schema.  
  • These new features are designed to work with other functionality within SQL Prompt to deliver accurate, context-aware results that speed up your coding. For example, before presenting AI-generated suggestions, SQL Prompt ensures they match your existing formatting style. Its built-in code analysis and auto-fix functionality also help resolve errors and ensure code follows best practices.  

• No extra cost or set-up - SQL Prompt’s AI-powered features are included in an active subscription to SQL Prompt and SQL Toolbelt Essentials. No extra costs or set up required. All you need to do is opt-in to use them.  

• Intelligent context-aware suggestions - As with any new feature, getting confident with using AI takes practice and trial and error. SQL Prompt’s initial personalized and follow-up suggestions (see working with SQL Prompt AI) give you a helping hand by analyzing your SQL and providing contextual, clickable prompts in the Prompt AI window to guide you on what to ask. 

• Query Index Analysis - Powered by Redgate’s machine learning model, Query Index Analysis evaluates the potential impact of different indexes and delivers smart recommendations for improvement. The result? Code that is optimized for speed from the start. 

• Underpinned by over 25 years of SQL Server expertise - The new AI-powered capabilities are backed by Redgate’s over 25 years' experience with SQL Server. 

The functionality available in the Prompt+ Early Access Program is now part of the new AI features available in SQL Prompt.  

SQL Prompt’s AI-powered features are available in version 11.1.0.18267 onwards with an active subscription to SQL Prompt, SQL Toolbelt Essentials or SQL Toolbelt. Once you have this version installed, you will be able to opt-in to the Prompt AI features by following instructions in enabling/disabling SQL Prompt AI. 

To access the features, simply highlight some SQL in your query window and right click to show the SQL Prompt context menu. Then select any of the following: Open Prompt AI, Explain Selected SQL or Analyze Query Indices.

You can also open the Prompt AI window using the shortcut ALT+Z or the Prompt AI icon in the SQL query window if the option Show icon for editor selection is enabled. See working with SQL Prompt AI for more information.

Your machine needs access to the internet in order for this service to run.  

SQL Prompt AI makes all AI requests to *.redgate-platform.com, a set of server-side services shared with Redgate platform (e.g. shared snippets and formatting styles).

If your organization enforces it, you willl need to set this subdomain in your firewall rules and allow lists to enable Prompt AI features.

We’d love to hear your thoughts on SQL Prompt’s AI-powered features. You can share any feedback by filling in our AI Features survey or by simply dropping us an email at sqlprompt-feedback@red-gate.com.

Keep an eye on our roadmap for a preview of what’s next for SQL Prompt. If you’ve got any requests, please add them to SQL Prompt’s User Voice. 

SQL Prompt’s AI-powered features are opt-in and are disabled by default. If you previously opted in and now want to disable them, please follow the steps in enabling/disabling SQL Prompt AI. 

If you wish to restrict access to these features across your organization, you can set up a block list. Please email support@red-gate.com to request this. 

Prompt AI has a fair usage rate limit in place of approximately 10 prompts every 5 minutes. Once this limit is reached, users will see a message notifying them that they’ve hit the cap. 

If you find yourself reaching this limit frequently, we’d love to hear your feedback. Please email us at sqlprompt-feedback@red-gate.com.

Please check SQL Prompt AI data handling.

We use AWS Bedrock to help us provide SQL Prompt’s AI-powered features. They are hosted in Frankfurt, London, Ireland, and Paris.

Redgate takes security seriously, both in developing our products, and operating our business. Our Information Security Management System is ISO/IEC 27001:2022 certified.

You can find out more information about our security practices here, and view our product security policy here.