Implements robust tenant isolation and organization-scoped data patterns for secure SaaS applications.
The Multi-Tenant Architecture skill provides a comprehensive framework for building and maintaining member management systems with strict data isolation. It guides Claude through the implementation of tenant context propagation from middleware to the repository layer, utilizing row-level security patterns and Prisma-specific data modeling. By enforcing organization-based filtering and composite unique constraints, this skill ensures that cross-tenant data leakage is prevented while maintaining a clean, type-safe architecture across Express, TypeScript, and PostgreSQL environments.
Key Features
01Standardized tenant-aware repository pattern with built-in CRUD filtering
02Automated tenant context propagation via specialized Express middleware
03Strict row-level security (RLS) validation for all database operations
04Type-safe tenant context and custom error handling for isolation breaches
05Prisma schema optimization using composite indexes and tenant-scoped constraints
060 GitHub stars
Use Cases
01Implementing row-level security patterns in Prisma and PostgreSQL database models
02Building SaaS platforms that require strict data boundaries between different organizations
03Designing secure API middleware for multi-user, multi-tenant request handling
