How does it handle tenant-specific data constraints?

It utilizes composite unique constraints in Prisma (e.g., [organizationId, email]) to ensure data uniqueness is enforced per tenant rather than across the entire global database table.

Which technologies are supported by this skill?

This skill is specifically optimized for TypeScript environments using Express for routing, Prisma as the ORM, and PostgreSQL for the underlying database.

Does this skill include middleware for request handling?

Yes, it includes middleware patterns that extract tenant identifiers from JWTs or headers and inject them into the request context for downstream services and repositories.

What is the main benefit of the Multi-Tenant Architecture skill?

It provides a standardized framework for ensuring data isolation between different organizations, preventing data leakage through automated context propagation and repository-level filtering.

Multi-Tenant Architecture

Name: Multi-Tenant Architecture
Author: Lobbi-Docs

byLobbi-Docs

API開発

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.

主な機能

Standardized tenant-aware repository pattern with built-in CRUD filtering
Automated tenant context propagation via specialized Express middleware
Strict row-level security (RLS) validation for all database operations
Type-safe tenant context and custom error handling for isolation breaches
Prisma schema optimization using composite indexes and tenant-scoped constraints
0 GitHub stars

ユースケース

Implementing row-level security patterns in Prisma and PostgreSQL database models
Building SaaS platforms that require strict data boundaries between different organizations
Designing secure API middleware for multi-user, multi-tenant request handling

概要

主な機能

Standardized tenant-aware repository pattern with built-in CRUD filtering
Automated tenant context propagation via specialized Express middleware
Strict row-level security (RLS) validation for all database operations
Type-safe tenant context and custom error handling for isolation breaches
Prisma schema optimization using composite indexes and tenant-scoped constraints
0 GitHub stars

ユースケース

Implementing row-level security patterns in Prisma and PostgreSQL database models
Building SaaS platforms that require strict data boundaries between different organizations
Designing secure API middleware for multi-user, multi-tenant request handling