php artisan db:show - Laravel 9.x - The Laravel Artisan Cheatsheet

db:show

Display information about the given database

Terminal

php artisan db:show [--database [DATABASE]] [--json] [--counts] [--views]

countsOptional

Show the table row count <bg=red;options=bold> Note: This can be slow on large databases </>

databaseOptional

The database connection

jsonOptional

Output the database information as JSON

viewsOptional

Show the database views <bg=red;options=bold> Note: This can be slow on large databases </>