# Alibaba Cloud RDS Data API API

> Alibaba Cloud RDS Data API API on Apizie: 7 endpoints (Calls the BatchExecuteStatement operation to execute batch SQL statements on a set of data, Starts a transaction, Commits transaction changes by calling the CommitTransaction operation, Executes an SQL statement on a specified database by calling the ExecuteStatement operation, …) returned as clean JSON through one API key. Send your own provider key in the x-upstream-key header. Call it over REST at https://apizie.tech/v1/cloud:aliyun-rds-data/{endpoint} or from Claude, ChatGPT and Cursor through the Apizie MCP server. Free plan: 1,000 requests a month.

- Project key: `cloud:aliyun-rds-data`
- Category: Cloud
- Status: byok
- Source: https://api.alibabacloud.com/product/rds-data
- Page: https://apizie.tech/api/cloud/aliyun-rds-data
- OpenAPI: https://apizie.tech/api/cloud/aliyun-rds-data/openapi.json

Alibaba Cloud OpenAPI for RDS Data API (rds-data, version 2022-03-30). Calls are signed with ACS3-HMAC-SHA256 using your AccessKey ID and secret.

## Endpoints

### Calls the BatchExecuteStatement operation to execute batch SQL statements on a set of data
`POST https://apizie.tech/v1/cloud:aliyun-rds-data/batch-execute-statement` (byok)

| Parameter | Type | Required | Description |
|---|---|---|---|
| endpoint | string | no | Regional endpoint, for example https://rds-data.cn-hangzhou.aliyuncs.com |
| SecretArn | string | yes | The user credential for the Data API account. You can call the https://help.aliyun.com/document_detail/446624.html operation to obtain the… |
| ResourceArn | string | yes | Specifies the resource that the user wants to access. Format: ```acs:rds:{{regionId}}:{{accountId}}:dbinstance/{{instanceId}}``` Parameter… |
| Database | string | no | The database name |
| Sql | string | yes | The SQL statement to execute. The BatchExecuteStatement operation is typically used to execute INSERT and UPDATE statements |
| TransactionId | string | no | The ID of the transaction that has been started. You can call the https://help.aliyun.com/document_detail/446897.html operation to obtain… |
| ParameterSets | string | no | The parameters of the SQL statements (JSON-encoded) |

### Starts a transaction
`POST https://apizie.tech/v1/cloud:aliyun-rds-data/begin-transaction` (byok)

| Parameter | Type | Required | Description |
|---|---|---|---|
| endpoint | string | no | Regional endpoint, for example https://rds-data.cn-hangzhou.aliyuncs.com |
| SecretArn | string | yes | The user credential of the Data API account. You can call the https://help.aliyun.com/document_detail/446624.html operation to obtain the… |
| ResourceArn | string | yes | The Alibaba Cloud Resource Name (ARN) that specifies the resource to access. Format:… |
| Database | string | yes | The database name |

### Commits transaction changes by calling the CommitTransaction operation
`POST https://apizie.tech/v1/cloud:aliyun-rds-data/commit-transaction` (byok)

| Parameter | Type | Required | Description |
|---|---|---|---|
| endpoint | string | no | Regional endpoint, for example https://rds-data.cn-hangzhou.aliyuncs.com |
| SecretArn | string | yes | The user credential of the Data API account. You can call the https://help.aliyun.com/document_detail/446624.html operation to obtain the… |
| ResourceArn | string | yes | The Alibaba Cloud Resource Name (ARN) that specifies the resource to access. Format:… |
| TransactionId | string | yes | The ID of the transaction to commit. You can call the BeginTransaction operation to obtain the value of this parameter |

### Executes an SQL statement on a specified database by calling the ExecuteStatement operation
`POST https://apizie.tech/v1/cloud:aliyun-rds-data/execute-statement` (byok)

