Help Center/ Data Admin Service/ API Reference/ APIs/ Intelligent O&M/ Querying the Database Name List
Updated on 2026-08-25 GMT+08:00

Querying the Database Name List

Function

This API is used to query the database name list.

Authorization Information

Each account has permissions to call all APIs, but IAM users must have the required permissions specifically assigned.

  • If you are using role/policy-based authorization, see the required permissions in Permissions Policies and Supported Actions.
  • If you are using identity policy-based authorization, the following identity policy-based permissions are required.

    Action

    Access Level

    Resource Type (*: required)

    Condition Key

    Alias

    Dependencies

    das:connection:list

    list

    connection

    -

    das:connections:list

    -

URI

GET /v3/{project_id}/connections/{connection_id}/databases/get-name-list

Table 1 URI parameters

Parameter

Mandatory

Type

Description

project_id

Yes

String

Definition

Project ID of a tenant in a region.

To obtain this value, see Obtaining a Project ID.

Constraints

N/A

Range

The value can contain 32 characters. Only letters and digits are supported.

Default Value

N/A

connection_id

Yes

String

Definition

Connection ID established between a database account and the database. The database user ID is created using the API in Creating an Instance Connection.

Constraints

N/A

Range

The value is a UUID containing 36 characters. Only letters, digits, and hyphens (-) are allowed.

Default Value

N/A

Table 2 Query parameters

Parameter

Mandatory

Type

Description

node_type

No

String

Definition

Instance node type

Constraints

N/A

Range

  • master: primary node
  • slave: secondary node
  • readreplica: read replica

Default Value

N/A

node_id

No

String

Definition

Unique ID of an instance node. You can obtain the node ID from the node list in the instance details.

Constraints

N/A

Range

The value can contain 36 characters. Only letters and digits are allowed.

Default Value

N/A

Request Parameters

None

Response Parameters

Status code: 200

Table 3 Response body parameters

Parameter

Type

Description

data

Array of objects

Definition

Database name list

total

Long

Definition

Total number.

Range

N/A

Example Requests

GET https://das.cn-north-1.myhuaweicloud.com/v3/054e292c9880d4992f02c0196d3ea468/connections/179e525e-0e9c-4dcc-9dd7-ee2f36121e23/databases/get-name-list

Example Responses

Status code: 200

Success.

{
    "data": [
        {
            "database_name": "__recyclebin__",
            "character_set_name": "utf8mb4",
            "ip": "192.168.0.45",
            "port": "3306",
            "can_collect_flag": false
        },
        {
            "database_name": "information_schema",
            "character_set_name": "utf8mb3",
            "ip": "192.168.0.45",
            "port": "3306",
            "can_collect_flag": false
        },
        {
            "database_name": "mysql",
            "character_set_name": "utf8mb4",
            "ip": "192.168.0.45",
            "port": "3306",
            "can_collect_flag": false
        },
        {
            "database_name": "performance_schema",
            "character_set_name": "utf8mb4",
            "ip": "192.168.0.45",
            "port": "3306",
            "can_collect_flag": false
        },
        {
            "database_name": "sys",
            "character_set_name": "utf8mb4",
            "ip": "192.168.0.45",
            "port": "3306",
            "can_collect_flag": false
        }
    ],
    "total": 5
}

Status Codes

Status Code

Description

200

Success.

400

Client error.

500

Server error.

Error Codes

See Error Codes.