Skip to main content

Adminer

1-Click installation template for Adminer on Easypanel

Description​

Adminer is a comprehensive database management tool, designed to simplify and streamline your database operations. Written in PHP, it is a lightweight yet powerful tool that supports a wide range of databases including MySQL, MariaDB, PostgreSQL, SQLite, MS SQL, Oracle, Elasticsearch, MongoDB and others. With Adminer, you can easily connect to a database server using a username and password, select an existing database or create a new one, and manage all aspects of your database including tables, columns, indexes, foreign keys, triggers, views, stored procedures, and functions. It also allows you to execute any SQL command from a text field or a file, and export your database structure, data, views, routines, and databases to SQL or CSV. Adminer prioritizes security, user experience, performance, feature set, and size, making it a reliable and efficient tool for all your database management needs.

Benefits​

  • Efficient Database Management: Adminer is a full-featured database management tool that provides a tidier user interface, better support for MySQL features, higher performance, and more security than other similar tools.
  • Versatile Compatibility: Adminer is available for a wide range of databases including MySQL, MariaDB, PostgreSQL, SQLite, MS SQL, Oracle, Elasticsearch, MongoDB and others via plugin.
  • Prioritized Security: Adminer places security as its top priority. It does not allow connecting to databases without a password and it rate-limits the connection attempts to protect against brute-force attacks.

Features​

  • Comprehensive Database Operations: Adminer allows you to 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, and alter name, type, collation, comment and default values of columns.
  • Advanced Table and Column Management: With Adminer, you can add and drop tables and columns, create, alter, drop and search by indexes including fulltext, create, alter, drop and link lists by foreign keys, and create, alter, drop and select from views.
  • Procedures, Functions, and Triggers: Adminer enables you to create, alter, drop and call stored procedures and functions, create, alter and drop triggers.
  • Data Management: Adminer lets you list data in tables with search, aggregate, sort and limit results, insert new records, update and delete the existing ones, and supports all data types, blobs through file transfer.
  • SQL Command Execution: Adminer allows you to execute any SQL command from a text field or a file.
  • Data Export: Adminer provides the ability to export table structure, data, views, routines, databases to SQL or CSV.
  • User and Rights Management: Adminer displays users and rights and allows you to change them.
  • Event and Partition Management: Adminer enables you to manage events and table partitions.
  • Customization Options: Adminer offers extensive customization options.

Options​

NameDescriptionRequiredDefault Value
App Service Name-yesadminer
App Service Image-yesadminer:4.8.1

Screenshots​

Adminer Screenshot

Change Log​

  • 2022-07-12 – first release

Contributors​

Subscribe for product updates

By subscribing, you agree with our Terms and Privacy Policy.