Secure 6.0: conditions

Reference
Version · 6.0
Change Automation Reference

conditions

Last updated: September 29, 2026

Use the conditions attribute to tag a changeset with the circumstances it is intended for, such as a hotfix, a data fix, or a maintenance window. At runtime, you can control which tagged changesets a command runs using the conditions-filter argument.

Note: The conditions attribute requires Liquibase Secure 5.2.2 or later.

Uses

You can specify a condition as any case-insensitive string, or a comma-separated list of conditions. You can typically use conditions to:

Tag changesets with the circumstances they are intended for, such as hotfix or maintenance.
Deploy or roll back only the changesets that match the current circumstances.
Limit which changesets a checks run operation inspects, without enabling or disabling checks or maintaining separate checks packages and configuration files.
Slice deployments across an additional dimension when labels, contexts, teams, and releases are already in use for other purposes.

Syntax

Add the conditions attribute to a changeset in any changelog format. You can specify a single value or a comma-separated list.

Note: In XML changelogs, the attribute name must be lowercase (conditions). In other formats, the attribute name is case-insensitive.

--liquibase formatted sql

--changeset your.name:1-create-employees conditions:baseline
CREATE TABLE employees (id INT NOT NULL PRIMARY KEY, name VARCHAR(100) NOT NULL, department VARCHAR(50));
--rollback DROP TABLE employees;

--changeset your.name:2-create-products conditions:hotfix
CREATE TABLE products (id INT NOT NULL PRIMARY KEY, name VARCHAR(100) NOT NULL, price DECIMAL(10,2));
--rollback DROP TABLE products;

--changeset your.name:3-create-audit-log conditions:maintenance
CREATE TABLE audit_log (id INT NOT NULL PRIMARY KEY, action VARCHAR(255), performed_at TIMESTAMP);
--rollback DROP TABLE audit_log;

--changeset your.name:4-create-app-config
CREATE TABLE app_config (id INT NOT NULL PRIMARY KEY, setting_name VARCHAR(100));
--rollback DROP TABLE app_config;

<?xml version="1.0" encoding="UTF-8"?>
<databaseChangeLog
    xmlns="http://www.liquibase.org/xml/ns/dbchangelog"
    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    xsi:schemaLocation="http://www.liquibase.org/xml/ns/dbchangelog
        http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-latest.xsd">

    <changeSet id="1-create-employees" author="your.name" conditions="baseline">
        <createTable tableName="employees">
            <column name="id" type="int" autoIncrement="true">
                <constraints primaryKey="true" nullable="false"/>
            </column>
            <column name="name" type="varchar(100)">
                <constraints nullable="false"/>
            </column>
            <column name="department" type="varchar(50)"/>
        </createTable>
        <rollback>
            <dropTable tableName="employees"/>
        </rollback>
    </changeSet>

    <changeSet id="2-create-products" author="your.name" conditions="hotfix">
        <createTable tableName="products">
            <column name="id" type="int" autoIncrement="true">
                <constraints primaryKey="true" nullable="false"/>
            </column>
            <column name="name" type="varchar(100)">
                <constraints nullable="false"/>
            </column>
            <column name="price" type="decimal(10,2)"/>
        </createTable>
        <rollback>
            <dropTable tableName="products"/>
        </rollback>
    </changeSet>

    <changeSet id="3-create-audit-log" author="your.name" conditions="maintenance">
        <createTable tableName="audit_log">
            <column name="id" type="int" autoIncrement="true">
                <constraints primaryKey="true" nullable="false"/>
            </column>
            <column name="action" type="varchar(255)"/>
            <column name="performed_at" type="timestamp"/>
        </createTable>
        <rollback>
            <dropTable tableName="audit_log"/>
        </rollback>
    </changeSet>

    <changeSet id="4-create-app-config" author="your.name">
        <createTable tableName="app_config">
            <column name="id" type="int" autoIncrement="true">
                <constraints primaryKey="true" nullable="false"/>
            </column>
            <column name="setting_name" type="varchar(100)"/>
        </createTable>
        <rollback>
            <dropTable tableName="app_config"/>
        </rollback>
    </changeSet>

</databaseChangeLog>

