DB Constructor

Try it - https://db-constructor.herokuapp.com

It's a web application that allows you to configure the database in a user-friendly interface. That is, you can create a table, add the necessary requisites to it, and then fill it with records. All tables are actually created in the database (app sends native queries instead of you). The logic and idea are borrowed from the salesforce platform.

Additionally, a REST API interface has been implemented. Here is the documentation

How to start:

You can connect any database and choose any provider.

To start, change connection properties here src/main/resources/application.properties

Stack:

1. Java 17
2. Spring Boot, Web, JDBC, JPA, Security
3. Hibernate
4. PostgreSQL
5. JUnit
6. Thymeleaf
7. Jackson
8. Bootstrap
9. Little JS and jQuery 😄

Images:

Click to open