| Parameter | Type | Required | Description |
|---|---|---|---|
| endpoint | string | no | Regional endpoint, for example https://rds-data.cn-hangzhou.aliyuncs.com |
| SecretArn | string | yes | The user credential of the Data API account. You can call the https://help.aliyun.com/document_detail/446624.html operation to obtain the… |
| ResourceArn | string | yes | The resource ARN that points to the resource that the user wants to access. Format:… |
| Database | string | yes | The database name |
| ContinueAfterTimeout | string | no | Specifies whether to continue running the SQL statement if the call times out. Valid values: true: Continue running. false: Stop running.… |
| FormatRecordsAs | string | no | Specifies whether to format the result set as a single JSON string. Only NONE or JSON can be specified. Default value: NONE. This… |
| IncludeResultMetadata | string | no | Specifies whether to include metadata in the result. Valid values: true: Include metadata. false: Do not include metadata |
| Sql | string | yes | The SQL statement to execute |
| TransactionId | string | no | The ID of the transaction that has been started. You can call the https://help.aliyun.com/document_detail/446897.html operation to obtain… |
| Parameters | string | no | The details of the parameters for the SQL statement to execute (JSON-encoded) |
| ResultSetOptions | string | no | The options that control how the result set is returned (JSON-encoded) |

### Invokes InsertList to bulk insert data
`POST https://apizie.tech/v1/cloud:aliyun-rds-data/insert-list` (byok)

| Parameter | Type | Required | Description |
|---|---|---|---|
| endpoint | string | no | Regional endpoint, for example https://rds-data.cn-hangzhou.aliyuncs.com |
| SecretArn | string | yes | The user credential of the Data API account. You can call the DescribeSecrets (https://help.aliyun.com/document_detail/446624.html)… |
| ResourceArn | string | yes | The Alibaba Cloud Resource Name (ARN) that specifies the resource to access. Format:… |
| Database | string | no | The database name |
| Table | string | yes | The table name |
| TransactionId | string | no | The ID of the transaction to commit. You can call the BeginTransaction operation to obtain the value of this parameter |
| Records | string | no | The data to bulk insert. The data structure is an array, where each item represents a record (JSON-encoded) |

### Rolls back a transaction by calling the RollbackTransaction operation. Rolling back a transaction cancels…
`POST https://apizie.tech/v1/cloud:aliyun-rds-data/rollback-transaction` (byok)

| Parameter | Type | Required | Description |
|---|---|---|---|
| endpoint | string | no | Regional endpoint, for example https://rds-data.cn-hangzhou.aliyuncs.com |
| SecretArn | string | yes | The user credential of the Data API account. You can call the https://help.aliyun.com/document_detail/446624.html operation to obtain the… |
| ResourceArn | string | yes | The Alibaba Cloud Resource Name (ARN) that specifies the resource to access. Format:… |
| TransactionId | string | yes | The ID of the transaction to roll back. You can call the BeginTransaction operation to obtain the value of this parameter |

### version
`POST https://apizie.tech/v1/cloud:aliyun-rds-data/version` (byok)

| Parameter | Type | Required | Description |
|---|---|---|---|
| endpoint | string | no | Regional endpoint, for example https://rds-data.cn-hangzhou.aliyuncs.com |

## Example
```
curl "https://apizie.tech/v1/cloud:aliyun-rds-data/batch-execute-statement" \
  -H "x-api-key: $APIZIE_KEY" \
  -H "x-upstream-key: $PROVIDER_KEY"
```

## FAQ

### How do I call the Alibaba Cloud RDS Data API API?
Create a free Apizie key, then send POST https://apizie.tech/v1/cloud:aliyun-rds-data/batch-execute-statement with the header x-api-key. Every endpoint returns { project, data, timestamp }.

### Is the Alibaba Cloud RDS Data API API free on Apizie?
Yes. The Free plan includes 1,000 requests a month at 100 requests a minute, no credit card. Alibaba Cloud RDS Data API itself also needs your own key from aliyuncs.com.

### Can AI agents use the Alibaba Cloud RDS Data API API?
Yes. Add the Apizie MCP server (https://apizie.tech/mcp) to Claude, ChatGPT, Cursor or VS Code, then ask in plain language. The agent calls run_scraper with project key cloud:aliyun-rds-data.

### What is the status of the Alibaba Cloud RDS Data API API?
Needs your own provider key (bring your own key)