2bass is a database configuration-as-code tool that utilizes the concept of idempotent DDL scripts.

This is a derivative of Celesta project, in particular, it uses CelestaSQL as database definition language. Documentation for CelestaSQL is currently in Russian only, but syntax diagrams for the language are self-explanatory.

This project is in development phase. For binaries see releases, or see [How to build] if you want to build the freshest binary yourself. If you want to contribute (suggestions/feature requests are very welcome!) please feel free to contact any of the contributors.

You will need JDK 8 and Maven in order to build 2bass. If you want to run tests during the build, you will also need Docker to be installed. To build without compiling and running the tests, run

The result of the build will be target/2bass-<VERSION>-bin.zip file.

Prerequisites: JRE 8. Unzip target/2bass-<VERSION>-bin.zip file and make bin folder availiable on system path. Run bass command and check its output.

• Usage example is available at https://github.com/inponomarev/2bass-demo.

• Usage:

  bass <command> <options>

• Available commands are:

  • validate Parse and validate SQL scripts (with no connection to database).

  • init Initialize system bass schema.

  • plan Generate and show DDL execution plan for review / manual exectution.

  • apply Build or change database structure. Sync your actual DB structure with the desired structure described in your SQL files. All the ALTER commands are calculated and executed automatically. You may run apply without running init previously

• Options are:

  [--debug] [--jdbc.password=<password>] [--jdbc.url=<url>]
         [--jdbc.username=<username>] [--outputFilePath=<path>]
         [--propertiesFile=<path>] [--score.path=<path>]

  • --debug Debug mode: show exception stack traces

  • --jdbc.password=<password> Database password

  • --jdbc.url=<url> JDBC connection URL

  • --jdbc.username=<username> Database user name

  • --outputFilePath=<path> Path to write scripts to (for plan command)

  • --propertiesFile=<path> Path to .properties file with options (options set in command line have higher priority)

  • --score.path=<path> Path to SQL scripts

• Write and modify your database schema using CelestaSQL, which is in fact the plain old DDL. Е. g. you may use CREATE TABLE for table definition, and then simply add/modify columns in the script when you need it, no 'ALTER' commands in schema definition script. You may also use EXEC NATIVE blocks when you need to insert database-specific code. See our demo project and wiki page (in Russian, but with nice diagrams) about CelestaSQL.

• Example outputs for apply and plan commands: