query_sql
Execute read-only SQL queries on Alibaba Cloud RDS instances to retrieve data or view database information, specifying the instance ID, region, database name, and SQL statement for precise results.
Instructions
execute read-only sql likes show xxx, select xxx
Args:
dbinstance_id (str): The ID of the RDS instance.
region_id(str): the region id of instance.
db_name(str): the db name for execute sql.
sql(str): the sql to be executed.
Returns:
the sql result.
Input Schema
Name | Required | Description | Default |
---|---|---|---|
db_name | Yes | ||
dbinstance_id | Yes | ||
region_id | Yes | ||
sql | Yes |
Input Schema (JSON Schema)
{
"properties": {
"db_name": {
"title": "Db Name",
"type": "string"
},
"dbinstance_id": {
"title": "Dbinstance Id",
"type": "string"
},
"region_id": {
"title": "Region Id",
"type": "string"
},
"sql": {
"title": "Sql",
"type": "string"
}
},
"required": [
"region_id",
"dbinstance_id",
"db_name",
"sql"
],
"title": "query_sqlArguments",
"type": "object"
}