Adminer is a web application to administrate various databases (MySQL®, PostgreSQL®, MongoDB® and Elasticsearch®). It can be seen as a phpMyAdmin for more than just MySQL® databases.

The application is available on the platform to use alongside your databases:

• osc-fr1: Available at https://adminer.osc-fr1.scalingo.com

• osc-secnum-fr1: Not available for security reasons: only trusted users are allowed to deploy applications in this region. Adminer would be a way to reach internal databases without being authorized beforehand.

  Follow these instructions to connect directly to your database.

How to use Adminer

The Server, Username, Password and Database fields must be filled with the information in your SCALINGO_<DB type>_URL environment variable. This variable has the following form:

SCALINGO_<DB type>_URL=<scheme>://<username>:<password>@<server host>:<server port>/<DB name>

For example, if your variable is:

SCALINGO_POSTGRESQL_URL=postgres://app_5942:random_password@b11e65b8-b36a-4369-bcf6-73b6b9439e84.app-5942.postgresql.a.osc-fr1.scalingo-dbs.com:31313/app_5942?sslmode=prefer

You need to fill the Adminer form with these values:

• System: PostgreSQL,
• Server: b11e65b8-b36a-4369-bcf6-73b6b9439e84.app-5942.postgresql.a.osc-fr1.scalingo-dbs.com:31313,
• Username: app_5942,
• Password: random_password,
• Database: app_5942.

Note that the Server input must be in the form host:port.