The Universal API for Amazon Aurora (MySQL/Maria) allows developers to interact with Aurora database instances through a single, unified interface. With secure OAuth 2.0 authentication, you can execute SQL queries such as SELECT, INSERT, UPDATE, and DELETE without handling database-specific connection details. This streamlined approach simplifies data management, analytics, and reporting while maintaining full control over your Aurora database operations
POST Token
{{base_url}}/token
This endpoint is used to retrieve an authentication token from the API. The token serves as an authorization mechanism to access and interact with the various API endpoints.
Body (form-data)
- username: {{Username}}
- password: {{Password}}
POST API for Amazon Aurora Database
{{base_url}}/universalAPI?db_name=Amazon Aurora(MySQL/Maria)&db_version=Latest
The Universal API for Amazon Aurora (MySQL/Maria) provides a unified interface to securely interact with Aurora database instances. With this API, you can execute SQL queries such as SELECT, INSERT, UPDATE, and DELETE without worrying about connection specifics. OAuth 2.0 authentication ensures secure access, allowing developers to focus on analytics, application logic, and reporting while managing Amazon Aurora data efficiently.
Authorization
OAuth 2.0
Query Parameters
- db_name: Amazon Aurora(MySQL/Maria)
- db_version: Latest
Body (raw JSON)
{
"username": "{{username}}",
"password": "{{password}}",
"query": "{{SELECT/INSERT QUERY}}",
"schema_name": "{{schema_name}}",
"hostname": "{{host_name}}",
"portnumber": {{port_number}}
}
