saas-multi-tenant
Design and implement multi-tenant SaaS architectures with row-level security, tenant-scoped queries, shared-schema isolation, and safe cross-tenant admin patterns in PostgreSQL and TypeScript.
Profile →npx skills add sickn33/agentic-awesome-skills --skill saas-multi-tenant --agent claude-code
Same command for any agent — swap --agent for codex, cursor, copilot.
Weekly change comes from our own snapshots, not the repository page — it measures attention, not adoption.
# SaaS Multi-Tenant Architecture ## When to Use This Skill - The user is building a SaaS application where multiple customers share the same database - The user asks about tenant isolation, row-level security, or data leakage prevention - The user needs to scope every database query to a specific tenant without manual WHERE clauses - The user asks about shared-schema vs schema-per-tenant vs database-per-tenant tradeoffs - The user is implementing admin endpoints that must access data across tenants - The user needs to add `tenant_id` columns to an existing single-tenant application - The user asks about PostgreSQL RLS policies for tenant isolation - The user is building tenant-aware middleware in Express, Fastify, or Next.js API routes Do NOT use this skill when: - The user is building a single-user application with no shared infrastructure - The user asks about authentication only without tenant scoping (use an auth skill instead) - The user needs general database schema design without multi-tenancy requirements ## Core Workflow 1. Determine the tenancy model. Ask the user about their scale expectations and isolation requirements. For most SaaS apps under 1000 tenants, shared-sche
- When to Use This Skill
- Core Workflow
- Examples
- Example 1: PostgreSQL RLS Policy for Tenant Isolation
- Example 2: Express Middleware That Sets Tenant Context per Request
- Example 3: Prisma Middleware for Automatic Tenant Scoping
- Never Do This
- Edge Cases
- Best Practices
- Limitations
What does the saas-multi-tenant skill do?
Design and implement multi-tenant SaaS architectures with row-level security, tenant-scoped queries, shared-schema isolation, and safe cross-tenant admin patterns in PostgreSQL and TypeScript.
How do I install it?
Run `npx skills add sickn33/agentic-awesome-skills --skill saas-multi-tenant --agent claude-code` — it drops the skill into your project so the agent can pick it up. Swap the --agent value for codex, cursor or copilot if you use one of those.
Where does this skill come from?
From sickn33/agentic-awesome-skills, a repository with 44,414 stars. We read it straight from the repository tree rather than a submitted listing, so what you see here is what is actually published.
Is a popular skill a good skill?
Not necessarily. Stars measure attention, not adoption — a repository can trend for a week and be abandoned. That is why we show the weekly change from our own snapshots next to the total, instead of a single flattering number.