Adminer is an open-source database management tool distributed in a single PHP file. It supports MySQL, PostgreSQL, SQLite, MS SQL and Oracle. It focuses mainly on security, user experience, performance and feature set.
Overview
Adminer (formerly phpMinAdmin) is a full-featured database management tool written in PHP. Conversely to phpmyadmin, it consist of a single file ready to deploy to the target server.
It is available for mysql postgresql sqlite mssql oracle simpledb elasticsearch and mongodb.
It focuses mainly on :
- security
- User experience
- Performance
- Feature set
- Size
Features
- Connect to a database server with username and password
- Select an existing database or create a new one
- List fields, indexes, foreign keys and triggers of table
- Change name, engine, collation, auto_increment and comment of table
- Alter name, type, collation, comment and default values of columns
- Add and drop tables and columns
- Create, alter, drop and search by indexes including fulltext
- Create, alter, drop and link lists by foreign keys
- Create, alter, drop and select from views
- Create, alter, drop and call stored procedures and functions
- Create, alter and drop triggers
- List data in tables with search, aggregate, sort and limit results
- Insert new records, update and delete the existing ones
- Supports all data types, blobs through file transfer
- Execute any SQL command from a text field or a file
- Export table structure, data, views, routines, databases to SQL or CSV
- Print database schema connected by foreign keys
- Show processes and kill them
- Display users and rights and change them
- Display variables with links to documentation
- Manage events and table partitions (MySQL 5.1)
- Schemas, sequences, user types (PostgreSQL)
- Extensive customization options
Requirements
- Works with MySQL, PostgreSQL, SQLite, MS SQL, Oracle, SimpleDB, Elasticsearch, MongoDB
- Supports PHP 5 with enabled sessions
- Available in Arabic, Catalan, Chinese, Czech, Dutch, English, Estonian, French, German, Hungarian, Italian, Japanese, Lithuanian, Persian, Polish, Portuguese, Romanian, Russian, Serbian, Slovak, Slovenian, Spanish, Tamil, Turkish, Ukrainian, ... (32)
- Free for commercial and non-commercial use (Apache License or GPL 2)
