A laravel package that adds commands for getting table / column info into artisan cli.

Before install

• This package works on mysql only.

Installation

You can install the package via composer:

$ composer require laratoolbox/database-viewer

Usage

• Get tables

$ php artisan db:tables

failed_jobs
migrations
password_resets
users

• Get columns for a specific table

$ php artisan db:columns --table=users

id
name
email
email_verified_at
password
remember_token
created_at
updated_at

• Get columns for a specific table as doc block formatted

$ php artisan db:columns-doc --table=users

/**
 * @property int $id
 * @property string $name
 * @property string $email
 * @property string|\Illuminate\Support\Carbon $email_verified_at
 * @property string $password
 * @property string $remember_token
 * @property string|\Illuminate\Support\Carbon $created_at
 * @property string|\Illuminate\Support\Carbon $updated_at
 */

Testing

// TODO:

Changelog

Please see CHANGELOG for more information what has changed recently.

Contributing

Please see CONTRIBUTING for details.

Security

If you discover any security related issues, please email [email protected] instead of using the issue tracker.

Credits

• Semih ERDOGAN
• Dincer DEMIRCIOGLU
• All contributors
• The social image generated with banners.beyondco.de.
• This package was generated using the Laravel Package Boilerplate.

License

The MIT License (MIT). Please see License File for more information.