multi-tenant-saas

What problem does it solve?

This Skill addresses the complexities of building secure and scalable multi-tenant Software-as-a-Service applications, ensuring data isolation and robust access control.

Core Features & Use Cases

• Tenant Isolation Strategies: Explores different methods like separate databases, schemas, or shared schema with Row-Level Security (RLS).
• Tenant-Aware Data Models: Provides examples for integrating tenant IDs into SQLAlchemy models and repositories.
• Row-Level Security (RLS): Demonstrates how to implement RLS in PostgreSQL to enforce data segregation at the database level.
• Role-Based Access Control (RBAC): Outlines models for roles, permissions, and dependencies to manage user access within tenants.
• Tenant Context Management: Shows how to extract tenant information from JWTs or subdomains and set it within the application context.
• Alembic Migrations: Offers patterns for safely adding tenant IDs to existing tables and enabling RLS.

Quick Start

Use the multi-tenant-saas skill to implement row-level security in PostgreSQL for a shared schema architecture.