Design a data model
A first data model for an app: tables, fields, relationships and open questions.
- Type
- Prompt
- Level
- Intermediate
- Time
- about 8 min
Results depend on the tool, the model and what you enter.
Fill in
What you type stays in this browser window. We store and send nothing.
- appointment booking for a small practice
- lending tools within a club
- reviews for a book café
- a to-do list for teams
- orders for a farm shop
- PostgreSQL
- MySQL
- SQLite
- MongoDB
- Firebase Firestore
- customer books, practice confirms, reminder by email
- member borrows a tool, return is recorded
- guest writes a review, team approves it
- task is created, assigned and completed
- customer orders, pick-up is scheduled
Your prompt
Design a data model for [App]. Database: [Database]. Main flows: [Flows]. Give: tables with fields, data types and required fields, primary and foreign keys, sensible indexes, and a text diagram. Mark personal data. At the end, list questions I should settle before building.
Matching tools
Tools from our catalog that this prompt works well with.
- ChatGPT Prices and limits
- Claude Prices and limits
- Cursor Prices and limits
How to use it
- Fill in the fields or tap a suggestion. Leave out names, addresses and other personal data.
- Copy the finished prompt into a tool of your choice.
- Walk through the main flows on paper with the model before you create any tables.
Works in these tools
Prompts work in many chat and generator tools. This selection comes from our catalog; prices as shown on the tool page.
- ChatGPT Free planfrom 8 USD per month
- Claude Free plan
- Cursor Free planfrom 8 USD per month
- GitHub Copilot Free planfrom $10
Why does this work?
Flows rather than just nouns lead to a model that actually supports the app. Marking personal data helps with privacy early on.
Tips
- Start small and add fields only when a flow really needs them.