databaseChangeLog:
  - changeSet:
      id: 1-create-employees
      author: your.name
      conditions: 'baseline'
      changes:
        - createTable:
            tableName: employees
            columns:
              - column:
                  name: id
                  type: int
                  autoIncrement: true
                  constraints:
                    primaryKey: true
                    nullable: false
              - column:
                  name: name
                  type: varchar(100)
              - column:
                  name: department
                  type: varchar(50)
      rollback:
        - dropTable:
            tableName: employees
  - changeSet:
      id: 2-create-products
      author: your.name
      conditions: 'hotfix'
      changes:
        - createTable:
            tableName: products
            columns:
              - column:
                  name: id
                  type: int
                  autoIncrement: true
                  constraints:
                    primaryKey: true
                    nullable: false
              - column:
                  name: name
                  type: varchar(100)
              - column:
                  name: price
                  type: decimal(10,2)
      rollback:
        - dropTable:
            tableName: products
  - changeSet:
      id: 3-create-audit-log
      author: your.name
      conditions: 'maintenance'
      changes:
        - createTable:
            tableName: audit_log
            columns:
              - column:
                  name: id
                  type: int
                  autoIncrement: true
                  constraints:
                    primaryKey: true
                    nullable: false
              - column:
                  name: action
                  type: varchar(255)
              - column:
                  name: performed_at
                  type: timestamp
      rollback:
        - dropTable:
            tableName: audit_log
  - changeSet:
      id: 4-create-app-config
      author: your.name
      changes:
        - createTable:
            tableName: app_config
            columns:
              - column:
                  name: id
                  type: int
                  autoIncrement: true
                  constraints:
                    primaryKey: true
                    nullable: false
              - column:
                  name: setting_name
                  type: varchar(100)
      rollback:
        - dropTable:
            tableName: app_config

{
    "databaseChangeLog": [
        {
            "changeSet": {
                "id": "1-create-employees",
                "author": "your.name",
                "conditions": "baseline",
                "changes": [
                    {
                        "createTable": {
                            "tableName": "employees",
                            "columns": [
                                {
                                    "column": {
                                        "name": "id",
                                        "type": "int",
                                        "autoIncrement": true,
                                        "constraints": {
                                            "primaryKey": true,
                                            "nullable": false
                                        }
                                    }
                                },
                                {
                                    "column": {
                                        "name": "name",
                                        "type": "varchar(100)"
                                    }
                                },
                                {
                                    "column": {
                                        "name": "department",
                                        "type": "varchar(50)"
                                    }
                                }
                            ]
                        }
                    }
                ],
                "rollback": [
                    {
                        "dropTable": {
                            "tableName": "employees"
                        }
                    }
                ]
            }
        },
        {
            "changeSet": {
                "id": "2-create-products",
                "author": "your.name",
                "conditions": "hotfix",
                "changes": [
                    {
                        "createTable": {
                            "tableName": "products",
                            "columns": [
                                {
                                    "column": {
                                        "name": "id",
                                        "type": "int",
                                        "autoIncrement": true,
                                        "constraints": {
                                            "primaryKey": true,
                                            "nullable": false
                                        }
                                    }
                                },
                                {
                                    "column": {
                                        "name": "name",
                                        "type": "varchar(100)"
                                    }
                                },
                                {
                                    "column": {
                                        "name": "price",
                                        "type": "decimal(10,2)"
                                    }
                                }
                            ]
                        }
                    }
                ],
                "rollback": [
                    {
                        "dropTable": {
                            "tableName": "products"
                        }
                    }
                ]
            }
        },
        {
            "changeSet": {
                "id": "3-create-audit-log",
                "author": "your.name",
                "conditions": "maintenance",
                "changes": [
                    {
                        "createTable": {
                            "tableName": "audit_log",
                            "columns": [
                                {
                                    "column": {
                                        "name": "id",
                                        "type": "int",
                                        "autoIncrement": true,
                                        "constraints": {
                                            "primaryKey": true,
                                            "nullable": false
                                        }
                                    }
                                },
                                {
                                    "column": {
                                        "name": "action",
                                        "type": "varchar(255)"
                                    }
                                },
                                {
                                    "column": {
                                        "name": "performed_at",
                                        "type": "timestamp"
                                    }
                                }
                            ]
                        }
                    }
                ],
                "rollback": [
                    {
                        "dropTable": {
                            "tableName": "audit_log"
                        }
                    }
                ]
            }
        },
        {
            "changeSet": {
                "id": "4-create-app-config",
                "author": "your.name",
                "changes": [
                    {
                        "createTable": {
                            "tableName": "app_config",
                            "columns": [
                                {
                                    "column": {
                                        "name": "id",
                                        "type": "int",
                                        "autoIncrement": true,
                                        "constraints": {
                                            "primaryKey": true,
                                            "nullable": false
                                        }
                                    }
                                },
                                {
                                    "column": {
                                        "name": "setting_name",
                                        "type": "varchar(100)"
                                    }
                                }
                            ]
                        }
                    }
                ],
                "rollback": [
                    {
                        "dropTable": {
                            "tableName": "app_config"
                        }
                    }
                ]
            }
        }
    ]
}

