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

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

Contact us to get access to this AI powered tool that will save you unnecessary Extended Support Costs!