Open-source Laravel package flags missing, unused and duplicate MySQL indexes without writing to the database
Laravel MySQL Advisor is a read-only health tool for MySQL or MariaDB databases used by Laravel apps. It reports unused, duplicate and missing indexes, full table scans, N+1 query patterns and server pressure, along with the SQL or migration needed to fix each issue. Each finding carries a severity level of critical, warning or notice, plus the underlying numbers and a suggested fix. Unused-index removal is recommended in two steps, hiding the index first and then dropping it, and the dashboard stays locked outside local environments until an access gate is defined. The package requires PHP 8.3 or later, Laravel 12 or 13, and MySQL 8.0 or MariaDB 10.6 or later, and is released under the MIT license.
This is an AI-generated summary. ShortSingh links to the original source for the complete article.


Discussion (0)
Log in to join the discussion and vote.
Log in