As a MySQL consultant, I keep running into the same two problems: reviewing MySQL configurations and generating realistic test data for validation. So I built two focused MySQL tools to simplify exactly this.
Watch out in “Tools” menu for more tools.
MySQL Advisor – Analyze. Diagnose. Optimize.
🔗 https://nitty-witty.com/mysql-advisor/
Where it fits:
quick health checks
config reviews
performance tuning starting point
standardizing analysis across environments
MySQL Random Data Generator
🔗 https://nitty-witty.com/mysql-random-data-generator/
This is simplest ever random data generator in my experience and it simply works. Generates schema-aware test data with almost no setup.
Where it fits:
performance testing
query optimization validation
staging setup
reproducing production scenarios
Conclusion
These two MySQL tools are built to simplify common DBA workflows. MySQL Advisor helps with MySQL performance tuning by turning raw metrics into actionable recommendations, reducing the time spent interpreting status / config outputs. MySQL Random Data Generator makes it easy to generate test data in MySQL, enabling realistic datasets for query optimization and performance testing without heavy setup.
Both tools are actively being developed and improved. If you try them out, I’d really appreciate your feedback… what works, what doesn’t, and what you’d like to see next.