QueryLens

QueryLens helps you avoid expensive RDS extended support charges by safely upgrading your MySQL and PostgreSQL databases. Our AI-powered analysis helps you understand and address compatibility issues before they become problems.

The Problem

AWS charges significant fees for extended RDS support after version end-of-life
Organizations delay upgrades due to fear of breaking critical SQL queries
Manual query review is time-consuming and error-prone
Privacy concerns make it hard to get expert help with upgrades

How QueryLens Helps

Automated Query Analysis
- Captures existing RDS query patterns
- Obfuscates sensitive data automatically
- Evaluates compatibility with target versions
- Identifies breaking changes before they impact production
Smart Privacy Protection
- All query analysis happens in your AWS account
- Built-in data obfuscation removes sensitive values
- No query data leaves your environment
- Secure by design
Clear Migration Path
- Shows exact compatibility percentage
- Lists specific queries needing updates
- Explains why changes are needed
- Provides suggested query modifications

Supported Upgrades

MySQL 5.7 to MySQL 8.0
PostgreSQL upgrades to current versions
Aurora version transitions
Additional database engines coming soon

Example Findings

Total Queries Analyzed: 603
Compatible: 98.84%
Needs Updates: 1.16%

QueryLens identifies specific issues like:

Deprecated system variables (e.g., tx_isolation → transaction_isolation)
Performance schema compatibility changes
Syntax updates between versions

Getting Started

Deploy our CloudFormation stack in your AWS account
Select databases for analysis
Get detailed compatibility reports
Plan your upgrade with confidence