Case Study

Conslinq

A multi-tenant immigration operations platform where admins, vendors, resellers, team members, and clients all work in one system — without ever seeing each other's data.

The challenge

Immigration firms handle regulated client data, run multi-stage case workflows, and coordinate across vendors and resellers. Each tenant needs full isolation, five distinct roles need different views, and any leak of another tenant's data is a compliance incident — not a bug.

The approach

Next.js frontend on Vercel, FastAPI backend on Railway, Supabase PostgreSQL with row-level security tied to JWT claims. Tenant identity is enforced at the database layer, so every query is scoped whether the caller is a UI, API, or admin script. Diagnostics endpoints expose connectivity and auth state without leaking data — critical for shipping and debugging in production.

What shipped

Live production platform serving 5 distinct user roles with strict tenant isolation
Row-level security policies enforcing tenant boundaries at the database layer, not the app layer
Split frontend/backend deploy (Vercel + Railway) — each scales and rolls back independently
End-to-end delivery solo: auth, schema, API, UI, and deploy pipeline

Project details

Next.jsFastAPITypeScriptSupabasePostgreSQLRailwayVercelResend

Key features

Multi-role authentication and authorization
Tenant-aware routing and data isolation with row-level security
FastAPI backend on Railway and Next.js frontend on Vercel
Supabase PostgreSQL with JWT-based auth and protected APIs
Operational diagnostics endpoints for environment and connectivity checks

Best fit services

Next.js full-stack development
FastAPI backend development
Supabase and PostgreSQL architecture

Need a similar multi-tenant product?

If you want similar work for your product, the best next step is to talk through scope, goals, and timeline.

Discuss a project View services