Built a MySQL performance dashboard for Rails because nothing like PgHero existed for MySQL.

Core Features

• Visual query builder with type-aware filters
• Safe SQL execution (read-only, blocked tables, column masking, timeouts)
• Table sizes, duplicate indexes, unused indexes, query stats
• Server dashboard (connections, InnoDB buffer pool, query activity)
• Slow query monitoring via Redis

Optional AI Features (any OpenAI-compatible API)

• Natural language to SQL
• EXPLAIN to index recommendations
• Schema review for anti-patterns
• Migration risk assessment

Setup

gem "mysql_genius"
mount MysqlGenius::Engine, at: "/mysql_genius"

Rails 5.2+, Ruby 2.6+, MariaDB auto-detected.

GitHub: https://github.com/antarr/mysql_genius