gitmyhub

adminer

PHP ★ 7.4k updated 3mo ago

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.

PHPsetup: easycomplexity 2/5

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