We use Aurora Serverless and this is a sorely needed feature for us. We get large spikes of traffic that also cause large increases in connections to our DB, but Aurora Serverless cannot scale fast enough to cater for this. Unfortunately it doesn't seem we can enable this proxy for serverless clusters.
Aurora serverless already has a proxy by default - if it can’t scale fast enough it’s likely because your queries are too long and interleaved to find a logical switchover point.
This proxy is probably an offshoot of the serverless proxy.
It has a hard limit on max_connections based on the "Aurora Capacity Unit", e.g. for 16 ACU's max_connections it is 2,000. We see spikes of 10x to 100x concurrent users in a matter of minutes (think hug of death style). And although our queries run fast and we see limited increase of CPU on the cluster we almost instantly hit the connection limit.
https://www.jeremydaly.com/aurora-serverless-the-good-the-ba...
The result format is a bit clunky but there's all the column information you'd expect.
I found this golang database interface which ended up dropping in as expected with a few tweaks.
https://github.com/Clever/rds/tree/birthday
My bill for Aurora Serverless Postgres last month was less than a dollar.