--liquibase formatted sql

--changeset your.name:1-create-employees conditions:baseline
CREATE TABLE employees (id INT NOT NULL PRIMARY KEY, name VARCHAR(100) NOT NULL, department VARCHAR(50));
--rollback DROP TABLE employees;

--changeset your.name:2-create-products conditions:hotfix
CREATE TABLE products (id INT NOT NULL PRIMARY KEY, name VARCHAR(100) NOT NULL, price DECIMAL(10,2));
--rollback DROP TABLE products;

--changeset your.name:3-create-audit-log conditions:maintenance
CREATE TABLE audit_log (id INT NOT NULL PRIMARY KEY, action VARCHAR(255), performed_at TIMESTAMP);
--rollback DROP TABLE audit_log;

--changeset your.name:4-create-app-config
CREATE TABLE app_config (id INT NOT NULL PRIMARY KEY, setting_name VARCHAR(100));
--rollback DROP TABLE app_config;

<?xml version="1.0" encoding="UTF-8"?>
<databaseChangeLog
    xmlns="http://www.liquibase.org/xml/ns/dbchangelog"
    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    xsi:schemaLocation="http://www.liquibase.org/xml/ns/dbchangelog
        http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-latest.xsd">

    <changeSet id="1-create-employees" author="your.name" conditions="baseline">
        <createTable tableName="employees">
            <column name="id" type="int" autoIncrement="true">
                <constraints primaryKey="true" nullable="false"/>
            </column>
            <column name="name" type="varchar(100)">
                <constraints nullable="false"/>
            </column>
            <column name="department" type="varchar(50)"/>
        </createTable>
        <rollback>
            <dropTable tableName="employees"/>
        </rollback>
    </changeSet>

    <changeSet id="2-create-products" author="your.name" conditions="hotfix">
        <createTable tableName="products">
            <column name="id" type="int" autoIncrement="true">
                <constraints primaryKey="true" nullable="false"/>
            </column>
            <column name="name" type="varchar(100)">
                <constraints nullable="false"/>
            </column>
            <column name="price" type="decimal(10,2)"/>
        </createTable>
        <rollback>
            <dropTable tableName="products"/>
        </rollback>
    </changeSet>

    <changeSet id="3-create-audit-log" author="your.name" conditions="maintenance">
        <createTable tableName="audit_log">
            <column name="id" type="int" autoIncrement="true">
                <constraints primaryKey="true" nullable="false"/>
            </column>
            <column name="action" type="varchar(255)"/>
            <column name="performed_at" type="timestamp"/>
        </createTable>
        <rollback>
            <dropTable tableName="audit_log"/>
        </rollback>
    </changeSet>

    <changeSet id="4-create-app-config" author="your.name">
        <createTable tableName="app_config">
            <column name="id" type="int" autoIncrement="true">
                <constraints primaryKey="true" nullable="false"/>
            </column>
            <column name="setting_name" type="varchar(100)"/>
        </createTable>
        <rollback>
            <dropTable tableName="app_config"/>
        </rollback>
    </changeSet>

</databaseChangeLog>

databaseChangeLog:
  - changeSet:
      id: 1-create-employees
      author: your.name
      conditions: 'baseline'
      changes:
        - createTable:
            tableName: employees
            columns:
              - column:
                  name: id
                  type: int
                  autoIncrement: true
                  constraints:
                    primaryKey: true
                    nullable: false
              - column:
                  name: name
                  type: varchar(100)
              - column:
                  name: department
                  type: varchar(50)
      rollback:
        - dropTable:
            tableName: employees
  - changeSet:
      id: 2-create-products
      author: your.name
      conditions: 'hotfix'
      changes:
        - createTable:
            tableName: products
            columns:
              - column:
                  name: id
                  type: int
                  autoIncrement: true
                  constraints:
                    primaryKey: true
                    nullable: false
              - column:
                  name: name
                  type: varchar(100)
              - column:
                  name: price
                  type: decimal(10,2)
      rollback:
        - dropTable:
            tableName: products
  - changeSet:
      id: 3-create-audit-log
      author: your.name
      conditions: 'maintenance'
      changes:
        - createTable:
            tableName: audit_log
            columns:
              - column:
                  name: id
                  type: int
                  autoIncrement: true
                  constraints:
                    primaryKey: true
                    nullable: false
              - column:
                  name: action
                  type: varchar(255)
              - column:
                  name: performed_at
                  type: timestamp
      rollback:
        - dropTable:
            tableName: audit_log
  - changeSet:
      id: 4-create-app-config
      author: your.name
      changes:
        - createTable:
            tableName: app_config
            columns:
              - column:
                  name: id
                  type: int
                  autoIncrement: true
                  constraints:
                    primaryKey: true
                    nullable: false
              - column:
                  name: setting_name
                  type: varchar(100)
      rollback:
        - dropTable:
            tableName: app_config

