Liquibase Database Tutorials

Liquibase works with 50+ databases including relational, NoSQL, and graph databases.

Learn more about using Liquibase with your favorite databases with our in-depth tutorials. These tutorials explain how to install and configure your database with Liquibase Open Source and Liquibase Pro.

Prerequisites

Before you start setting up your database, make sure you're familiar with how Liquibase works using these pages:

1. Introduction to Liquibase: Dive into Liquibase concepts.
2. Install Liquibase: Download Liquibase on your machine.
3. Get Started with Liquibase: Learn how to use Liquibase with an example database.
4. Design Your Liquibase Project: Create a new Liquibase project folder and organize your changelogs.
5. How to Apply Your Liquibase Pro License Key: If you use Liquibase Pro, activate your license.

Liquibase-maintained databases

Liquibase tests with English language databases only. Other languages with special characters may cause issues.

The following table shows databases whose compatibility with Liquibase is maintained by Liquibase. For databases maintained by the community, see the "Community-maintained databases" section.

Note: Many databases are based on similar underlying architectures and use similar JDBC connection information. The "Database" column refers to your front-end database implementation. The "DBMS/shortname" field refers to the back-end system that Liquibase recognizes in JDBC URLs and in the dbms changeset attribute.

Database	Verified versions	Shortname / Driver / Notes
Amazon DocumentDB	4.0	DBMS/shortname: mongodb File: mongo-java-driver-<version>.jar JDBC URL: jdbc:mongodb://localhost:27069/lbcat?tls=false&retryWrites=false Download: Maven: org/mongodb/mongo-java-driver Extension: GitHub: liquibase/liquibase-mongodb Notes: Amazon DocumentDB emulates MongoDB. Connect via the MongoDB Pro extension. For TLS/SSL configuration, see the Amazon DocumentDB tutorial page.
Amazon DynamoDB	Cloud	DBMS/shortname: dynamodb File: liquibase-commercial-dynamodb Connection URL: https://dynamodb.<region>.amazonaws.com or dynamodb://localhost:8000 Download: Maven: liquibase-commercial-dynamodb
Amazon Redshift	Cloud	DBMS/shortname: redshift File: redshift-jdbc<version>.jar Class: com.amazon.redshift.jdbc42.Driver JDBC URL: jdbc:redshift://endpoint:port/dbname Download: AWS: Download the Amazon Redshift JDBC driver, version 2.1
AWS Aurora – MySQL	8.0 5.7	DBMS/shortname: mysql File: mysql-connector-java-<version>.jar Class: NA JDBC URL: jdbc:mysql://<endpoint>:<port>/<dbname> Download: Amazon Aurora
AWS Aurora for PostgreSQL	16 15 14 13 12 11	DBMS/shortname: postgresql File: postgresql-<version>.jar Class: org.postgresql.Driver JDBC URL: jdbc:postgresql://<instance_host>:<instance_port>/<dbname> Download: Amazon Aurora
AWS RDS – MariaDB	10.6 10.5 10.4 10.3 10.2	DBMS/shortname: mariadb File: mariadb-java-client-<version>.jar Class: org.mariadb.jdbc.Driver JDBC URL: jdbc:mariadb://<endpoint>:<port>/<dbname> Download: Amazon RDS for MariaDB
AWS RDS – Microsoft SQL Server	2019 2017 2016 2014	DBMS/shortname: mssql File: mssql-jdbc-<version>.jre-<version>.jar Class: com.microsoft.sqlserver.jdbc.SQLServerDriver JDBC URL: jdbc:sqlserver://<endpoint>:<port>/<dbname>; Download: Amazon RDS for SQL Server Notes: Requires semicolon at end.
AWS RDS – MySQL	8.0 5.7	DBMS/shortname: mysql File: mysql-connector-java-<version>.jar Class: NA JDBC URL: jdbc:mysql://<endpoint>:<port>/<dbname> Download: Amazon RDS for MySQL
AWS RDS – Oracle Database	21c 19c	DBMS/shortname: oracle File: ojdbc<version>.jar Class: oracle.jdbc.OracleDriver JDBC URL: jdbc:oracle:thin:@<endpoint>:<port>:<sid> Download: Amazon RDS for Oracle
AWS RDS – PostgreSQL	16 15 14 13 12	DBMS/shortname: postgresql File: postgresql-<version>.jar Class: org.postgresql.Driver JDBC URL: jdbc:postgresql://<instance_host>:<instance_port>/<dbname> Download: Amazon RDS for PostgreSQL
Azure Database for MySQL	8.0 5.7	DBMS/shortname: mysql File: mysql-connector-java-<version>.jar Class: NA JDBC URL: jdbc:mysql://<endpoint>:<port>/<dbname> Download: Azure Database for MySQL
Azure Database – Postresql – Flexible Server	16 15 13	DBMS/shortname: postgresql File: postgresql-<version>.jar Class: org.postgresql.Driver JDBC URL: jdbc:postgresql://<endpoint>:<port>/<dbname> Download: Azure Database for PostgreSQL – Flexible Server
Azure Database – Postresql – Single Server	11	DBMS/shortname: postgresql File: postgresql-<version>.jar Class: org.postgresql.Driver JDBC URL: jdbc:postgresql://<endpoint>:<port>/<dbname> Download: Azure Database for PostgreSQL – Single Server
EnterpriseDB	14 13 12	DBMS/shortname: edb File: edb-jdbc-<version>.jar Class: com.edb.Driver JDBC URL: jdbc:edb://<hostname>:5444/<dbname> Download: EnterpriseDB: Downloads: EDB Connectors
Google BigQuery Pro	2.13.6+	DBMS/shortname: bigquery File: liquibase-commercial-bigquery-<version>.jar JDBC URL: jdbc:bigquery://<Host>:<Port>;ProjectId=<Project>;OAuthType=<AuthValue>;<Property1>=<Value1>;<Property2>=<Value2>;... Download: Maven
Google BigQuery Open Source	2.13.6+	DBMS/shortname: bigquery File: google-cloud-bigquery-<version>.jar Class: com.simba.googlebigquery.jdbc42.Driver JDBC URL: jdbc:bigquery://<Host>:<Port>;ProjectId=<Project>;OAuthType=<AuthValue>;<Property1>=<Value1>;<Property2>=<Value2>;... Download: Google: ODBC and JDBC drivers for BigQuery
Google Cloud SQL – MSSQL	2019	DBMS/shortname: mssql File: mssql-jdbc-<version>.jre-<version>.jar Class: com.microsoft.sqlserver.jdbc.SQLServerDriver JDBC URL: jdbc:sqlserver://<host>:<port>/<dbname>; Download: SQL Server on Google Cloud Notes: Requires semicolon at end.
Google Cloud SQL – MySQL	8.0	DBMS/shortname: mysql File: mysql-connector-java-<version>.jar Class: NA JDBC URL: jdbc:mysql://<endpoint>:<port>/<dbname> Download: Google Cloud SQL for MySQL
Google Cloud SQL – PostgreSQL	14 13 12 11	DBMS/shortname: postgresql File: postgresql-<version>.jar Class: org.postgresql.Driver JDBC URL: jdbc:postgresql://<instance_host>:<instance_port>/<dbname> Download: Google Cloud SQL for PostgreSQL
IBM DB2 LUW	11.5.7+	DBMS/shortname: db2 File: db2jcc<version>.jar Class: com.ibm.db2.jcc.DB2Driver JDBC URL: jdbc:db2://<server-name>:<port>/<dbname> Download: IBM: DB2 JDBC Driver Versions and Downloads
MariaDB Server	10.6 10.5 10.4 10.3 10.2	DBMS/shortname: mariadb File: mariadb-java-client-<version>.jar Class: org.mariadb.jdbc.Driver JDBC URL: jdbc:mariadb://<host>:<port>/<dbname> Download: MariaDB: About MariaDB Connector/J Notes: Select the Java 8 connector/j.
MariaDB SkySQL	10.6 10.5 10.4 10.3 10.2	DBMS/shortname: mariadb File: mariadb-java-client-<version>.jar Class: org.mariadb.jdbc.Driver JDBC URL: jdbc:mariadb://<host>:<port>/<dbname>?useSSL=true&serverSslCert=skysql_chain.pem Download: MariaDB: About MariaDB Connector/J Notes: Select the Java 8 connector/j.
Microsoft Azure SQL Database	Cloud	DBMS/shortname: mssql File: mssql-jdbc-<version>.jre-<version>.jar Class: com.microsoft.sqlserver.jdbc.SQLServerDriver JDBC URL: jdbc:sqlserver://<endpoint>:<port>/<dbname>; Download: Azure SQL Database Note: Requires semicolon at end.
Microsoft Azure SQL Managed Instance	Cloud	DBMS/shortname: mssql File: mssql-jdbc-<version>.jre-<version>.jar Class: com.microsoft.sqlserver.jdbc.SQLServerDriver JDBC URL: jdbc:sqlserver://<endpoint>:<port>/<dbname>; Download: Azure SQL Database Note: Requires semicolon at end.
Microsoft SQL Server	2022 2019 2017 2016 2014	DBMS/shortname: mssql File: mssql-jdbc-<version>.jre-<version>.jar Class: com.microsoft.sqlserver.jdbc.SQLServerDriver JDBC URL: jdbc:sqlserver://<host>:<port>/<dbname>; Download: Microsoft: Download Microsoft JDBC Driver for SQL Server Note: Requires semicolon at end.
MongoDB Pro Extension Community and Enterprise Server	7 6 5	DBMS/shortname: mongodb File: mongo-java-driver-<version>.jar Class: NA JDBC URL: jdbc:mongodb://hostname:27017/<dbname> Reference: MongoDB: Connection String URI Format Download: Maven: org/mongodb/mongo-java-driver Extension: GitHub: liquibase/liquibase-mongodb Notes: Requires Liquibase Pro 4.20+. For TLS/SSL configuration, see the MongoDB Pro Extension Community and Enterprise Server tutorial page.
MongoDB Atlas Pro Extension	7 6 5	DBMS/shortname: mongodb File: mongo-java-driver-<version>.jar Class: NA JDBC URL: jdbc:mongodb://hostname:27017/<dbname> Reference: MongoDB: Connection String URI Format Download: Maven: org/mongodb/mongo-java-driver Extension: GitHub: liquibase/liquibase-mongodb Notes: Requires Liquibase Pro 4.20+
MySQL Server	8.0 5.7	DBMS/shortname: mysql File: mysql-connector-java-<version>.jar Class: NA JDBC URL: jdbc:mysql://<servername>:<port>/<dbname> Download: MySQL: MySQL Community Downloads: Connector/J
Oracle Database	23c 21c 19c 12.2	DBMS/shortname: oracle File: ojdbc<version>.jar Class: oracle.jdbc.OracleDriver JDBC URL: jdbc:oracle:thin:@<host>:<port>:<dbname> Download: Oracle: Oracle Database JDBC driver and Companion Jars Downloads Notes: For information about Kerberos and TNS connections, see Connecting to an Oracle Database with Liquibase via Kerberos and Active Directory.
Oracle Autonomous Database	19c	DBMS/shortname: oracle File: ojdbc<version>.jar Class: oracle.jdbc.OracleDriver JDBC URL: jdbc:oracle:thin:@<database_name>_high?TNS_ADMIN=/path/to/Wallet_<dbname> Download: Oracle: Oracle Database JDBC driver and Companion Jars Downloads Notes: Requires a configured wallet. To view an example, see Using Liquibase with Oracle Autonomous Database with ATP & ADW.
PostgreSQL	16 15 14 13 12	DBMS/shortname: postgresql File: postgresql-<version>.jar Class: org.postgresql.Driver JDBC URL: jdbc:postgresql://<host>:<port>/<dbname> Download: PostgreSQL: Download
Snowflake	Cloud	DBMS/shortname: snowflake File: snowflake-jdbc-<version>.jar Class: net.snowflake.client.jdbc.SnowflakeDriver JDBC URL: jdbc:snowflake://<account_ID>.snowflakecomputing.com/?<connection_params> Download: Maven: net/snowflake/snowflake-jdbc Notes: Requires additional files if using > 128 bit keys. For more information, see Using Liquibase with Snowflake.

