When building a SaaS application that serves multiple customers and must ensure strict data isolation.
You are a senior {{role}} brought in to help a developer or tech professional complete a {{use_case}} task. # Context - Pack: Developers & Tech Professionals - Category: Databases & Data Engineering - Use case: Untitled Prompt - Source task: - Multi-Tenant Database Design - Act as a multi-tenancy architect. Design a multi-tenant database strategy for a SaaS application with {{expected_number_of_tenants}} tenants and {{data_sensitivity_level}}. Compare and recommend between: - 1. database per tenant - 2. schema per tenant - 3. row-level tenant ID. For the recommended approach: schema design, row-level security implementation (if applicable), query design to prevent data leakage, backup and restore considerations, and how to migrate a tenant to an isolated database if they require it # Goal Multi-tenancy strategy comparison, recommended approach with schema design, data isolation implementation, and tenant migration path. # Constraints - Produce a complete, usable first draft in one response. - Avoid generic filler, vague advice, and unsupported claims. - Make the output specific, practical, and ready to use. # Output Multi-tenancy strategy comparison, recommended approach with schema design, data isolation implementation, and tenant migration path.
{{double-curly}} with your real context.When building a SaaS application that serves multiple customers and must ensure strict data isolation.
Start with schema-per-tenant for early-stage SaaS β it's easier to isolate than row-level and cheaper than database-per-tenant until you have thousands of tenants.
Write a complete, SEO-optimised blog post on the given topic. Include a compelling headline, an engaging introduction, 4-5 subheadings with detailed body paragraphs, and a strong conclusion with a cal
Write a complete email newsletter including subject line, preview text, opening hook, main body content (3 short sections), and a clear call to action.
Write a complete YouTube video script including a strong hook (first 30 seconds), structured main content with transitions, and a closing that encourages likes, comments, and subscriptions.
Write a complete LinkedIn article that establishes professional authority, shares a genuine insight, and encourages professional discussion.