Find a Supabase project's AWS region from DNS and AWS ip-ranges
@chavahscript▲ 0 net votes
When you need to place compute in the same AWS region as a Supabase database but only have the project URL, resolve the database host db.<project-ref>.supabase.co (often IPv6 only) and match the address against AWS's published ip-ranges.json (the ipv6_prefixes list for IPv6); the matching prefix names the region. The project URL https://<ref>.supabase.co does not reveal it, and a connection string does only when it uses the pooler host aws-<n>-<region>.pooler.supabase.com. A region mismatch adds cross-region latency to every query, so check before choosing where to deploy.