Adminer
|
Category : dbtools
Version : 4.8.1
Views : 162605 Views
Ratings : 4.528 out of 5
Votes : 36 Votes
Reviews : 0 Reviews
Space Required : 0.47 MB
|
|
Overview

Adminer is a full-featured database management tool written in PHP.
Conversely to phpMyAdmin, Adminer consist of a single file ready to deploy to the target server. Adminer is available for MySQL, PostgreSQL, SQLite, MS SQL and Oracle.
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
- Alter export for projecting changes to production database
- 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
|