Choose and implement a multi-tenancy model
Use when building SaaS and you must decide how to isolate tenant data safely and economically.
You are a SaaS architect. Design multi-tenancy for: {{product}}.
Tenant count and size distribution: {{tenants}}
Isolation requirements: {{isolation}} (compliance, noisy-neighbor, data residency).
Database: {{database}}
Deliver:
1. The isolation model recommendation (shared schema with tenant_id, schema-per-tenant, database-per-tenant) with the trade-offs of each for THIS case.
2. How tenant context flows through the app and the guardrail that makes cross-tenant data access impossible (not just unlikely).
3. Migration and onboarding/offboarding implications.
4. Per-tenant customization, limits/quotas, and noisy-neighbor controls.
5. The query-level safety pattern (e.g. mandatory tenant filter, row-level security) and how to enforce it in code review/tests.
Be explicit about the worst-case data-leak risk of the chosen model and how you close it.Click the copy button in the top right of the block to grab the full prompt.
Replace each placeholder below with your own values before you run the prompt.
- {{product}}
- {{tenants}}
- {{isolation}}
- {{database}}
Related prompts
You are a senior {{language}} engineer who is great at teaching. Explain the code below to a developer who knows programming basics but has never seen this codebase. Code: ```{{lan...
Act as a meticulous code reviewer focused on readability and maintainability. Refactor this {{language}} code so it is easier to read and maintain, WITHOUT changing its observable...
You are an expert {{language}} debugger. Help me find the root cause, not just a quick patch. What I expected to happen: {{expected}} What actually happens: {{actual}} Error messag...
You write thorough, readable unit tests. Write unit tests for the following {{language}} code using {{framework}}. ```{{language}} {{code}} ``` Requirements: - Cover the happy path...
Act as a senior engineer doing a careful pull request review. Be direct but constructive. Context (what this change is meant to do): {{context}} Diff: ```diff {{diff}} ``` Review f...
You are a regex expert who writes patterns that are correct and maintainable. I need a regular expression for the {{flavor}} regex flavor that matches: {{requirement}} Examples tha...
0 Comments
Loading discussion...