Interactive Remote Console
This page details how to use the Remote Console method from Access Your Database.
Availability
The Remote Console is available for supported Shared Resources databases only:
- PostgreSQL
- MySQL
- MongoDB
- Redis
- InfluxDB
It is not available for OpenSearch or Dedicated Resources databases.
Open a Remote Console
# Open a console using the `mysql` client
scalingo --app my-app mysql-console
# Open a console using the `psql` client
scalingo --app my-app pgsql-console
# Open a console using the `mongo` client
scalingo --app my-app mongo-console
# Open a console using the `redis-cli` client
scalingo --app my-app redis-console
# Open a console using the `InfluxDB shell` client
scalingo --app my-app influxdb-console
Make sure you have already added the corresponding addon from your application dashboard before running one of these commands.
Manually Install the Databases CLI in a One-off
If you started a Bash process in a one-off container, you can download various CLI tools for the supported databases listed below:
| Database | Keyword | Installed Tools |
|---|---|---|
| PostgreSQL |
pgsql, postgresql, psql
|
psql, pg_basebackup, pg_controldata, pg_dump, pg_isready, pg_recvlogical, pg_restore, pg_test_fsync, pg_upgrade, pg_archivecleanup, pg_config, pg_ctl, pg_dumpall, pg_receivewal, pg_resetwal, pg_rewind, pg_test_timing, pg_waldump
|
| MySQL | mysql |
mysql, mysqldump
|
| MongoDB | mongo |
mongo, mongodump, mongorestore, mongoexport, mongoimport
|
| Redis | redis |
redis-cli |
| InfluxDB |
influxdb, influx
|
influx |
You can use our utility tool dbclient-fetcher to download and install the
tools for your database. To do so, call dbclient-fetcher with the keyword
corresponding to your database (see table above).
For example, to download the tools to interact with your MySQL addon:
[10:48] Scalingo ~ $ dbclient-fetcher mysql
---> Download and extract the database CLI
---> Database CLI installed:
mysql Ver 8.0.33 for Linux on x86_64 (Source distribution)
If you ever need a specific version, just add it as a second parameter:
[10:48] Scalingo ~ $ dbclient-fetcher mysql 8.0
---> Download and extract the database CLI
---> Database CLI installed:
mysql Ver 8.0.33 for Linux on x86_64 (Source distribution)