php artisan db:show — Laravel 11.x

db:show

Display information about the given database

Terminal

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

countsOptional

Show the table row count Note: This can be slow on large databases

databaseOptional

The database connection

jsonOptional

Output the database information as JSON

typesOptional

Show the user defined types

viewsOptional

Show the database views Note: This can be slow on large databases