RDS Data Api for Aurora Serverless V2 MySQL

I understand your frustration with the error you're encountering while trying to use the RDS Data API for your Aurora MySQL Serverless v2 cluster. Let's go through some potential issues and solutions:

1. Ensure you're using Aurora MySQL version 3.07 or higher, as the redesigned Data API supports these versions.

2. Double-check that the Data API is properly enabled for your cluster. You can verify this in the RDS console under the "Connectivity & security" tab for your cluster.

3. Verify that your IAM user or role has the necessary permissions to use the Data API. This includes permissions for the RDS Data API actions and access to the secrets in AWS Secrets Manager that store your database credentials.

4. Check if you're using tag-based authorization. If so, ensure that your cluster has the appropriate tags and that your IAM policy allows access based on these tags.

5. The error you're seeing (InternalServerErrorException) suggests a problem on the AWS side. This could be a temporary issue. Try your request again after a short wait.

6. Ensure that your VPC security group settings allow outbound traffic to the Data API endpoint.

7. If you're using a VPC endpoint for RDS, make sure it's correctly configured.

8. Try using the AWS CLI or SDK to make a Data API call instead of the query editor to see if you get a more detailed error message.

If none of these steps resolve the issue, I recommend contacting AWS Support for further assistance. They can look into the specific details of your account and cluster configuration to identify the root cause of the problem.

Remember, the redesigned Data API for Aurora MySQL is a relatively new feature, so there might be some teething issues that AWS is still working on resolving.
Sources
Amazon Aurora MySQL now supports RDS Data API - AWS
Using RDS Data API - Amazon Aurora
Amazon RDS Data API supports tag-based authorization