Adminer
What it is
Adminer is free web-based database management software distributed as a single PHP file. It supports MySQL, MariaDB, PostgreSQL, CockroachDB, SQLite, MS SQL, and Oracle, with plugin drivers available for Elasticsearch, SimpleDB, MongoDB, Redis, Firebird, ClickHouse, IGDB, and IMAP. Users can create or modify database objects, including tables, columns, indexes, views, procedures, functions, and triggers. Data tools cover searching, sorting, and limiting results, editing records, running SQL, viewing query history, and exporting to SQL or CSV. Listed database capabilities include generated columns and check constraints, MySQL events and partitions, and PostgreSQL schemas, sequences, and user types. Adminer requires a database password and limits repeated connection attempts. Its site recommends restricting public access, for example through IP whitelisting or web-server password protection, and keeping the software updated. Plugins can add options such as OTP or passkey login, SSL connections, syntax highlighting, and extra export formats. It supports PHP 5.3+, 7, and 8 with sessions enabled, and is licensed for commercial and non-commercial use under Apache or GPL 2.
For and against
For
- Free for commercial and non-commercial use.
- Distributed as a single PHP file.
- Supports multiple database systems.
- Exports data to SQL or CSV.
- Plugins can add login and connection options.
Against
- Requires PHP with sessions enabled.
- Public access should be restricted and the software kept updated.
- Adminer Editor handles one database per instance.
- Adminer Editor lacks SQL command editing and display.
The verdict
Adminer provides database structure and data tools in a single-file web application, with additional drivers and features available through plugins. Users should account for its PHP requirements and follow the site's guidance on limiting public access.
Who it suits
Adminer may suit people who want a compact web interface for managing supported databases and are able to run PHP with sessions enabled. Adminer Editor is described as suitable for common users needing high-level data manipulation.
Plans and prices
Free
Free for commercial and non-commercial use · PHP 5.3+, 7 and 8 with enabled sessions
Read 7 Oct 2026 · adminer.org
On the record
- Customization
- Plugins can add features such as OTP login, passkey login, SSL connections, SQL syntax highlighting and additional export formats.adminer.org · read 7 Oct 2026
- Database features
- The feature list includes generated columns and check constraints, MySQL events and partitions, and PostgreSQL schemas, sequences and user types.adminer.org · read 7 Oct 2026
- Database operations
- It can create and alter tables, columns, indexes, foreign keys, views, stored procedures, functions and triggers.adminer.org · read 7 Oct 2026
- Database support
- Adminer works with MySQL, MariaDB, PostgreSQL, CockroachDB, SQLite, MS SQL and Oracle.adminer.org · read 7 Oct 2026
- Data handling
- It supports searching, sorting and limiting table results, editing records, running SQL, and exporting to SQL or CSV.adminer.org · read 7 Oct 2026
- Integrations
- The site lists user-contributed packages for Docker, cPanel, Easypanel, WordPress, Drupal, Moodle, Laravel and Electron, among others.adminer.org · read 7 Oct 2026
- Intended users
- Adminer Editor is described as suitable for common users who need high-level database data manipulation.adminer.org · read 7 Oct 2026
- Licensing
- Adminer is free for commercial and non-commercial use under either the Apache License or GPL 2.adminer.org · read 7 Oct 2026
- Notable limit
- Adminer Editor supports one database per instance and does not provide SQL command editing or display.adminer.org · read 7 Oct 2026
- Plugin drivers
- Plugins add drivers for Elasticsearch, SimpleDB, MongoDB, Redis, Firebird, ClickHouse, IGDB and IMAP.adminer.org · read 7 Oct 2026
- Purpose
- Adminer is database management software distributed as a single PHP file.adminer.org · read 7 Oct 2026
- Runtime requirements
- Adminer supports PHP 5.3+, 7 and 8 with sessions enabled.adminer.org · read 7 Oct 2026
- Security
- Adminer requires a database password and rate-limits connection attempts to protect against brute-force attacks.adminer.org · read 7 Oct 2026
- Security guidance
- The site recommends restricting public access, for example with IP whitelisting or web-server password protection, and keeping Adminer updated.adminer.org · read 7 Oct 2026
- Support channels
- The site links to user forums and a bug tracker on GitHub.adminer.org · read 7 Oct 2026
