Adminer
adminer.org
- Free plan
- Linux
- Web
- Self-hosted
What Adminer is
Adminer is database management software distributed as a single PHP file and used through the web. It works with MySQL, MariaDB, PostgreSQL, CockroachDB, SQLite, MS SQL and Oracle, with plugin drivers extending support to Elasticsearch, SimpleDB, MongoDB, Redis, Firebird, ClickHouse, IGDB and IMAP. Users can create and change database structures, including tables, indexes, views, procedures, functions and triggers. They can also search, sort and limit table results, edit records, run SQL, review query history, and export data to SQL or CSV. Its listed database features 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, such as through IP whitelisting or web-server password protection, and keeping the software updated. It supports PHP 5.3+, 7 and 8 with sessions enabled, and is free for commercial and non-commercial use under the Apache License or GPL 2.
Who it suits
Adminer suits people who need web-based database administration across its supported database systems. Adminer Editor is described as suitable for common users who need high-level data manipulation.
Good to know, and what to watch
- Supports MySQL, PostgreSQL, SQLite, and other databases.
- Edits records and runs SQL queries.
- Exports results to SQL or CSV.
- Free for commercial and non-commercial use.
- Plugins can add login and connection options.
- Requires PHP with sessions enabled.
- Adminer Editor supports one database per instance.
- Adminer Editor lacks SQL command editing and display.
Plans
Every plan and priceFree
Free plan
Getting started
- Open the Adminer website
- Place the single PHP file on a web server
- Use PHP 5.3+, 7 or 8 with sessions enabled
- Restrict access with IP whitelisting or web-server password protection
- Connect with a database password
Limits to check
Adminer Editor is limited to one database per instance and omits SQL command editing and display.
The verdict
Adminer combines database structure management, data editing, queries, and exports in a single PHP file. Review its public-access guidance and the Adminer Editor limits when choosing how to use it.
Questions people ask
How much does Adminer cost?
Adminer is free, including for commercial and non-commercial use, under the Apache License or GPL 2.
Which databases does it support?
It supports MySQL, MariaDB, PostgreSQL, CockroachDB, SQLite, MS SQL and Oracle. Plugins add drivers for several other systems.
Where can Adminer run?
It runs as a web application on Linux or other self-hosted web infrastructure, using PHP 5.3+, 7 or 8 with sessions enabled.
Can it export data?
Yes. Data can be exported to SQL or CSV.
Does it offer extra security features?
The core requires a database password and rate-limits connection attempts. Plugins can add OTP or passkey login and SSL connections.
What the maker publishes
- Customization
- Plugins can add features such as OTP login, passkey login, SSL connections, SQL syntax highlighting and additional export formats. source
- Database features
- The feature list includes generated columns and check constraints, MySQL events and partitions, and PostgreSQL schemas, sequences and user types. source
- Database operations
- It can create and alter tables, columns, indexes, foreign keys, views, stored procedures, functions and triggers. source
- Database support
- Adminer works with MySQL, MariaDB, PostgreSQL, CockroachDB, SQLite, MS SQL and Oracle. source
- Data handling
- It supports searching, sorting and limiting table results, editing records, running SQL, and exporting to SQL or CSV. source
- Integrations
- The site lists user-contributed packages for Docker, cPanel, Easypanel, WordPress, Drupal, Moodle, Laravel and Electron, among others. source
- Intended users
- Adminer Editor is described as suitable for common users who need high-level database data manipulation. source
- Licensing
- Adminer is free for commercial and non-commercial use under either the Apache License or GPL 2. source
- Notable limit
- Adminer Editor supports one database per instance and does not provide SQL command editing or display. source
- Plugin drivers
- Plugins add drivers for Elasticsearch, SimpleDB, MongoDB, Redis, Firebird, ClickHouse, IGDB and IMAP. source
- Purpose
- Adminer is database management software distributed as a single PHP file. source
- Runtime requirements
- Adminer supports PHP 5.3+, 7 and 8 with sessions enabled. source
- Security
- Adminer requires a database password and rate-limits connection attempts to protect against brute-force attacks. source
- Security guidance
- The site recommends restricting public access, for example with IP whitelisting or web-server password protection, and keeping Adminer updated. source
- Support channels
- The site links to user forums and a bug tracker on GitHub. source
Checked against the maker's pages on 7 Oct 2026.