SQL Shell

Shopware CLI can connect to the project database using the connection details of the current environment (local, Docker, ...), so you don't need to know the host or credentials.

Interactive shell

Run without arguments to open an interactive SQL shell:

shopware-cli project sql

Type exit or press Ctrl+D to quit.

Running a single query

Pass the query as an argument:

shopware-cli project sql "SELECT id, tax_rate FROM tax"

Providing a script via stdin

A SQL script can also be provided via stdin:

shopware-cli project sql < script.sql

Output format

Use the --format flag to control the output format: table, tsv, or json.

shopware-cli project sql --format json "SELECT * FROM sales_channel" | jq

By default, the output is rendered as a table when stdout is a terminal, and as tsv otherwise.