JAdmin - Database Administration Module

JAdmin is a lightweight, web-based database administration tool designed to provide a simple and efficient way to manage MySQL and PostgreSQL databases through a modern web interface. JAdmin offers database management capabilities in a compact, standalone module.

Database Support

PostgreSQL and MySQL

Quick start

1. Download from Releases .jar and .yml

2. Configuration

jadmconf.yml standard config (should be located next to .jar):

jadm:
  database:
    type: postgres  # or "mysql"
    url: jdbc:postgresql://localhost:5432/your_database
    username: db_user
    password: db_pass
  admin:
    username: admin
    password: admin

3. Run and use

Run the application

java -jar jadmin.jar

Open the http://localhost:8080

Login with the credentials specified in jadmconf.yml

Usage

Dashboard

• View all database tables with row counts
• Click on any table to open detailed view

Table View

• Execute custom SQL queries
• View query results in a formatted table
• Support for both SELECT and UPDATE/INSERT/DELETE operations
• Real-time error reporting

Security

• CSRF protection enabled
• Session-based authentication
• Configurable admin credentials

Configuration Options

Database Configuration

• type: Database type (postgres or mysql)
• url: JDBC connection URL
• username: Database username
• password: Database password

Admin Configuration

• username: Admin login username
• password: Admin login password