Hey, yes, i already done that but i need to use Supabase RESTful API (not realtime API, my mistake on original question) for performance purposes, i read that connection pooling its not the best for serverless.

So - to be clear - you've generated a supabase schema using prisma and are now trying to hit a web endpoint?

Yes, i'm using supabase client, and i've tried with anon public and service role key

I'd google around using postgREST as your query then! This seems to be asking what you're looking for: https://dba.stackexchange.com/questions/173635/postgres-permission-denied-for-schema Something like:

GRANT USAGE ON SCHEMA public TO postgres;

Sorry I can't be of much more help on that one :C

It didn't work 😦 thank you for your time 😄