Redgate Assistant is an AI chatbot designed to help with database development tasks. Integrated directly into SSMS, it provides assistance in writing T-SQL queries, leveraging the functionality of SQL Prompt to provide a rich, chat-driven development experience. Redgate Assistant also integrates with other Redgate products, powering new workflows from a single interface. 

For more information on how your data is handled, visit the SQL Prompt AI data handling page.

How to enable Redgate Assistant

1. Navigate to the SQL Prompt Options menu
2. Tick the checkbox for Enable SQL Prompt AI (this setting is required to enable all AI features in SQL Prompt)
3. Tick the checkbox for Enable Redgate Assistant at the bottom of the page

Redgate Assistant is an opt-in feature, and can be disabled via the settings menu. Organizations may also restrict access centrally if required. See our SQL Prompt AI FAQ on full instructions on how to do this.

Working with Redgate Assistant

To work with Redgate Assistant, first you need to open the Redgate Assistant window. You can either:

• Use the Alt + A  key bind
• Select the Toggle Redgate Assistant (Preview) Option from the SQL Prompt Options menu

Once you have the Redgate Assistant window open, you will be presented with the following screen.

At the bottom of the window a text box where you can ask your questions. Redgate Assistant is not limited to English - you can use any language you like in your conversations.

What can you do with Redgate Assistant?

Redgate Assistant is a general-purpose chatbot designed to help with all aspects of database development. As such, it's capable of performing many tasks.

You might ask Redgate Assistant to:

• Perform a code review on one of your queries
• Write a new query from scratch based on your requirements
• Give advice on how best to create an index for a table

Redgate Assistant works off the your active query editor window. It can see the SQL in the editor, and can gather information about the database it's connected to.