What isolation modes does this skill cover?

The skill covers three primary modes: Field Isolation (using a tenant_id column), Schema Isolation (separate database schemas), and Physical Isolation (completely independent database instances).

Does it provide code for automated tenant filtering?

Yes, it includes Java-based patterns for using MyBatis interceptors to automatically append tenant conditions to SQL queries, ensuring developers don't have to manually handle filters.

How does it handle cross-tenant operations?

It provides standardized utility patterns for 'ignoring' tenant filters or 'switching' contexts, which is essential for super-admin tasks and global data analytics.

Can this skill help with Redis cache management?

Yes, it includes a strategy for isolating Redis keys by prefixing them with the tenant ID to prevent data leakage in shared caching environments.

Is this skill specific to a certain programming language?

While the architectural principles apply to all languages, the provided implementation examples specifically target Java-based stacks using Spring and MyBatis.

Multi-Tenant Architecture Guide

Name: Multi-Tenant Architecture Guide
Author: xu-cell

byxu-cell

•

데이터베이스 관리

Guides the design and implementation of multi-tenant SaaS architectures using field, schema, and physical isolation patterns.

The tenant-management skill provides comprehensive architectural guidance and implementation patterns for building secure, scalable SaaS applications. It simplifies the complex decision-making process between field-level, schema-level, and physical database isolation by providing detailed trade-off comparisons and production-ready code snippets. Whether you are implementing MyBatis interceptors for automated filtering, managing cross-tenant background tasks, or configuring Redis cache isolation, this skill ensures your system maintains strict data boundaries while remaining developer-friendly through transparent framework integration.

주요 기능

01In-depth comparison of Field, Schema, and Physical isolation strategies

02Troubleshooting guide for common multi-tenancy pitfalls and transaction management

03Ready-to-use Java and MyBatis implementation patterns for tenant filtering

04Best practices for Redis cache isolation and scheduled task processing

0511 GitHub stars

06Standardized utilities for dynamic tenant context switching and global data access

사용 사례

01Architecting a new SaaS platform that requires strict data segregation for enterprise clients.

02Implementing automated tenant-aware filtering in an existing Java Spring Boot application.

03Developing administrative tools that need to safely aggregate data across multiple tenant schemas.

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add xu-cell/ai-engineering-init tenant-management

For use in Claude.ai and ChatGPT

Download Skill