adminer
Database management in a single PHP file
A single PHP file you drop on any web server to get a full browser-based database manager supporting MySQL, PostgreSQL, SQLite, SQL Server, and more, no installation needed beyond PHP.
Adminer is a database management tool written in PHP that ships as a single file. You copy the file onto a web server, open it in a browser, and get a full-featured interface for working with database content: viewing and editing tables, running queries, importing and exporting data, and managing users and permissions.
Because the entire tool is a single file, there is nothing to install or configure beyond PHP being available on the server. This makes it straightforward to add database access to a project quickly, without setting up a heavier tool.
Adminer supports several database systems out of the box, including MySQL, MariaDB, PostgreSQL, CockroachDB, SQLite, Microsoft SQL Server, and Oracle. Additional database systems are supported through plugins, including Elasticsearch, MongoDB, ClickHouse, and Firebird. A plugins page on the official website lists both included and user-contributed extensions.
The project also includes a companion called Adminer Editor, a simpler interface intended for end users who need to view and edit data in tables but should not have access to the full administrative controls.
The compiled single-file version requires PHP 5.3 or newer. Working from the source code (the version in this repository) requires PHP 7.4 or newer, and cloning the repository requires running a git submodule command to pull in dependencies. A compile script generates the single-file distribution from the source.
Where it fits
- Add browser-based database access to a project by uploading one PHP file to your server
- Run SQL queries and edit table data without installing a desktop database tool
- Import and export database content in formats like SQL and CSV directly from the browser
- Manage database users and permissions on MySQL or PostgreSQL from a web interface