export const getServerSideProps: GetServerSideProps = async ({ req }) => {
  const prisma = new PrismaClient();

  const animals = await prisma.animals.findMany();
  console.log("getting animals", animals);

  return {
    props: { animals: JSON.parse(JSON.stringify(animals)) },
  };
};

Prisma with Supabase RLS policies
For a recent task I had to set up Prisma to take into account RLS (Row Level Security) policies set up in Supabase. This, as you know, is difficult to achieve as by default Prisma opens a direct connection to the database, and that too with the postgres user that has permissions to bypass every RLS policy.