votemike/dbhelper

Suggestions for database improvements

DB Helper

Add this package to your Laravel installation and visit /dbhelper in your browser to see suggested table schema changes. It can show you columns that are too big, but also columns that are coming up to their limit.
FOR LOCAL USE ONLY. DO NOT USE THIS IN PRODUCTION. There is no protection on the root, so people would be able to spy on your database structure.
This package does not support signed integers yet. Please use GitHub to raise any issues and suggest any improvements., _(*1)

Install

Via Composer, _(*2)

bash $ composer require votemike/dbhelper --dev, _(*3)

Then add Votemike\Dbhelper\DbhelperServiceProvider::class to your 'providers' array in config/app.php, _(*4)

Usage

Visit /dbhelper in your browser to see a list of suggested improvements, _(*5)

Future Improvements

• Refactor
• Split Numeric and Textual Column types
• Suggest missing indexes/foreign keys

Credits

• Michael Gwynne

License

The MIT License (MIT). Please see License File for more information., _(*6)