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.

SQL Prompt AI comes with many useful features, including the generation of SQL using context information from the provided schema, and is powerful enough to utilize more complex SQL, such as joins, indexing, and subqueries, enabling it to empower anyone's SQL skills, from a beginner to a high end user.

These features are available for anyone who has an active subscription license of SQL Prompt, either standalone or through a bundle. These features are not available to users with a perpetual license.

Our 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

If you need any help or have any questions, explore our AI FAQ or EULA (as well as Redgate products subscription based terms, section 8.3).