Overview
What this challenge is about.
Design the multi-tenant schema: shared tables with a tenant_id column, indexed appropriately. Write a forward + backward migration (using Drizzle or Prisma). Implement Postgres RLS policies enforcing tenant isolation on every read + write. Build a Vitest test suite that boots a test database with 3 tenants and verifies no cross-tenant leakage on any endpoint (target 25+ test cases). Run a load test simulating 50 concurrent tenants and report latency impact of RLS. Deliver the migrated schema, the RLS policies (.sql files), the passing test suite, the load-test report, and a 5-page migration write-up.
The Brief
What you'll do, and what you'll demonstrate.
Migrate from schema-per-tenant to single-schema multi-tenant with RLS, proving tenant isolation through an automated test suite.
Earning criteria — what you'll demonstrate
- Design a multi-tenant data model that scales beyond schema-per-tenant
- Write and reason about Postgres Row Level Security policies
- Build a test suite that proves data isolation, not just functional correctness
- Measure the performance impact of RLS on a real workload
Program Fit
Where this fits in your program.
Sharpens the same skills your degree expects you to demonstrate.
Skills
Skills you'll demonstrate.
Each one shows up on your verified credential.
Careers
Roles this prepares you for.
Real titles. Real skill bridges. Pick the one closest to your trajectory.
Career mappings coming soon.