What are operation reports?

Last updated: September 2, 2025

You can use Liquibase Secure to generate reports of the operations you perform on your database. These reports contain information about the status of your database and may help you resolve errors in your automation pipeline.

Different reports may include information about database drift, your database type and version, whether your database change occurred live or in a snapshot; object data about tables, views, functions, procedures, packages/package bodies, and triggers; and object relationships on constraints, indexes, and privileges.

Report types

Report type	Report description	Command	Liquibase versions
Checks Report	This checks report provides data about the execution of Liquibase Policy checks.	`checks run`	4.26.0+
Drift Report	The drift report shows the differences between two live databases or between a database and a snapshot from a previous point in time.	`diff`	4.25.0+
`diff-changelog`	4.25.1+
Update Report	The update report informs you of system, runtime, operation, and changeset information about your database deployments.	`update` `update-count` `update-one-changeset` `update-to-tag`	4.25.1+
`update-testing-rollback`	4.28.0+
Rollback Report	The rollback report informs you of system, runtime, operation, and changeset information about your database rollbacks.	`rollback` `rollback-count` `rollback-one-changeset` `rollback-one-update` `rollback-to-date`	4.27.0+

Parameters

Global parameters

Use these parameters to control the behavior of all operation reports.

CLI

Parameter	Type	Description	Requirement
`--reports-enabled=<true\|false>`	Boolean	Enables or disables all reports at the global level. Overridden by `--report-enabled` at the command level. Default: `true`.	Required (either this or `--report-enabled` )
`--reports-name=<string>`	String	Specifies the name of the report file at the global level. Overridden by `--report-name` at the command level. By default, Liquibase generates a new report file labeled with a timestamp (user's local time). If you set a custom name, Liquibase overwrites the existing file every time you generate a new report. Default: `report-<DD-Mon-YYYY-HHmmss>.html`.	Optional
`--reports-open=<true\|false>`	Boolean	Specifies whether to automatically open the report in your default browser at the global level. Overridden by `--report-open` at the command level. Default: `true`.	Optional
`--reports-path=<string>`	String	Specifies the file path to the report file at the global level. Overridden by `--report-path` at the command level. Default: `./`	Optional
`--reports-suppress-exception=<true\|false>`	Boolean	Liquibase 4.31.0+. Specifies whether to hide exceptions (which may contain SQL) from operation reports at the global level. Overridden by `--report-suppress-exception` at the command level. Default: `false`. However: If `--reports-suppress-exception` is not set and `--reports-suppress-sql=true` , Liquibase suppresses all SQL, including exception SQL. If `--reports-suppress-exception=false` and `--reports-suppress-sql=true` , Liquibase suppresses most SQL but shows exception SQL.	Optional
`--reports-suppress-sql=<true\|false>`	Boolean	Liquibase 4.31.0+. Specifies whether to hide changeset SQL in operation reports at the global level. Overridden by `--report-suppress-sql` at the command level. Default: `false`.	Optional

CLI

Parameter	Type	Description	Requirement
`--reports-enabled=<true\|false>`	Boolean	Enables or disables all reports at the global level. Overridden by `--report-enabled` at the command level. Default: `true`.	Required (either this or `--report-enabled` )
`--reports-name=<string>`	String	Specifies the name of the report file at the global level. Overridden by `--report-name` at the command level. By default, Liquibase generates a new report file labeled with a timestamp (user's local time). If you set a custom name, Liquibase overwrites the existing file every time you generate a new report. Default: `report-<DD-Mon-YYYY-HHmmss>.html`.	Optional
`--reports-open=<true\|false>`	Boolean	Specifies whether to automatically open the report in your default browser at the global level. Overridden by `--report-open` at the command level. Default: `true`.	Optional
`--reports-path=<string>`	String	Specifies the file path to the report file at the global level. Overridden by `--report-path` at the command level. Default: `./`	Optional
`--reports-suppress-exception=<true\|false>`	Boolean	Liquibase 4.31.0+. Specifies whether to hide exceptions (which may contain SQL) from operation reports at the global level. Overridden by `--report-suppress-exception` at the command level. Default: `false`. However: If `--reports-suppress-exception` is not set and `--reports-suppress-sql=true` , Liquibase suppresses all SQL, including exception SQL. If `--reports-suppress-exception=false` and `--reports-suppress-sql=true` , Liquibase suppresses most SQL but shows exception SQL.	Optional
`--reports-suppress-sql=<true\|false>`	Boolean	Liquibase 4.31.0+. Specifies whether to hide changeset SQL in operation reports at the global level. Overridden by `--report-suppress-sql` at the command level. Default: `false`.	Optional

CLI

Parameter	Type	Description	Requirement
`--reports-enabled=<true\|false>`	Boolean	Enables or disables all reports at the global level. Overridden by `--report-enabled` at the command level. Default: `true`.	Required (either this or `--report-enabled` )
`--reports-name=<string>`	String	Specifies the name of the report file at the global level. Overridden by `--report-name` at the command level. By default, Liquibase generates a new report file labeled with a timestamp (user's local time). If you set a custom name, Liquibase overwrites the existing file every time you generate a new report. Default: `report-<DD-Mon-YYYY-HHmmss>.html`.	Optional
`--reports-open=<true\|false>`	Boolean	Specifies whether to automatically open the report in your default browser at the global level. Overridden by `--report-open` at the command level. Default: `true`.	Optional
`--reports-path=<string>`	String	Specifies the file path to the report file at the global level. Overridden by `--report-path` at the command level. Default: `./`	Optional
`--reports-suppress-exception=<true\|false>`	Boolean	Liquibase 4.31.0+. Specifies whether to hide exceptions (which may contain SQL) from operation reports at the global level. Overridden by `--report-suppress-exception` at the command level. Default: `false`. However: If `--reports-suppress-exception` is not set and `--reports-suppress-sql=true` , Liquibase suppresses all SQL, including exception SQL. If `--reports-suppress-exception=false` and `--reports-suppress-sql=true` , Liquibase suppresses most SQL but shows exception SQL.	Optional
`--reports-suppress-sql=<true\|false>`	Boolean	Liquibase 4.31.0+. Specifies whether to hide changeset SQL in operation reports at the global level. Overridden by `--report-suppress-sql` at the command level. Default: `false`.	Optional

CLI

Parameter	Type	Description	Requirement
`--reports-enabled=<true\|false>`	Boolean	Enables or disables all reports at the global level. Overridden by `--report-enabled` at the command level. Default: `true`.	Required (either this or `--report-enabled` )
`--reports-name=<string>`	String	Specifies the name of the report file at the global level. Overridden by `--report-name` at the command level. By default, Liquibase generates a new report file labeled with a timestamp (user's local time). If you set a custom name, Liquibase overwrites the existing file every time you generate a new report. Default: `report-<DD-Mon-YYYY-HHmmss>.html`.	Optional
`--reports-open=<true\|false>`	Boolean	Specifies whether to automatically open the report in your default browser at the global level. Overridden by `--report-open` at the command level. Default: `true`.	Optional
`--reports-path=<string>`	String	Specifies the file path to the report file at the global level. Overridden by `--report-path` at the command level. Default: `./`	Optional
`--reports-suppress-exception=<true\|false>`	Boolean	Liquibase 4.31.0+. Specifies whether to hide exceptions (which may contain SQL) from operation reports at the global level. Overridden by `--report-suppress-exception` at the command level. Default: `false`. However: If `--reports-suppress-exception` is not set and `--reports-suppress-sql=true` , Liquibase suppresses all SQL, including exception SQL. If `--reports-suppress-exception=false` and `--reports-suppress-sql=true` , Liquibase suppresses most SQL but shows exception SQL.	Optional
`--reports-suppress-sql=<true\|false>`	Boolean	Liquibase 4.31.0+. Specifies whether to hide changeset SQL in operation reports at the global level. Overridden by `--report-suppress-sql` at the command level. Default: `false`.	Optional

CLI

Parameter	Type	Description	Requirement
`--reports-enabled=<true\|false>`	Boolean	Enables or disables all reports at the global level. Overridden by `--report-enabled` at the command level. Default: `true`.	Required (either this or `--report-enabled` )
`--reports-name=<string>`	String	Specifies the name of the report file at the global level. Overridden by `--report-name` at the command level. By default, Liquibase generates a new report file labeled with a timestamp (user's local time). If you set a custom name, Liquibase overwrites the existing file every time you generate a new report. Default: `report-<DD-Mon-YYYY-HHmmss>.html`.	Optional
`--reports-open=<true\|false>`	Boolean	Specifies whether to automatically open the report in your default browser at the global level. Overridden by `--report-open` at the command level. Default: `true`.	Optional
`--reports-path=<string>`	String	Specifies the file path to the report file at the global level. Overridden by `--report-path` at the command level. Default: `./`	Optional
`--reports-suppress-exception=<true\|false>`	Boolean	Liquibase 4.31.0+. Specifies whether to hide exceptions (which may contain SQL) from operation reports at the global level. Overridden by `--report-suppress-exception` at the command level. Default: `false`. However: If `--reports-suppress-exception` is not set and `--reports-suppress-sql=true` , Liquibase suppresses all SQL, including exception SQL. If `--reports-suppress-exception=false` and `--reports-suppress-sql=true` , Liquibase suppresses most SQL but shows exception SQL.	Optional
`--reports-suppress-sql=<true\|false>`	Boolean	Liquibase 4.31.0+. Specifies whether to hide changeset SQL in operation reports at the global level. Overridden by `--report-suppress-sql` at the command level. Default: `false`.	Optional