Task
Version · 6.0
Deliver

Create a Custom policy check

Last updated: September 29, 2026

This tutorial shows you how to create, customize, and run a Liquibase custom policy check using a sample Python script. For a conceptual overview of this feature, see What is a Liquibase Secure Custom policy check?

For examples of more advanced Python scripts and guidance on writing Python code to use in the Liquibase policy checks framework, see What are some examples of Custom policy check scripts?

Before you begin

Create a Check Settings file
(Maven users only) Add the liquibase-checks dependency to your pom.xml file. See Add extensions with Maven for more information.

Procedure

Create a new file in your Liquibase working directory or a subdirectory like /scripts.

This file will contain the Python script that is your custom policy check. In this example, we title our new file custom_check_no_tables.py.

Tip: Downloading Python itself is not required to create custom checks in the Liquibase checks framework, but it may be useful to test checks against Python 3.10.14+.

Open the new custom_check_no_tables.py file and add the following custom policy check to it

    # import Liquibase modules containing useful functions
    import liquibase_utilities as lb
    import sys

    # define reusable variables
    obj = lb.get_database_object()  # database object to examine
    liquibase_status = lb.get_status()  # Status object of the check

    # write check logic
    # this condition checks if the current object is a table
    # and whether it starts with the prefix 'tbl_'
    if lb.is_table(obj) and not obj.getName().lower().startswith("tbl_"):
    # indicate that the custom check has been triggered
    liquibase_status.fired = True
    # set the message for Liquibase to return when check is triggered
    liquibase_status.message = "Tables must start with the prefix tbl_. Add this prefix."
    # halt execution of the script
    sys.exit(1)

    # default return code
    False

Note:Liquibase will run the check against every object in the database, so this script doesn't need a Python looping mechanism to iterate through database objects.

PreviousRun a policy check NextConfigure a custom policy check