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:
- Introduction to Liquibase: Dive into Liquibase concepts.
- Install Liquibase: Download Liquibase on your machine.
- Ensure Java is installed: Liquibase requires Java to run. If you used the Liquibase Installer, Java is included automatically. Otherwise, you must install Java manually.
- Get Started with Liquibase: Learn how to use Liquibase with an example database.
- Design Your Liquibase Project: Create a new Liquibase project folder and organize your changelogs.
- 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 |
|
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 |
|
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 |
|
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 |
|
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 |
|
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 |
|
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 |
|
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 |
|
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 |
|
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 |
|
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 |
|
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 |
|
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 |
|
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 |
Databricks SQL |
|
DBMS/shortname: databricks File: liquibase-databricks JDBC URL: jdbc:databricks://<your_workspace_host_name>:443/default;transportMode=http;ssl=1;AuthMech=3;httpPath=/sql/1.0/warehouses/<your_warehouse_id>;ConnCatalog=<your_catalog>;ConnSchema=<your_schema>; Download: GitHub: liquibase/liquibase-databricks |
EnterpriseDB |
|
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 |
|
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 Cloud SQL – MSSQL |
|
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 |
|
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 |
|
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 |
|
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 |
|
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 |
|
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 |
|
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 |
|
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 |
|
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 |
|
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 |
|
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 |
|
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 |
|
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 |
|
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 |
|
DBMS/shortname: postgresql File: postgresql-<version>.jar Class: org.postgresql.Driver JDBC URL: jdbc:postgresql://<host>:<port>/<dbname> Download: PostgreSQL: Download |
Snowflake |
|
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