LiquiBase for IntelliJ IDEA
The LiquiBase IntelliJ plugin allows you to refactor your database as easily and visually as you refactor your code. Install the LiquiBase plug-in through the standard IntellJ plug-in manager.
The LiquiBase plugin builds on the DBHelper plug-in by adding a “Refactor” and a “LiquiBase” context menu to the database explorer.
Demonstration
Two demonstration videos of the LiquiBase IntelliJ plugin in action can be seen on the training page.
Refactor Menu
The “refactor” menu contains all the supported LiquiBase database refactorings. The refactorings that are enabled depend on the type of database object you have selected. Selecting a refactoring will open a wizard in which you can specify any refactoring-specific information, along with change set specific information such as “id” and “author”. See the changeSet manual page for more information on the available settings.
Supported Refactorings
Unsupported Refactorings
The following refactorings cannot be created automatically through the IntelliJ plug in, but can be added to the change log file automatically and executed through the plug-in.
LiquiBase Menu
The “LiquiBase” menu contains non-refactoring commands supported by the IntelliJ plug-in.
Currently supported commands
| Change Log Status | Outputs report of what changes have not been run |
|---|---|
| Clear Checksums | LiquiBase tracks a checksum of each change made to the database. This command will clear that tracking |
| Create Empty Change Log | Generates an emtpy change log XML file |
| Drop All Objects | Drops all database objects belonging to the connected user |
| Generate Complete Change Log | Generates a change log for building up the selected database |
| Generate DbDoc | Generates DbDoc documentation |
| Generate Migration SQL | Generates SQL required to update the database |
| Generate SQL to Roll Back Unrun Changes | Generates SQL required to roll back un-run changes after they have been executed |
| List LiquiBase Locks | LiquiBase uses a locking mechanism to control updates from multiple instances. This command lists those locks |
| Release LiquiBase Locks | Clear LiquiBase locks |
| Rollback Changes | Rolls back a given number of changes |
| Rollback Changes (Generate SQL) | Generate SQL to roll back a given number of changes |
| Rollback to Date | Rolls back database to a given date |
| Rollback to Date (Generate SQL) | Generate SQL to roll back database to a given date |
| Rollback to Tag | Rolls back database to a given tag |
| Rollback to Tag (Generate SQL) | Generate SQL to roll back database to a given tag |
| Tag Database | Tag current database state for future rollback |
| Update Database | Applies all un-executed changes |
| Validate Change Log | Check change log files for errors |
More Information
For more information on LiquiBase, visit the main LiquiBase documentation including the Quick-Start guide and Manual.
Please direct any questions or issues to the mailing lists
