Using an ApsaraDB for RDS Client with Auto-Completion Features

MyCLI is a command line interface (CLI) for MySQL, MariaDB, and Percona with auto-completion and syntax highlighting features. This tool support auto-completion of table names, database names, aliases, and SQL syntax. It also keeps track of the queries entered for your convenience.

You’ll need to use the pip command to install it on Linux or Unix-like system as MyCLI is written in Python. You can learn more about MyCLI here http://mycli.net/

MyCLI is fully compatible with Alibaba Cloud. To use it, first launch an Elastic Compute Service (ECS) instance where you want to deploy the client to. Make sure that this ECS instance is whitelisted for ApsaraDB for RDS access. You can set up the whitelist using this guide.

Prerequisites

MyCLI tool is based on Python and needs to be installed via pip. Make sure PIP and python development libraries are installed. If you have set up your ECS instance correctly, just run these three lines of codes to install MyCLI.

Details of MyCLI

If you’re not sure how to use MyCLI, you can always run the --help command to learn about its various options, as shown below.

Usage Examples

Just run the command below to run MyCLI on your ApsaraDB for RDS instance.

Once connected, you can use MyCLI just as you would use your default CLI.

Further Reading

Alibaba Cloud also provides its own command auto-completion function on the Alibaba Cloud CLI. To learn more, visit https://www.alibabacloud.com/help/doc-detail/29998.html

Reference:

https://www.alibabacloud.com/blog/using-an-apsaradb-for-rds-client-with-auto-completion-features_593884?spm=a2c41.11873495.0.0

Follow me to keep abreast with the latest technology news, industry insights, and developer trends.

Follow me to keep abreast with the latest technology news, industry insights, and developer trends.