cradle-sql

Execute a SQL query

$ cradle sql "[SELECT * FROM users]"

$ cradle sql --file [queries.sql]

$ cradle sql --connection [mysql] "[query]"

$ cradle sql --export [table_name] > [backup.sql]

$ cradle sql --import [backup.sql]

$ cradle sql "SHOW TABLES"

cradle sql [options] [query]

cradle sql provides direct SQL access to databases configured in the Cradle framework. It allows executing queries, importing/exporting data, and performing database operations without needing a separate client.
The command uses the framework's database configuration, supporting multiple connections defined in the application settings. Results can be output in various formats suitable for display or processing by other tools.
This tool is useful for debugging, data inspection, and quick database operations during development. It maintains consistent authentication and connection handling with the rest of the Cradle application.

QUERY

SQL query to execute. Wrap in quotes.

Execute SQL commands from a file.

Use a specific database connection.

Export table data as SQL statements.

Import SQL file into the database.

Override the default database.

Output format: table, json, csv.

Display help information.

Direct SQL access bypasses application-level validations. Destructive queries (DROP, DELETE, TRUNCATE) execute without confirmation unless the framework adds safeguards. Always backup data before running potentially destructive operations.

cradle sql was developed as part of the Cradle PHP framework's CLI tools to provide convenient database access. It follows the pattern of framework-integrated database commands found in other PHP frameworks like Laravel's Artisan.

cradle(1), mysql(1), psql(1), sqlite3(1)