Database Administration Tool

The module integrates Adminer and Editor into Drupal to allow for a fast and easy management of the database.

Adminer (formerly phpMinAdmin) is a full-featured database management tool written in PHP. Adminer and Editor is both easy-to-use and user-friendly database data editing tool. It is suitable for common users, as it provides high-level data manipulation.

Adminer 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
• Display users and rights and change them (limited)
• Manage events and table partitions (MySQL 5.1)
• Schemas, sequences, user types (PostgreSQL)
• Extensive customization options
• Multilanguage

Both Adminer and Editor offers support for extensions. It is possible to overwrite some default Adminer functionality by a custom code. All you need is to add your AdminerPlugin.
Adminer API.

Works with MySQL, MariaDB, PostgreSQL, SQLite, MS SQL, Oracle, SimpleDB, Elasticsearch, MongoDB.

Requirements: PHP7.