Security and compliance
Ensure data security and compliance with monitoring and change traceability
Redgate Assistant
AI that actually knows your databases
Redgate Assistant is available for Redgate Monitor and SQL Prompt subscription customers.
Redgate Assistant knows your schema and runs under your access controls
Most AI tools have never seen your database. They guess, then act on that guess without a safety net. Redgate Assistant works from your actual schemas, lives inside the tools you already use, and runs under the access controls your database already enforces.
Built database-first
Redgate Assistant is backed by more than 25 years of expertise in one thing: databases
Knows your actual database
Grounded in your schemas, tables, and stored procedures, not generic SQL knowledge pulled from unknown sources.
Built in, not bolted on
It surfaces directly inside the solutions database professionals already use, so there's no separate AI tool to manage.
Governed from the first response
It runs as its own auditable user, inheriting the access controls a database already has.
Tests fixes before they're applied
It autonomously investigates an issue and drafts a fix, then tests that fix against a safe copy of the database, so what lands in front of you has already been proven safe.
Backed by Redgate’s best practice
Common database tasks are guided by workflows that encode Redgate's best practice, so quality doesn't depend on who's asking.
Carries context across your tasks
Redgate Assistant follows the work between the Redgate solutions it's built into, so switching from one to another doesn't mean starting over.
One assistant, not five
Redgate Assistant carries context wherever the work happens, whether that's writing a query, investigating a performance issue, or landing on a database nobody documented.
Find and fix seamlessly
Redgate Assistant works across Redgate Monitor and SQL Prompt to help you see the status of your entire server estate and easily find and fix problems.
25 years of database expertise
Redgate has been solving database problems since 1999, for the organizations that can least afford to get them wrong, including 92% of the Fortune 100.
Governed by design
Redgate Assistant is built with strong guardrails around what it can do, so any changes get tested against a safe copy of your database before it's ever suggested. Every action runs through its own auditable user, giving full visibility, and nothing reaches production without someone approving it first.
27 hours a week back
Redgate Assistant is grounded in what's actually running rather than a generic explanation borrowed from somewhere else, no re-explaining the environment, no reverse-engineering someone else's decisions, no waiting on whoever still remembers how the system was built. According to Redgate's own research, database professionals lose an average of 27 hours a week to work like this.
Start using Redgate Assistant today
Redgate Assistant is available for Redgate Monitor and SQL Prompt subscription customers.
Redgate Assistant in Monitor
Available in Monitor v14.27 or later (In-preview)Ask a question. Get an answer.
Monitor already surfaces that something's wrong. Redgate Assistant explains why and what to do about it. Ask a question in plain language and it reasons over your actual Monitor data, with authored skills that bring expert-grade diagnosis to the harder problems.
- Ask what's wrong and get a diagnosis grounded in your actual metrics, queries, and waits
- Authored skills, built on 18 years of database monitoring expertise, available to your whole team
Redgate Assistant in SQL Prompt
Available in Prompt v11 or later (In-preview)Redgate Assistant lives in a dockable chat panel right inside SSMS. It already knows what's in the query editor, so there's no pasting a schema in every time, and no starting from zero in every new session. Talk through a SQL problem and get an answer in context.
- Generate SQL and bring it straight into the editor
- Ask what a table, procedure, or relationship actually does
- Pick a conversation back up without re-explaining it
What's next?
Redgate Assistant is built to grow, in two ways.
It grows in what it can do. Today it answers questions, helps identify issues, suggests fixes, and tests them inside Redgate Monitor and SQL Prompt. Over time it takes on more of the routine work on its own, always within the boundaries you set, and never pushing anything to production until a person signs off.
It also grows in where it works. It's coming to more of Redgate's solutions, starting with Flyway, so the same database expertise shows up wherever the work happens.
The direction stays the same either way: an assistant that does more of the database work, and earns more of your trust, one shipped capability at a time.
Keep updated
Get the latest about Redgate Assistant, product news, best practices, and training from our industry experts. Subscribe to the Redgate Update.