Adminer

Adminer is a lightweight, single-file database management tool that serves as a compact alternative to phpMyAdmin. It provides a comprehensive web interface for managing multiple database systems including MySQL, PostgreSQL. Adminer stands out for its simplicity of deployment, high performance, and extensive database support.

Key Features and Benefits

• Lightweight and Simple. Single PHP file under 500 KB, making installation and updates effortless.
• Multi-Database Support. Unified interface for MySQL, PostgreSQL.
• Complete Database Management. Create, modify, and delete databases, tables, views, indexes, triggers, and stored procedures.
• Advanced SQL Editor. Execute arbitrary SQL queries with syntax highlighting and auto-completion features.
• Data Import and Export. Support for various formats including SQL, CSV, TSV with compression capabilities.
• Security Features. Built-in CSRF protection, SSL connection support, and IP-based access restrictions.
• Extensibility. Plugin system for adding custom functionality and interface customization.
• High Performance. Optimized queries and minimal server resource consumption.

1. Make sure you have a deployed Managed Service for MySQL or Managed Service for PostgreSQL cluster.
2. Create a service account with the roles compute.editor, iam.serviceAccounts.admin, resource-manager.admin, vpc.admin (the admin role includes all the specified roles).
3. In the management console select the Cloud Apps service.
4. In the left panel, select Application Store.
5. Select Adminer and click the Use button.
6. Specify:
   • Application name.
   • (Optional) Application description.
   • The service account created earlier.
   • Specify Database type and cluster you want to access through Adminer.
   • The cloud subnet from the same VPC network where the selected cluster is located.
   • TLS connection setup method for Adminer:
     • Certificate Manager — select a certificate from Certificate Manager (the service will help you issue a publicly trusted Let’s Encrypt certificate or you can upload your own issued certificate)
     • Self-Signed — issue a self-signed certificate; in this case, you can optionally specify a Hostname for which the self-signed certificate will be issued.
   • IP address mask from which access to Adminer will be opened; if the field is left empty — there will be no additional IP restrictions.
7. Click the Install button and wait for the application to install.
8. Follow the link in the Output parameters section on the application page (the application may be unavailable for a few minutes after installation). If a self-signed certificate is used, the browser will display a security warning — confirm to proceed.
9. Enter the Database Name (optional for some database types), Username and Password for the database and use the application.

• Web-based administration of databases.
• Execution and testing of SQL queries.
• Data backup and restoration via import/export features.
• Management of database users and access privileges.
• Visualizing database schemas and table relationships.

Yandex Cloud technical support is available 24/7. The types of requests you can submit and the appropriate response time depend on your pricing plan. You can switch to the paid support plan in the management console. You can learn more about the technical support terms here.