Adminer

Adminer (formerly phpMinAdmin) is a full-featured database management tool written in a single PHP file. It supports MySQL, MariaDB, PostgreSQL, SQLite, MS SQL, Oracle, Elasticsearch, and MongoDB, making it far more versatile than phpMyAdmin which only covers MySQL and MariaDB.

The single-file deployment is Adminer's most distinctive feature. The entire application is one PHP file (about 500KB) that you upload to your server and access through a web browser. No installation, no configuration, no dependencies beyond PHP itself. This makes it incredibly easy to deploy for quick database tasks and just as easy to remove when done.

Despite its compact size, Adminer provides a comprehensive feature set: table creation and modification, data browsing and editing, SQL query execution, import and export (SQL, CSV, XML), user management, table relationships, stored procedures, triggers, views, and events. The interface is clean and fast, loading noticeably quicker than phpMyAdmin on the same server.

Adminer includes security features that phpMyAdmin lacks by default. It requires authentication on every access (no config-based auto-login), rate-limits failed login attempts, and the single-file nature means there are fewer potential vulnerability vectors compared to phpMyAdmin's thousands of files.

For hosting providers, Adminer serves as a lightweight alternative or supplement to phpMyAdmin. Some providers include it on servers for quick admin database tasks, while others offer it to customers who prefer a lighter interface. It is particularly useful on resource-constrained servers where phpMyAdmin's memory footprint is a concern.

The plugin system and theme support allow customization despite the single-file approach. Popular plugins add features like JSON column editing, enum value suggestions, and foreign key editing. Themes change the visual appearance to match different preferences.