Multi-Tenant ATS Architecture: What Goes in Migration One
Org scoping, RLS, and permissions belong in the first migration — not sprint eighteen. A technical primer for agency founders.
Vikram Singh Rathore
Founder & Principal Engineer
Staffing agencies are multi-tenant by nature: clients, vendors, and internal teams share one platform but must never see each other's data. Bolt-on tenancy after the fact means painful rewrites.
Migration one checklist
- org_id on every business table, enforced in the database — not just the app layer
- Row-level security policies tested with negative cases (user A cannot read org B)
- Role matrix documented before UI: admin, manager, recruiter, client, vendor
- Service role keys never shipped to the browser
Jobsflix ATS has 51+ migrations because we learned this the productive way. If you're scoping a custom ATS, read our build-vs-buy scorecard and compare guide before you sign a body-shop SOW.
Building something in this space?
Every engagement starts with a free strategy call — scope, honest feasibility, and a fixed quote.