Note: This is a Liquibase Pro command, so you need a Liquibase Pro License Key to use it.

The update-one-changeset-sql command is a helper command that allows you to inspect the SQL Liquibase will run to deploy the changeset specified in the update-one-changeset command. It is only available for Liquibase Pro users.


The update-one-changeset-sql command is useful when you want to inspect the raw SQL that Liquibase uses to deploy your changeset when you run the update-one-changeset command, so that you don't unintentionally make a mistake.

Running the update-one-changeset-sql command

Before running the update-one-changeset-sql command, gather the following information from your changelog:

  • The author of the changeset you want to deploy
  • The ID of the changeset you want to deploy
  • The file name (changeset path) of the changeset you want to deploy

Then run the update-one-changeset-sql command, with your information:

liquibase update-one-changeset-sql --changeset-id=2 --changeset-author=anotherdev --changeset-path=example-changelog.sql

For more command specific help, type liquibase update-one-changeset-sql --help into the command prompt.

update-one-changeset-sql global attributes

Tip: All commands and parameters use the --kebab-case format in the CLI environment. This is the format Liquibase recommends for best results. If your preference is camelCase, it will still work in the CLI.

Parameter Definition Requirement

The root changelog


The JDBC database connection URL


The database username


The database password


Your Liquibase Pro license key


Specifies the file path to where the SQL output will be written

Optional *

Note: The username and password attributes are not required for connections and systems which use alternate means of authentication.

* If not specified, the SQL output goes to STDOUT.

update-one-changeset-sql command attributes

Parameter Definition Requirement

The changeset ID from the changelog.


The name of the author for the changeset.


The path to the changelog containing the changeset you want to roll back.


Like what you see? Try this command in Pro for Free.