Any
⚙️ Technical
Advanced
Design a Database Schema
Get a well-structured database schema for any application.
The Prompt
Design a database schema for the following application: Application type: [describe what the app does] Core entities needed: [list the main things the database needs to store — e.g. users, orders, products] Key relationships: [describe how these entities relate — e.g. users can have many orders] Expected scale: [small / medium / large — rough user/record estimates] Database type: [MySQL / PostgreSQL / SQLite / MongoDB / other] Special requirements: [multi-tenancy / soft deletes / audit logging / full-text search / other] Provide: 1. Full schema with all tables, columns, data types, and constraints 2. Primary keys, foreign keys, and indexes clearly marked 3. Explanation of key design decisions 4. Any junction/pivot tables for many-to-many relationships 5. Suggested indexes for common query patterns 6. One alternative design approach and when you'd choose it instead 7. What this schema does NOT handle well and how you'd extend it later
📝 Fill in the blanks
Replace these placeholders with your own content:
[describe what the app does]
[list the main things the database needs to store — e.g. users, orders, products]
[describe how these entities relate — e.g. users can have many orders]
[small / medium / large — rough user/record estimates]
[MySQL / PostgreSQL / SQLite / MongoDB / other]
[multi-tenancy / soft deletes / audit logging / full-text search / other]
How to use this prompt
1
Copy the prompt
Click "Copy Prompt" above to copy the full prompt text to your clipboard.
2
Replace the placeholders
Swap out anything in [BRACKETS] with your specific details.
3
Paste into Any
Open your preferred AI assistant and paste the prompt to get started.