Design My Database Schema ChatGPT Prompt

मेरा डेटाबेस स्कीमा डिज़ाइन करें

Act as a database architect. I am building [describe your app, e.g. a tuition class management app, a food delivery app for one town, a habit tracker] and need a clean database design before I write code.

Main things the app stores: [list them, e.g. users, batches, payments, attendance]
Key actions users take: [e.g. join a batch, pay fees monthly, mark attendance]
Database: PostgreSQL

Give me:
1. **Entities and relationships** – each table with a one-line purpose, and how tables connect (one-to-many, many-to-many).
2. **Schema** – CREATE TABLE statements (or document structure for NoSQL) with data types, primary keys, foreign keys and sensible constraints.
3. **Text diagram** – a simple ER diagram drawn in text.
4. **Indexes** – which columns to index and why, based on the queries my app will run most.
5. **Sample queries** – 4 common queries written out.
6. **Future-proofing** – 3 changes I might need at 10x users, and how this design handles them.

Point out any part of my description that is unclear and the assumption you made.

• database design
• schema
• er diagram
• backend
• sql tables
• app banana

Options you can change

• Database: PostgreSQL, MySQL, SQLite, MongoDB, Firebase Firestore, Supabase

The prompt above uses the default choice. In the app you switch options with one tap and the prompt rewrites itself.

How to use it

1. Copy the prompt.
2. Open ChatGPT or Gemini and paste it.
3. Replace anything in [square brackets] with your own details, then send.
4. Ask for changes: "shorter", "more formal", "in Hindi".