Skip to the content
Know your tech before you buy it. Makers: get listed from $49/mo

Adminer

adminer.org

  • Free plan
  • Linux
  • Web
  • Self-hosted
7.3 Club score Visit adminer.org

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.

Free

Free

Free plan

Getting started

  1. Open the Adminer website
  2. Place the single PHP file on a web server
  3. Use PHP 5.3+, 7 or 8 with sessions enabled
  4. Restrict access with IP whitelisting or web-server password protection
  5. 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.