Adminer

Database management in a single PHP file

Adminer is available for:MySQL,MariaDB,PostgreSQL,CockroachDB,SQLite,MS SQL,Oracle.Others can be added via plugin:Elasticsearch,SimpleDB,MongoDB,Firebird,Clickhouse.

See:Features,Requirements,Skins,References

Download
v 5.4.1, 2025-09-26

Screenshots

Screencast about Adminer features and using plugins (19:31, bySrigi)

Downloads

Adminer 5.4.1 (.php, 496 kB),English only (.php, 321 kB)
Adminer 5.4.1 for MySQL (.php, 400 kB),English only (.php, 232 kB)
Source codes (.zip, 861 kB),Current development version
Donate:Paypal,GitHub,Patreon
Latest stable version (use e.g. bywget):https://www.adminer.org/latest[-mysql][-en].php
Change log,blog
User contributed packages:Docker,Debian package,Wordpress plugin,Drupal module,Arch Linux package,Dockette,Moodle plugin,CMS Made Simple Module,Laravel,Laravel,Laravel,Electron,Jaxon,Omeka
Older versions

Features

Connect to a database server with username and password
Select an existingdatabase or create a new one
List fields, indexes, foreign keys and triggers of table
Change name, engine, collation, auto_increment and comment oftable
Alter name, type, collation, comment and default values ofcolumns
Add and drop tables and columns
Create, alter, drop and search byindexes including fulltext
Create, alter, drop and link lists byforeign keys
Create, alter, drop and select fromviews
Create, alter, drop and callstored procedures and functions
Create, alter and droptriggers
List data in tables with search, aggregate, sort and limit results
Insert newrecords, update and delete the existing ones
Supports alldata types, blobs through file transfer
Execute anySQL command from a text field or a file
Export table structure, data, views, routines, databases to SQL or CSV
Printdatabase schema connected by foreign keys
Showprocesses and kill them
Displayusers and rights and change them
Displayvariables with links to documentation
Supportgenerated columns,check constraints
Manageevents andtable partitions (MySQL 5.1)
Schemas, sequences, user types (PostgreSQL)
Extensivecustomization options

Requirements

Works withMySQL,MariaDB,PostgreSQL,CockroachDB,SQLite,MS SQL,Oracle
Plugins: Elasticsearch, SimpleDB, MongoDB, Firebird, ClickHouse, IGDB, IMAP -Improve your driver
Supports PHP 5.3+, 7 and 8 with enabled sessions
Available in many languages(46) -Create a new translation
Free for commercial and non-commercial use (Apache License orGPL 2)

Security is #1 priority in development of Adminer. Adminer does not allow connecting to databases without a password and it rate-limits the connection attempts to protect against brute-force attacks. Still, consider making Adminer inaccessible to public by whitelisting IP addresses allowed to connect to it, password-protecting the access in your web server, enabling securityplugins (e.g. to require anOTP) or by customizing thelogin method. You can also delete Adminer if not needed anymore, it is just one file which is easy to upload in the future. Adminer had some security bugs in the past so update whenever Adminer tells you there is a new version available (ask your administrator if you could not update yourself).More information