Adminer

Adminer is an open-source database management tool written in PHP. It is designed as a web application that consists of a single file, which allows for deployment to a target server by uploading one script. This architecture removes the need for complex installation processes or the management of extensive directory structures on the host server.

The software provides a graphical user interface for managing various database systems via a web browser. It includes a separate component called Adminer Editor, which is specifically designed to offer data manipulation capabilities for end-users who do not require full administrative access to the database schema or server settings.

Key features

• Support for MySQL, MariaDB, PostgreSQL, CockroachDB, SQLite, MS SQL, and Oracle
• Plugin support for Elasticsearch, SimpleDB, MongoDB, Firebird, ClickHouse, and IMAP
• Single file deployment for easy server installation
• Data manipulation interface via Adminer Editor
• Compatibility with PHP 5.3 and newer for compiled versions
• Support for multiple languages through a translation system
• Extensibility through a library of distributed and user-contributed plugins

The application is built to run on any server with PHP installed, requiring PHP 7.4 or newer when running from source codes. It utilizes a specific compilation script to merge its various components into a single executable PHP file, which simplifies the process of moving the tool between different environments. The system architecture supports a wide range of relational and non-relational databases through its core logic and a flexible plugin system that expands its utility to other data stores.

For developers working with the source code, the project includes a set of Katalon Recorder test suites and a dedicated translation file to maintain global accessibility. The inclusion of the Adminer Editor allows administrators to create a restricted environment where users can edit data without risking the integrity of the underlying database structure.

Adminer serves as a lightweight tool for developers and database administrators who require a web-based interface for database administration.