Database Commands

Database Commands

Database commands provides tooling to manage and inspect your databases.

Command Reference Table

CommandDescription
cycle:db:listGet list of available databases, their tables and records count.
cycle:db:tableDescribe table schema of specific database

Listing Databases

cycle:db:list

This command provides a comprehensive list of all databases, along with their tables and the count of records in each table.

Usage

php artisan cycle:db:list

Example

Listing Databases

Describing Table Schema

cycle:db:table

To get detailed information about the schema of a specific table, use the cycle:db:table command. This includes column names, types, and other relevant metadata.

Usage

php artisan cycle:db:table your_table_name

Options

--d|database: The name of the database to use. If not provided, the default database will be used.

Example

Listing Table Contents