Liquibase OSS

User guide

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.

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 log level

Use 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 schema 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?

Liquibase FAQs

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 schemas?

Rollback

What is rollback?

Create custom rollback statements in Liquibase

What automatic rollbacks does Liquibase support?

What are targeted rollbacks?