Inspired by phpMyAdmin and phpPgAdmin, ThyDbAdmin aims to integrate a database management tool into your Spring Boot application.
implementation 'org.padler:thyDbAdmin:1.3.0'
<dependency>
<groupId>org.padler</groupId>
<artifactId>thyDbAdmin</artifactId>
<version>1.3.0</version>
</dependency>
Enable thyDbAdmin Controllers (without this you can access the services but not the /thyDbAdmin URLs)
thyDbAdmin:
controller: true
Disable Flyway auto configuration, in case of a FlywayException on startup
thyDbAdmin:
saveMode.enabled: true
Let only "ADMIN" users access thyDbAdmin
@Override
protected void configure(HttpSecurity http) throws Exception {
http
.authorizeRequests()
.antMatchers("/thyDbAdmin/**").hasRole("ADMIN");
}
Go to http://localhost:8080/thyDbAdmin
Overview of the tables:
Query result:
Database information:
