Kellyn Gorman

18 September 2025

From Productivity to Performance: SQL Prompt’s Next Chapter with AI

For nearly 20 years, SQL Prompt has been a trusted companion for database professionals, helping them write cleaner code, reduce errors, and save time. From its earliest days, the focus has been on productivity while removing the repetitive, mundane tasks that slow people down. It’s been about building the reliability and performance that developers and DBAs depend on every day and that story doesn’t stop here. Just as the database world has evolved, now expanding from on-premises servers to cloud platforms and hybrid environments, SQL Prompt continues to evolve too, with the next chapter being AI.

AI You Can Trust

We know “AI” is everywhere right now, and for good reason. Done right, it has the power to accelerate workflows, improve understanding and surface insights in ways that would have been impossible just a few years ago. But in the database space, we also know trust matters above everything else. That’s why SQL Prompt’s new AI features are designed to complement vs. replace your expertise.

• You stay in control: AI features are always opt-in, so you choose when and how to use them.
• Transparency is built in: explanations and code generation come with context, so you can validate every recommendation.
• Productivity is the goal: the same legacy of reliable, performance-focused tooling now benefits from the right kind of AI support.

As Gartner recently noted, “By 2026, 80% of development tools will include AI-powered assistance.” That statistic reflects an undeniable industry shift, but our priority is making sure AI works for you, in the flow of your work, without getting in the way.

Meeting AI Where You Need It

We’ve deliberately focused on scenarios where AI delivers the most value to SQL Prompt users:

• Understanding legacy queries faster

With SQL Prompt’s Explain SQL, you can highlight SQL and get an instant translation of what the code does in everyday language.  

• Spotting optimization opportunities

Powered by Redgate’s machine learning model, Query Index Analysis evaluates the potential impact of different indexes and provides recommendations for improvement.

• Suggesting clear, reliable code patterns 

With Text-to-SQL, you can write and refine code in natural language. AI-generated suggestions integrate with SQL Prompt’s formatting, refactoring, and code analysis to keep your code clean and reliable. To give you a helping hand with using natural language in SSMS, Intelligent Suggestions analyzes your SQL and offers contextual prompts.

In short, we’re giving you an extra set of eyes (powered by AI) so you can focus on solving bigger problems with confidence.

Continuity and Innovation

The introduction of AI into SQL Prompt isn’t a departure from its legacy; it’s the natural continuation of it. For decades, our mission has been to help database professionals work smarter and faster, without adding risk. Today, AI is simply another tool in that journey. It’s an enhancement that aligns with the same values SQL Prompt has always stood for: productivity, reliability, and performance.

How to Access

SQL Prompt’s AI features are included in active subscriptions to SQL Prompt and SQL Toolbelt Essentials. You just need to download the latest version and follow the instructions here to enable Prompt AI. If you’ve got any questions, check out the FAQs.

If you don’t have an active subscription, you can download a 14 day free trial to take SQL Prompt for a spin.

Learn More at PASS Summit

We’re excited to share this next chapter with you. If you’ll be at PASS Summit, join us to see how SQL Prompt’s AI features work in practice, learn why we’ve built them the way we have, and hear how we’re shaping the future of productivity for database professionals. It’s the perfect opportunity to see for yourself how SQL Prompt is evolving, bringing AI into your workflow, all on your terms, while continuing its legacy of trust.