QueryLens – Database Upgrade Intelligence
Client: Trilogy / Crossover
An AI-powered database upgrade assistant that helps organizations safely migrate MySQL and PostgreSQL databases by analyzing query compatibility, protecting data privacy, and providing a clear migration path.
Overview
QueryLens is a sub-product of CloudFix that helps organizations avoid expensive AWS RDS extended support charges by safely upgrading their MySQL and PostgreSQL databases. It uses AI-powered analysis to identify compatibility issues before they impact production, analyzing query patterns while keeping all data within the customer's AWS environment.
My Role
Designed and built the entire UI/UX from scratch, creating a highly intuitive interface with an innovative navigation pattern. Also contributed to backend development alongside the team.
- Architected and implemented the full frontend application from the ground up
- Created an intuitive, interactive UI for navigating complex database compatibility reports
- Designed clear data visualization for query analysis results (e.g., compatibility percentages, issue breakdowns)
- Collaborated with the backend team on API design and integration
Technical Highlights
- Built-in data obfuscation that automatically removes sensitive values from queries
- All query analysis runs within the customer's AWS account — no data leaves their environment
- Supports MySQL 5.7 → 8.0, PostgreSQL version upgrades, and Aurora transitions
- Automated deployment via CloudFormation stacks
- Identifies specific breaking changes like deprecated system variables, performance schema changes, and syntax updates
Impact
- Enables organizations to confidently plan database upgrades with detailed compatibility reports showing exact query-level issues
- Removes the fear factor from major database version migrations by surfacing breaking changes before they reach production