GPT-4o
⚙️ Technical
Advanced
Database Schema Designer
Design a normalized, production-ready database schema for your app with table definitions, indexes, and relationship guidance.
The Prompt
# Database Schema Designer You are a database architect helping someone design a clean, scalable database schema. ## My Application - What the app does: [APP — e.g., a task management app, an e-commerce store, a booking platform] - Database type: [DB TYPE — MySQL / PostgreSQL / SQLite] - Key entities (the main "things" in my app): [ENTITIES — e.g., users, projects, tasks, comments, attachments] - Key relationships: [RELATIONSHIPS — e.g., a user has many projects, a project has many tasks, tasks can have subtasks] - Special requirements: [REQUIREMENTS — e.g., soft deletes, audit trail, multi-tenancy, full-text search] - Scale expectations: [SCALE — e.g., small hobby project / 100k rows per table / millions of records] ## What I Need 1. Complete CREATE TABLE statements for all entities 2. Foreign key relationships and constraints 3. Recommended indexes for the most common query patterns 4. Any normalization decisions explained (why I split or combined tables) 5. Fields I might be forgetting (created_at, soft deletes, status enums, etc.)
📝 Fill in the blanks
Replace these placeholders with your own content:
[APP — e.g., a task management app, an e-commerce store, a booking platform]
[DB TYPE — MySQL / PostgreSQL / SQLite]
[ENTITIES — e.g., users, projects, tasks, comments, attachments]
[RELATIONSHIPS — e.g., a user has many projects, a project has many tasks, tasks can have subtasks]
[REQUIREMENTS — e.g., soft deletes, audit trail, multi-tenancy, full-text search]
[SCALE — e.g., small hobby project / 100k rows per table / millions of records]
How to use this prompt
1
Hit "Run it in your AI"
We open ChatGPT, Claude, Gemini, Perplexity, Grok or Copilot with this prompt in the box, ready for you to press Enter — and copied to your clipboard as a backup. Pick your AI once and we remember it.
2
Replace the placeholders
Swap out anything in [BRACKETS] with your specific details.
3
Send it
This prompt is tuned for GPT-4o, but it works well in any of them. Prefer to do it by hand? Copy to clipboard is always there too.
Get prompts like this every Monday
Free weekly digest — hand-picked prompts, new tools, AI news.