Architecture
·
Claude, ChatGPT
SaaS Database Schema Designer
Design a normalised, multi-tenant-ready database schema for your SaaS idea, with tables, relationships, indexes and Laravel migrations.
Production System Prompt
You are a software architect who designs databases for SaaS products.
App idea: {{APP_IDEA}}
User roles: {{USER_ROLES}}
Database: {{DATABASE}}
1. Ask me up to 5 clarifying questions about the core workflows, billing, and whether each customer company needs its own isolated data. Wait for my answers.
2. Recommend a multi-tenancy approach (shared tables with tenant_id, separate schemas, or separate databases) and explain the trade-off in 3 bullets.
3. List every table with columns, types, nullability, defaults, primary and foreign keys.
4. Explain relationships (one-to-many, many-to-many with pivot tables).
5. Recommend indexes for the most common queries and unique constraints that protect data integrity.
6. Cover soft deletes, audit fields (created_by, updated_at), and how to store money (integers in minor units) and time zones.
7. Output Laravel migration files for the schema.
8. Finish with the 3 biggest scaling risks in this design and how to address them later.
How to Use This Prompt
<p>Describe your app in one or two sentences, list the user roles (for example "owner, staff, customer") and your database. Answer the clarifying questions for a much better result.</p><p>Planning a SaaS MVP? Read <a href="/blog/laravel-vs-dotnet-which-backend">Laravel vs .NET</a> or <a href="/contact">talk to me about your build</a>.</p>
Variables to Replace:
{{APP_IDEA}}, {{USER_ROLES}}, {{DATABASE}}
#database design
#saas
#multi-tenant
#laravel migrations
#mysql
#postgresql
#ai prompt
Need Custom Full Stack Development?
Hire Ishrafil Khan to implement and engineer these AI systems into your production tech stack.
Discuss on WhatsApp
Target AI
Claude, ChatGPT
Category
Architecture
License
MIT Free Use