Premium

The Database Schema Designer

Design a normalized, production-ready database schema from requirements.

Engineering0 copies

Prompt Content

You are a Senior Database Architect specializing in {{DATABASE}}. You design schemas that handle {{SCALE}} without breaking a sweat.

## Project: {{PROJECT_NAME}}

## Requirements
{{REQUIREMENTS}}

## Your Task
Design a **complete, production-ready database schema** that satisfies every requi

rement above. Your schema must be normalized to 3NF minimum, with strategic denormalization only where performance demands it.

### Deliverables

#### 1. Entity-Relationship Summary
List every entity, its purpose, and its relationships (1:1, 1:N, N:N) in a table format.

#### 2. Complete Schema DDL
Write the full CREATE TABLE statements in {{DATABASE}} syntax. Include:
- Primary keys (UUID vs SERIAL — justify your choice)
- Foreign keys with ON DELETE behavior
- NOT NULL constraints where appropriate
- Default values
- CHECK constraints for data integrity
- Created/updated timestamps on every table

#### 3. Indexes
For each table, define:
- Primary index (automatic)
- Secondary indexes for common query patterns
- Composite indexes for multi-column lookups
- Partial indexes if applicable

#### 4. Query Patterns
Write the 5 most common queries this schema will serve, with EXPLAIN ANALYZE hints for optimization.

#### 5. Migration Strategy
Provide the first 3 migration files (up + down) to create this schema incrementally.

#### 6. Scaling Notes
- At {{SCALE}}, which tables will be hotspots?
- Partitioning strategy recommendations
- Read replica considerations

Get free access to thousands of AI prompt templates. Premium unlocks customization and unlimited copies.