Hi there, and welcome to the forum!
If you’re getting timeouts, it’s usually because the database has a firewall (or “Security Group” in AWS) that blocks access from Anvil’s servers. You have two options:
-
Change your firewall rule to allow access from the Anvil egress IP addresses on port 3306 (you can do this from the AWS console – please email support@anvil.works for our latest list of egress IPs)
-
Use an Uplink script, running on a computer that does have access to the database, to run the SQL commands
I hope this helps!