Redgate Assistant is an AI chatbot with T-SQL expertise designed to help with database development tasks. Redgate Assistant is in preview mode and disabled by default, see How to enable Redgate Assistant to enable it. 

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. 

Screenshots in this page were taken with SQL Prompt version 11.4.2.26116 and Redgate Assistant v0.11.2-preview.

How to enable Redgate Assistant

Prerequisites

1. You will need a SQL Prompt subscription license (or a SQL Toolbelt Essentials or SQL Toolbelt license one). Perpetual licenses are excluded.
   1. You may have to re-login to Redgate licensing if upgrading from an older version as explained in the note at the top of this document.
2. Redgate Assistant makes all AI requests to *.redgate-platform.com and *.ai.redgate.cloud.
   1. If your organization enforces it, you will need to set these subdomains in your firewall rules and allow lists to enable Redgate Assistant in SQL Prompt.
   2. Please check our AI in SQL Prompt FAQ for further details.
3. If you have created a Redgate organization before, ensure you have opted-in to use AI features in Redgate portal.
   1. To find out more about the Redgate organization authentication, refer to Creating a Redgate Organization.

Configuring SQL Prompt for Redgate Assistant

Redgate Assistant is an opt-in feature, and can be enabled/disabled via the SQL Prompt options or main menu:

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

Alternatively, you can enable/disable AI functionality and Redgate Assistant directly from the main menu in SSMS:

Data handling

Visit the SQL Prompt AI data handling page and Redgate AI trust hub to see how your data is handled in Redgate Assistant.

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 is 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.

Your conversation persists between IDE sessions, so you can resume your earlier inquiries after restarting SSMS.

If you wish to start a new conversation with a fresh context, please click the New chat button in the top-right corner:

Supported IDE versions

Redgate Assistant is available in all supported SQL Server Management Studio versions (SSMS18+).

Visual Studio is not supported.

What can you do with Redgate Assistant?

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

Additionally, it's enhanced with SQL Prompt functionality to further refine its skillset and capabilities.

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.
• Ask to explain how a certain script works.
• Fix errors in a given query.
• Optimize T-SQL for performance and effectiveness.

How does Redgate Assistant integrate with SQL Prompt?

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

SQL Prompt offers many tools and skills to perform various operations and refactorings, such as:

• Get the entire script or the active selection from the active query editor window.
• Obtain a list of T-SQL execution errors.
• Obtain a list of CodeSense (IntelliSense) T-SQL errors.
• Fetch database information, including schema details about DB objects (e.g. tables, views, stored procedures).
• Construct query execution plans to enable query optimization.
• Format the current T-SQL with your active formatting style.

As mentioned below in What's new in Redgate Assistant?, the list of features and tools will be constantly expanded. Keep checking this space for future developments.

Connections with other Redgate tools

Redgate Assistant is a shared Redgate tool that integrates with several products in addition to SQL Prompt (e.g. Redgate Monitor). 

This enables you to leverage the power of your entire Redgate portfolio within the same Redgate Assistant conversation.

You can check what is being used in your current chat session by clicking the Connectors button in your chat box:

Usage limits

As mentioned in the prerequisites section above, there are no additional costs when using Redgate Assistant if you are already on a SQL Prompt subscription license.

Fair usage limits are in play, but they are quite generous during the preview stage, and you will be notified in the UI if they are hit. You'll then just need to wait for a bit before trying again.

Feedback

We would love to hear your feedback on Redgate Assistant.

Let us know what is working well, what could be improved, and what you'd like to see next.

1. Take the survey to let us know how it's working out for you.
2. Suggest AI improvements and new features in our SQL Prompt UserVoice.

What's new in Redgate Assistant?

There are two ways Redgate Assistant receives updates to its functionality:

• Updates to the client side of Redgate Assistant (e.g. SQL Prompt MCP tools, integration with SSMS, etc.) will be provided in regular SQL Prompt updates and can be checked in our release notes.
• Updates to the server side of Redgate Assistant (e.g. chat UI, LLM models, skills, etc) are done regularly and don't typically require SQL Prompt itself to be updated. You can find the changelog in the AI trust hub.

As this tool is in preview state, it will be receiving regular updates. Check back often.