implementing-tenancy-patterns

Official

Enforce multi-tenant database schemas.

Authormusher-dev
Version1.0.0
Installs0

System Documentation

What problem does it solve?

This Skill provides a robust framework for implementing, auditing, and optimizing multi-tenant database schemas, specifically adhering to the User-Owned Organization model, to ensure data isolation and security.

Core Features & Use Cases

  • Schema Governance: Enforces strict rules for tenant scoping, uniqueness, and role design.
  • Anti-Pattern Detection: Identifies and provides fixes for common tenancy violations like polymorphic ownership and global uniqueness.
  • Migration Safety: Guides safe schema evolution using the expand-contract pattern.
  • Use Case: When designing a new SaaS application's database, use this Skill to ensure all resource tables are correctly scoped to tenant_id and that uniqueness constraints are tenant-aware from the start.

Quick Start

Use the implementing-tenancy-patterns skill to review the database schema for potential tenancy anti-patterns.

Dependency Matrix

Required Modules

None required

Components

references

💻 Claude Code Installation

Recommended: Let Claude install automatically. Simply copy and paste the text below to Claude Code.

Please help me install this Skill:
Name: implementing-tenancy-patterns
Download link: https://github.com/musher-dev/bundles/archive/main.zip#implementing-tenancy-patterns

Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
View Source Repository

Agent Skills Search Helper

Install a tiny helper to your Agent, search and equip skill from 223,000+ vetted skills library on demand.