Connect DBeaver Community to ApsaraDB for SelectDB to manage your databases visually—browsing schemas, running SQL queries, and inspecting table data without writing CLI commands.
Prerequisites
Before you begin, ensure that you have:
Network access configured based on where DBeaver runs:
If DBeaver runs on an Elastic Compute Service (ECS) instance in the same virtual private cloud (VPC) as your ApsaraDB for SelectDB instance, no extra network setup is needed. Get the VPC endpoint of the instance.
In all other cases, apply for a public endpoint for the instance. See Apply for or release a public endpoint.
DBeaver Community downloaded and installed from dbeaver.io. The database driver must be compatible with MySQL 5.7.
The IP address of your DBeaver host added to the IP address whitelist of the ApsaraDB for SelectDB instance. See Configure an IP address whitelist.
Login credentials (username and password) for the ApsaraDB for SelectDB instance.
1. Gather your connection details
Before opening DBeaver, collect the following from the Instance Details page of your ApsaraDB for SelectDB instance. All values are in the Network Information section.
| Detail | Where to find it | Example |
|---|---|---|
| Endpoint | VPC endpoint or public endpoint in Network Information | selectdb-cn-xxx-public.selectdbfe.rds.aliyuncs.com |
| Port | MySQL port number in Network Information | 9030 |
| Database name | The database you want to connect to | test_db |
| Username | Your instance login username | admin |
| Password | Your instance login password. If forgotten, click Reset Password on the Instance Details page | — |
2. Add a MySQL connection in DBeaver
Open DBeaver Community.
In the top navigation bar, choose
> MySQL.In the Connect to a database dialog box, fill in the connection parameters: For the full list of DBeaver connection parameters, see DBeaver Community documentation.
ImportantThe password example above is for reference only. Do not use it in production.
Parameter Description Example Connect by Connection method. Select Host Server Host Server Address The VPC endpoint or public endpoint of the instance selectdb-cn-xxx-public.selectdbfe.rds.aliyuncs.comPort The MySQL port number of the instance 9030Database The database name test_dbUsername Your instance login username adminPassword Your instance login password TestPassd@Click Finish to save the connection.