# Deploy Adminer with Easypanel

URL: /templates/adminer

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.

## Configuration

- `appServiceName` (App Service Name, required): adminer

- `appServiceImage` (App Service Image, required): adminer:5.4.2

## Services

- adminer: app (adminer:5.4.2)

## Resources

- [Website](https://www.adminer.org/)

- [Github](https://github.com/vrana/adminer/)

- [Template source](https://github.com/easypanel-io/templates/tree/main/templates/adminer)