Volunteer scheduling tool in Bolt, worried about costs at 500 users

At 500 users you're still within Supabase Pro (€25). The thing that will bite you is the shifts page: it loads every shift ever, then filters in the browser. That's bandwidth, not database. Add a where date >= today server-side and paginate. Do it now while the table is small enough to test quickly.