Get the most out of your tools. From everyday tasks to advanced workflows, the User guide shows you how to work efficiently and effectively with our platform.

Liquibase Package Manager

What is LPM?

Find packages with LPM

Add packages with LPM

Remove packages with LPM

Changelogs

Introduction to Liquibase

What is a Changelog?

Changelog examples

SQL changelog example

XML changelog example

JSON changelog example

YAML changelog example

Formatted Mongo changelog example

Changesets

What is a Changeset?

When should I use context and label attributes?

What is a Changeset checksum?

Liquibase concepts

What are attributes?

What are preconditions?

What is property substitution?

How does Liquibase find files?

What is the liquibase.properties file?

What are Liquibase environment variables?

Use environment variables to control the amount of log information

What are environment variables in Docker?

What are JAVA_OPTS environment variables?

How does Liquibase handle data types?

How do I manage an offline database?

How do I trim my changelog?

Assess logs to understand changelog efficiency

Use UUID and load data

How do I include and exclude database objects?

Run the include-objects attribute

Run the exclude-objects attribute

Generate a changelog with diff-types

What is drift detection?

Diff multiple schemas in Liquibase

Generate SQL to update database schemas

What is stored logic?

How does Liquibase handle security?

What data does Liquibase collect and how is it used?

FAQ

Tracking tables

What is the DATABASECHANGELOG table?

What is the DATABASECHANGELOGHISTORY table?

What is the DATABASECHANGELOGLOCK table?

Limitations

What are the COTS database limitations?

What are the memory limits on inspecting large schema?

Rollback

What is a rollback?

Create custom rollback statements in Liquibase

What automatic rollbacks does Liquibase support?

What are targeted rollbacks?