Adminer
Adminer is a tool for managing content in databases. It natively supports MySQL, MariaDB, PostgreSQL, SQLite, MS SQL, Oracle, Elasticsearch and MongoDB. Adminer is distributed under Apache license in a form of a single PHP file. Its author Jakub Vrána started to develop this tool in July 2007 as a light-weight alternative to phpMyAdmin. Adminer got some attention in 2008 when it made it to the CCA finals at SourceForge. Also, first webhosting providers started to include Adminer as MySQL managing tool into their portfolio of services. In 2012 Adminer got coverage on Linux.com for the second time. The project's priorities, according to its author, are : safety, user-friendliness, performance, functionality, and size.
Features
- Users log in specifying the destination server and providing the user name and password
- Basic functions: select database, select/edit tables, browse/insert/edit table rows
- Searching or sorting via multiple columns
- Editing of other database objects: views, triggers, events, stored procedures, processes, mysql variables, user permissions
- Text area for arbitrary SQL commands and storing these commands in command history
- Export of databases and tables as a dump to output or a downloadable attachment
- User-friendly interface
- Multiple language support
- SQL syntax highlighting
- Visual database/E-R schema editing
- Countermeasures against XSS, CSRF, SQL injection, session-stealing,...
- "Light-weight" – released in a form of a single file
- Support of CSS "skins", as well as many extensions