Quality Checks

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

Liquibase Quality Checks prevent non-compliant database changes from reaching your production databases. Using Quality Checks, you can analyze your changelogs, changesets, and SQL for specific commands and patterns that require close review early in the development life cycle. You can integrate this feature into your build and deployment automation.

Diagram of the developer workflow using quality checks.

Business Benefits

Quality Checks deliver the following benefits:

  • Governance at Scale: Automatically enforce consistent and high-quality changes that meet your governance requirements.
  • Reduce Errors: Catch non-compliant changes and notify developers with Checks Reports in your automation pipeline.
  • Improve Productivity: Reduce manual reviews by enforcing policy standards automatically in your CI/CD pipeline.

Example Scenarios

  • Enforce Standards: Quickly and easily validate naming standards, column links, and other common changes.
  • Access/Privileges: Secure your database by getting immediate notice that user and role privileges are being modified.
  • Custom Quality Checks: Write unique Quality Checks customized to your organization’s governance standards.

High-Level Architecture

This is a high-level overview of how Quality Checks fit together:

  • Define policies to be enforced in a central location.
  • Integrate checks into automation to validate each change.
  • Review checks report.

Implement Quality Checks

  1. Set up quality checks for your team

  2. Integrate quality checks into manual and automated deployments

Review Your Checks Report

Graphical output of checks report. Contains a warning about critical errors followed by a runtime summary and other details.

Automatically generate a Checks Report using the Liquibase checks run command. The Checks Report gives you a human-readable summary of command metadata, warning messages, checks package and other configuration details, and an organized summary of check output in a browser page.

Related topics