{
    "databaseChangeLog": [
        {
            "changeSet": {
                "id": "1-create-employees",
                "author": "your.name",
                "conditions": "baseline",
                "changes": [
                    {
                        "createTable": {
                            "tableName": "employees",
                            "columns": [
                                {
                                    "column": {
                                        "name": "id",
                                        "type": "int",
                                        "autoIncrement": true,
                                        "constraints": {
                                            "primaryKey": true,
                                            "nullable": false
                                        }
                                    }
                                },
                                {
                                    "column": {
                                        "name": "name",
                                        "type": "varchar(100)"
                                    }
                                },
                                {
                                    "column": {
                                        "name": "department",
                                        "type": "varchar(50)"
                                    }
                                }
                            ]
                        }
                    }
                ],
                "rollback": [
                    {
                        "dropTable": {
                            "tableName": "employees"
                        }
                    }
                ]
            }
        },
        {
            "changeSet": {
                "id": "2-create-products",
                "author": "your.name",
                "conditions": "hotfix",
                "changes": [
                    {
                        "createTable": {
                            "tableName": "products",
                            "columns": [
                                {
                                    "column": {
                                        "name": "id",
                                        "type": "int",
                                        "autoIncrement": true,
                                        "constraints": {
                                            "primaryKey": true,
                                            "nullable": false
                                        }
                                    }
                                },
                                {
                                    "column": {
                                        "name": "name",
                                        "type": "varchar(100)"
                                    }
                                },
                                {
                                    "column": {
                                        "name": "price",
                                        "type": "decimal(10,2)"
                                    }
                                }
                            ]
                        }
                    }
                ],
                "rollback": [
                    {
                        "dropTable": {
                            "tableName": "products"
                        }
                    }
                ]
            }
        },
        {
            "changeSet": {
                "id": "3-create-audit-log",
                "author": "your.name",
                "conditions": "maintenance",
                "changes": [
                    {
                        "createTable": {
                            "tableName": "audit_log",
                            "columns": [
                                {
                                    "column": {
                                        "name": "id",
                                        "type": "int",
                                        "autoIncrement": true,
                                        "constraints": {
                                            "primaryKey": true,
                                            "nullable": false
                                        }
                                    }
                                },
                                {
                                    "column": {
                                        "name": "action",
                                        "type": "varchar(255)"
                                    }
                                },
                                {
                                    "column": {
                                        "name": "performed_at",
                                        "type": "timestamp"
                                    }
                                }
                            ]
                        }
                    }
                ],
                "rollback": [
                    {
                        "dropTable": {
                            "tableName": "audit_log"
                        }
                    }
                ]
            }
        },
        {
            "changeSet": {
                "id": "4-create-app-config",
                "author": "your.name",
                "changes": [
                    {
                        "createTable": {
                            "tableName": "app_config",
                            "columns": [
                                {
                                    "column": {
                                        "name": "id",
                                        "type": "int",
                                        "autoIncrement": true,
                                        "constraints": {
                                            "primaryKey": true,
                                            "nullable": false
                                        }
                                    }
                                },
                                {
                                    "column": {
                                        "name": "setting_name",
                                        "type": "varchar(100)"
                                    }
                                }
                            ]
                        }
                    }
                ],
                "rollback": [
                    {
                        "dropTable": {
                            "tableName": "app_config"
                        }
                    }
                ]
            }
        }
    ]
}

Filtering by conditions

At runtime, pass the --conditions-filter argument to run only the changesets whose conditions attribute matches the filter value. Matching is a straight string comparison with no logical operators. Changesets without a conditions attribute always run, even when a filter is specified. See conditions-filter for matching rules, examples, and supported commands.

PreviousWhat is a changelog attribute?NextConditions-filter

conditions

Uses

Syntax

SQL

XML

YAML

JSON

Filtering by conditions