Website backend
edge functionsstorageHey everyone! I’m building a web agency where I create websites for clients and I use Supabase as the backend for each website. I have a question about the best way to structure this as I scale up.
My situation: each client website has its own tables for things like bookings, reviews, form submissions etc. I want to give each client access to view their own data in Supabase without being able to see other clients’ data.
My questions are:
1. What is the best practice for this kind of setup — should I create a separate Supabase project for each client, or can I manage all clients under one project using separate schemas or row level security policies to keep their data isolated?
2. If I keep everything under one project, is it possible to give each client access to only their own tables/schema so they can log in and see their own data without seeing anyone else’s?
3. If the best solution is a separate project per client, how does the pricing work? Do I need to pay $25/month for each individual project or is there a way to manage multiple projects under one paid plan?
4. Is there an agency or partner plan that covers multiple projects at a better rate?
Thanks in advance — really appreciate any help from the community!
My situation: each client website has its own tables for things like bookings, reviews, form submissions etc. I want to give each client access to view their own data in Supabase without being able to see other clients’ data.
My questions are:
1. What is the best practice for this kind of setup — should I create a separate Supabase project for each client, or can I manage all clients under one project using separate schemas or row level security policies to keep their data isolated?
2. If I keep everything under one project, is it possible to give each client access to only their own tables/schema so they can log in and see their own data without seeing anyone else’s?
3. If the best solution is a separate project per client, how does the pricing work? Do I need to pay $25/month for each individual project or is there a way to manage multiple projects under one paid plan?
4. Is there an agency or partner plan that covers multiple projects at a better rate?
Thanks in advance — really appreciate any help from the community!
