Skip to content
SPECIFICTION
Get listed

Adminer

adminer.org

Free plan WebLinuxSelf-hosted
Visit adminer.org
Spec score 8.2 #4 of 34 in Database Administration Tools

What it is

Adminer is web-based database management software distributed as a single PHP file. It supports MySQL, MariaDB, PostgreSQL, CockroachDB, SQLite, MS SQL, and Oracle; plugin drivers add Elasticsearch, SimpleDB, MongoDB, Redis, Firebird, ClickHouse, IGDB, and IMAP. Users can create and alter database structures, including tables, columns, indexes, foreign keys, views, procedures, functions, and triggers. The interface can search, sort, and limit table results, edit records, run SQL, review query history, and export 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 rate-limits connection attempts. Its site recommends restricting public access, for example with IP whitelisting or web-server password protection, and keeping the software updated. Plugins can add options such as OTP or passkey login, SSL connections, SQL highlighting, and extra export formats. It supports PHP 5.3+, 7, and 8 with sessions enabled. Adminer is free for commercial and non-commercial use under either the Apache License or GPL 2.

Spec sheet

Purpose
Adminer is database management software distributed as a single PHP file.Read 7 Oct 2026 · adminer.org
Intended users
Adminer Editor is described as suitable for common users who need high-level database data manipulation.Read 7 Oct 2026 · adminer.org
Integrations
The site lists user-contributed packages for Docker, cPanel, Easypanel, WordPress, Drupal, Moodle, Laravel and Electron, among others.Read 7 Oct 2026 · adminer.org
Security
Adminer requires a database password and rate-limits connection attempts to protect against brute-force attacks.Read 7 Oct 2026 · adminer.org
Customization
Plugins can add features such as OTP login, passkey login, SSL connections, SQL syntax highlighting and additional export formats.Read 7 Oct 2026 · adminer.org
Data handling
It supports searching, sorting and limiting table results, editing records, running SQL, and exporting to SQL or CSV.Read 7 Oct 2026 · adminer.org
Database features
The feature list includes generated columns and check constraints, MySQL events and partitions, and PostgreSQL schemas, sequences and user types.Read 7 Oct 2026 · adminer.org
Database operations
It can create and alter tables, columns, indexes, foreign keys, views, stored procedures, functions and triggers.Read 7 Oct 2026 · adminer.org
Database support
Adminer works with MySQL, MariaDB, PostgreSQL, CockroachDB, SQLite, MS SQL and Oracle.Read 7 Oct 2026 · adminer.org
Licensing
Adminer is free for commercial and non-commercial use under either the Apache License or GPL 2.Read 7 Oct 2026 · adminer.org
Notable limit
Adminer Editor supports one database per instance and does not provide SQL command editing or display.Read 7 Oct 2026 · adminer.org
Plugin drivers
Plugins add drivers for Elasticsearch, SimpleDB, MongoDB, Redis, Firebird, ClickHouse, IGDB and IMAP.Read 7 Oct 2026 · adminer.org
Runtime requirements
Adminer supports PHP 5.3+, 7 and 8 with sessions enabled.Read 7 Oct 2026 · adminer.org
Security guidance
The site recommends restricting public access, for example with IP whitelisting or web-server password protection, and keeping Adminer updated.Read 7 Oct 2026 · adminer.org
Support channels
The site links to user forums and a bug tracker on GitHub.Read 7 Oct 2026 · adminer.org

Plans and prices

Free Free Free for commercial and non-commercial use · PHP 5.3+, 7 and 8 with enabled sessions Read 7 Oct 2026 · adminer.org

Every Adminer plan and price →

Strong points and limits

Strong points

  • Free for commercial and non-commercial use
  • Distributed as a single PHP file
  • Supports seven listed database systems
  • Exports data to SQL or CSV
  • Plugins add drivers and authentication options

Limits

  • Requires PHP with sessions enabled
  • Adminer Editor supports one database per instance
  • Adminer Editor does not provide SQL command editing or display
  • The site recommends restricting public access

Who it suits

Adminer suits people who need a web interface for managing supported databases and are comfortable running PHP. Adminer Editor is described for common users who need high-level data manipulation, but it supports only one database per instance.

Verdict

Adminer covers database structure changes, data editing, SQL queries, and exports in a compact web-based package. Secure deployment requires attention to the site's access restrictions and update guidance.

Where Specifiction places it

Alternatives to AdminerAll alternatives →