OceanBase Cloud provides the following Open APIs. Before using them, you must prepare an identity account and an AccessKey. For more information, see Manage AccessKeys.
Click to download the OB Cloud OpenAPI file Cluster Management
Open API |
Title |
Overview of Open APIs |
|---|---|---|
| DescribeInstances | Query cluster list | Query the list of OceanBase clusters. |
| DescribeInstance | Query cluster information | Query detailed information about an OceanBase cluster. |
| CreateInstance | Create Cluster | Create an OceanBase cluster instance. |
| DeleteInstance | Delete cluster | Delete an OceanBase cluster instance. |
| ModifyInstanceName | Modify cluster name | Modify the cluster name of OceanBase. |
| DescribeNodeOptions | Query cluster node information | Query the cluster node information of OceanBase. |
| StopCluster | Pause a cluster instance | Pause an OceanBase cluster instance. |
| StartCluster | Start a cluster instance | Start an OceanBase cluster instance. |
| ModifyInstanceSpec | Modify Cluster Specification | Modify the cluster specifications of OceanBase. |
| DescribeInstanceTopology | Query the topology information of an instance. | Query the topology information of an instance. |
| DescribeReadonlyInstances | Query Read-only Replica Information | Query the basic information of a read-only replica instance. |
| CreateReadonlyInstance | Create a read-only replica instance | Create a read-only replica instance. |
| ModifyReadonlyInstanceSpec | Modify the specification of a read-only replica instance | Modify the instance specification of a read-only replica. |
| ModifyReadonlyInstanceDiskSize | Modify the disk size of a read-only replica | Modify the instance specification of a read-only replica. |
| ModifyReadonlyInstanceNodeNum | Modify the Number of Read-Only Replica Nodes | Modifies the number of nodes for a read-only replica. |
| DeleteReadonlyInstance | Delete a read-only replica instance | Delete a read-only replica instance. |
| DescribeInstanceAvailableRoZones | Query the zone of a read-only replica | Query the zone of a read-only replica. |
| DescribeInstanceparameters | Query cluster-level parameters | Query cluster-level parameters. |
| UpdateInstanceParameters | Modify cluster-level parameters | Modify cluster-level parameters. |
| DescribeInstanceparametersHistory | Query the modification history of cluster-level parameters | Query the modification history of cluster-level parameters. |
| ModifyInstanceTagList | Modify instance tag | Instance tag modification. |
| ModifyInstanceNodeNum | Modify the number of cluster nodes. | Modify the number of cluster nodes. |
| DescribeInstanceAnomalyEvents | Query instance exceptions | Query exception event information that occurred in a specified instance within a specified time period. |
| DescribeOasClusterAnomalySqlList | Query suspicious SQL statements in the cluster | Query the list of suspicious SQL statements for a specified instance within a specified time period. |
| DescribeOasClusterSlowSQLList | Query the list of slow SQL statements in the cluster | Query the list of slow SQL statements for a specified instance within a specified time range. |
Tenant Management
Open API |
Title |
Overview of Open APIs |
|---|---|---|
| DescribeTenants | Query Tenant List Information in a Cluster | Query the list of tenants in a cluster. |
| DescribeTenant | Query Information of a Specified Tenant in a Specified Cluster | Query the information of a specified tenant in a specified cluster. |
| CreateTenants | Create Tenant | Create a tenant. |
| DeleteTenants | Delete Tenant | Delete one or more tenants from a specified OceanBase cluster. |
| ModifyTenantName | Modify Tenant Name | Modifies the name of a tenant in a specified OceanBase cluster. |
| ModifyTenant | Modify Tenant | Modify the tenant information under a specified OceanBase cluster. |
| ModifyTenantUserDescription | Modify Tenant User Description | Modify the tenant user description. |
| ModifyTenantUserStatus | Modify Tenant User Status | Modify the tenant user status. |
| GetTenantCreateConstraints | Query Constraints for Creating a Tenant | Query the constraints for creating a tenant in a specified OceanBase cluster. |
| ModifyTenantPrimaryZone | Modify Tenant Primary Zone | Modify the primary zone of a tenant. |
| GetTenantCreateCpuConstraints | Query the CPU constraints for creating a tenant | Query the CPU constraints for creating a tenant in a specified OceanBase cluster. |
| GetTenantCreateMemConstraints | Query memory constraints for creating a tenant | Query the memory constraints for creating tenants in a specified OceanBase cluster. |
| GetTenantModifyCpuConstraints | Query the CPU constraints for modifying a tenant | Query the CPU constraints for modifying tenants in a specified OceanBase cluster. |
| GetTenantModifyMemConstraints | Query memory constraints for modifying a tenant | Query the memory constraints for modifying tenants in a specified OceanBase cluster. |
| CreateTenantSecurityIpGroup | Create Tenant Security Allowlist Information | Creates tenant security allowlist information. |
| DescribeTenantSecurityIpGroups | Query Tenant Allowlist Group List | Query the tenant allowlist group list. |
| ModifyTenantSecurityIpGroup | Modify Tenant Allowlist Group Information | Modify the tenant allowlist group information. |
| DeleteTenantSecurityIpGroup | Delete Tenant Allowlist Group Information | Delete tenant allowlist group information. |
| DescribeTenantPrivateLink | Query Tenant Connection Information | Query the connection information of a tenant. |
| DeletePrivatelinkConnection | Delete Tenant Connection Address | Delete tenant connection address. |
| CreatePrivatelinkService | Activate Tenant Connection | Enable PrivateLink connection for the tenant. |
| ConnectPrivatelinkService | Connect to a database through a PrivateLink endpoint | Connect to the database through a PrivateLink endpoint. |
| AddPrivatelinkServiceUser | Add User to Allowlist | Add users to the allowlist. |
| BatchKillProcessList | Batch Terminate Session Processes of a Specified Tenant | Terminates the session processes of a specified tenant in batches. |
| DescribeProcessStatsComposition | Query session process statistics | Query session process statistics. |
| DescribeTenantAddressInfo | Query Tenant Address Information | Query the tenant address information in a specified cluster. |
| DescribeTenantAvailableRoZones | Query Tenant Read-only Replicas | Query the basic information of tenant read-only replicas. |
| ModifyTenantReadonlyReplica | Modify Tenant Read-only Replica | Modify tenant read-only replicas. |
| DescribeTenantParameters | Query tenant-level parameters | Query tenant-level parameters. |
| UpdateTenantParameters | Modify tenant-level parameters | Modify tenant-level parameters. |
| DescribeTenantParametersHistory | Query tenant-level parameter modification history | Query the modification history of tenant-level parameters. |
| ModifyTenantTagList | Modify Tenant Tag | Tenant tag modification. |
| CreateReadonlyPrivatelink | Create Private Network Read-Only Endpoints for a Tenant | Creates a private network read-only endpoint for a tenant under the specified instance, suitable for scenarios where read and write traffic are separated. |
| CreateReadwritePrivatelink | Create a private network read/write separation endpoint for a tenant | Creates a private network read/write splitting endpoint for a tenant under the specified instance, distributing read and write requests to different nodes to enhance concurrent processing capabilities. |
Tenant Account Management
Open API |
Title |
Overview of Open APIs |
|---|---|---|
| CreateTenantUser | Create Tenant User | Create an account for accessing the database under the specified tenant. |
| DescribeTenantUsers | Query Tenant Account List | Query the list of accounts that access all databases in a tenant. |
| DeleteTenantUsers | Delete Tenant User | Delete one or more database accounts. |
| ModifyTenantUserPassword | Change Tenant User Password | Modify the login password of a specified database account in a tenant. |
| ModifyTenantUserRoles | Modify Tenant User Role | Modify the role of a specified database account under a tenant. |
Database Management
Open API |
Title |
Overview of Open APIs |
|---|---|---|
| CreateDatabase | Create a database | Creates a new database under the specified tenant. |
| DescribeDatabases | Query Database List | Query the database list. |
| DeleteDatabases | Delete a database | Delete one or more created databases. |
| ModifyDatabaseUserRoles | Modify Database User Role | Modify the database user role. |
| DescribeTableSchema | Query Table Schema | Query the schema information of a specified data table under a specific tenant in a specified instance. |
Backup and Recovery
Open API |
Title |
Overview of Open APIs |
|---|---|---|
| DescribeDataBackupSet | Query Data Backup Set Information | Query data backup set information. |
| DescribeRestorableTenants | Query Restorable Tenants | Query recoverable tenants. |
| ModifyBackupStrategy | Modify Backup Strategy | Modify the backup strategy. |
| CreateTenantRestoreTask | Create Tenant Restore Task | Creates a tenant restore task. |
| CreateDataBackupTask | Create Backup Task | Create a backup task. |
| DescribeOneDataBackupSet | Get Task ID Backup Set | Retrieves the backup set by task ID. |
Database Proxy Management
Open API |
Title |
Overview of Open APIs |
|---|---|---|
| CreateTenantAddress | New Tenant Address | This API is used to create a tenant address. |
| CreateTenantSingleTunnelSLBAddres | Create Tenant SingleTunnelSLB Address | This API is used to create a singleTunnelSLB endpoint for a new tenant. |
| DeleteTenantAddress | Delete Tenant Address | This API is used to delete a tenant address. |
| DescribeTenantAddress | Query Tenant Address | This API is used to query the tenant address. |
| ModifyOdpClusterSpec | Modify the database proxy cluster specifications. | This API is used to change the database proxy cluster specification. |
| ModifyTenantAddressPort | Modify Tenant Address Port | This API is used to modify the tenant address port. |
| ModifyTenantAddressDomainPrefix | Modify tenant address domain name prefix | This API is used to modify the tenant address domain name prefix. |
| ConfirmPrivatelinkConnection | Confirm to Complete Private Link Connection | This API is used to confirm the completion of a Private Link connection. |
| DescribeTenantAddressInfo | Query All Tenant Address Information | Query the address information of all tenants. |
Monitoring Management
Open API |
Title |
Overview of Open APIs |
|---|---|---|
| DescribeTenantMetrics | Query Tenant Metrics | Query the metrics of a specified OceanBase tenant. |
| DescribeMetricsData | Query monitoring metric data | Query single-dimensional or multi-dimensional monitoring metrics of an OceanBase cluster. |
| DescribeNodeMetrics | Query Node Metrics | Query the metrics of an OceanBase node. |
| CreatePrometheusIntegration | Create Prometheus Monitoring Integration | Creates a Prometheus monitoring integration for the specified OceanBase Cloud database instance and generates the Prometheus scrape target configuration file. |
| DeletePrometheusIntegration | Delete Prometheus Monitoring Integration | Delete a configured Prometheus monitoring integration to stop collecting monitoring metrics for the corresponding instance. |
| ListPrometheusIntegration | Query Prometheus Monitoring Integration List | Query the list of configured Prometheus monitoring integrations in the current project. |
Diagnostic Management
Open API |
Title |
Overview of Open APIs |
|---|---|---|
| DescribeOasTopSQLList | Query the TopSQL list | Query the list of SQL execution performance data collected by the diagnostic system. |
| DescribeOasAnomalySQLList | Query Suspicious SQL Statements | Query the diagnostic system for a list of SQL statements that may have performance issues. |
| DescribeOasSlowSQLList | Query the SlowSQL list | Query the slow SQL list. |
| DescribeSqlAudits | Query SQL Audit Information | Query an OceanBase SQL audit information. |
| DescribeOasSQLText | Query SQL Text | Query the text information of an OceanBase SQL statement. |
| DescribeOutlineBinding | Query SQL Outline Binding Information | Query SQL outline binding information. |
| DescribeSampleSqlRawTexts | Sample Original Text of Query SQL | Sample original text of the query SQL statement. |
| DescribeSQLTuningAdvices | SQL query tuning suggestions | Query SQL tuning suggestions. |
| DescribeOasSlowSQLSamples | Query Slow SQL Execution Details Sample Data | Query the sampled data of slow SQL execution details. |
| DescribeOasSQLTrends | Query SQL Execution History | Query the SQL execution history data. |
| DescribeOasSQLPlanGroup | Query SQL execution plan | Query the SQL execution plan. |
| DescribeRcaRecord | Query Root Cause Analysis Records | Query the root cause analysis results for a specific exception on a given instance. |
| DescribeTopSQLComparision | SQL Execution Comparison | Compare the performance data of top SQL statements between the specified period and the baseline period. |
| DescribeSessionStatsGroupBySqlId | Aggregate Session Statistics by SQL ID | Query the statistics of all sessions in a specified instance and tenant, grouped by SQL ID. |
| DescribeIndexes | Query index information | Query the index information of a specific database and table in a specified instance and tenant. |
| DescribeOasHighRiskSQL | Query High-Risk SQL | Query high-risk SQL statements for a specified instance and tenant within a specific time period. |
Security Management
Open API |
Title |
Overview of Open APIs |
|---|---|---|
| CreateSecurityIpGroup | Create Instance Allowlist Group | Creates an instance allowlist group. |
| DescribeInstanceSSL | Query SSL Configuration Information of an Instance | Query the SSL configuration information of an instance. |
| ModifyInstanceSSL | Modify the SSL configuration of an instance | Modify the SSL configuration of an instance. |
| DescribeTenantEncryption | Query Tenant Encryption Information | Query tenant encryption information. |
| ModifyTenantEncryption | Transparent data encryption enabled for the tenant | Transparent data encryption is enabled for the tenant. |
| ModifySecurityIps | Modify the IP list in the instance allowlist | Modify the IP list in the instance's allowlist. |
| DeleteSecurityIpGroup | Delete Instance Allowlist Group | Delete an instance from an allowlist group. |
| DescribeTenantSecurityConfigs | Tenant Security Configuration Check | Detects tenant security configurations and returns the detection results and risk items for each tenant. |
| DescribeInstanceSecurityConfigs | Cluster Security Configuration Check | Detects the security configurations of a cluster and returns the detection results and risk items at the cluster level. |
Tag Management
Open API |
Title |
Overview of Open APIs |
|---|---|---|
| DescribeTags | Query Tag List | Query the tag list of the current organization and return the tag keys and their corresponding value sets. |
| CreateTags | Batch Create Tags | Batch create tags in the current organization. |
| UpdateTag | Update Tag | Updates the key and value of a specified tag. |
| DeleteTag | Delete Tag | Delete the specified tag. |
Historical Event Management
Open API |
Title |
Overview of Open APIs |
|---|---|---|
| DescribeOperationEvents | Query Historical Events | Query historical event information. |
AI Services
Open API |
Title |
Overview of Open APIs |
|---|---|---|
| CreateAIServiceAPIKey | Create an AI API Key | Create a new AI API Key. |
| ListAIServiceAPIKeys | Query API Key List | Query the list of API keys for a specified organization and project in pagination mode. |