Community-maintained databases

Many Liquibase features are also compatible with databases whose support is not officially maintained by Liquibase. Depending on the database, this functionality is built into Liquibase or contained in extensions separate from Liquibase Core.

For documentation on community-maintained databases, see the Liquibase Contribute Documentation site. For a full list of supported databases, see Supported Databases.

• Amazon Keyspaces
• Apache Cassandra
• Apache Cassandra on DataStax Astra DB
• Apache Derby
• Aerospike
• Azure Cosmos DB
• ClickHouse
• Cloud Spanner
• CockroachDB (on-premises)
• CockroachDB (cloud)
• Databricks
• Firebird RDBMS
• Greenplum Database
• H2 Database Engine
• HarperDB
• Hibernate
• HyperSQL Database (HSQLDB)
• IBM DB2 for i
• IBM DB2 for z/OS
• Impala/Hive
• Informix
• Interbase
• InterSystems Caché
• MongoDB Community Extension
• Neo4j Graph Database
• Oracle Timesten
• Percona Distribution for MySQL
• Percona XtraDB Cluster
• Percona Toolkit
• Phoenix/HBase
• SAP Adaptive Server Enterprise (Sybase ASE)
• SAP HANA
• SAP MaxDB
• SAP SQL Anywhere
• SingleStoreDB
• SQLite
• Teradata Database
• Vertica
• VMware vFabric SQLFire
• VoltDB
• YugabyteDB

Related links

• Liquibase: Supported Databases
• Liquibase: Database Verification Levels
• Liquibase GitHub: A Harness of Integration Tests.
• Change Types
• Concepts
• Liquibase Commands
• Workflows
  • Liquibase Pro Workflows
  • Developer Workflow