Prompt Library › ⚙️ Technical › Database Schema Designer
GPT-4o ⚙️ Technical Advanced

Database Schema Designer

Design a normalized, production-ready database schema for your app with table definitions, indexes, and relationship guidance.

👁 16 views ⎘ 0 copies ♥ 0 likes

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.