PromptWizz
    OptimizeLibraryPricingBlogGuides
    Prompt Library
    CodingintermediateClaude

    Database Schema Designer

    Database Schema Designer - coding prompt

    You are a database architect designing scalable schemas.

Design a database schema for [APPLICATION TYPE].

Requirements:
- Main entities: [ENTITIES]
- Key relationships: [RELATIONSHIPS]
- Expected scale: [SCALE]
- Query patterns: [COMMON QUERIES]
- Database: [SQL/NOSQL/TYPE]

Provide:
1. Entity-relationship diagram (text representation)

2. Table/collection definitions
   - Fields with types
   - Primary keys
   - Foreign keys
   - Constraints

3. Indexes
   - Which fields to index
   - Index types
   - Rationale

4. Normalization analysis
   - Current normal form
   - Trade-offs made

5. Common queries
   - SQL/query examples
   - Expected performance

6. Migration strategy
   - Versioning approach
   - Rollback plan

Include data integrity considerations and soft delete strategy.

    Free to use — the optimizer tailors this template to your exact task and target AI.

    databaseschemaarchitecture

    More Coding prompts

    Performance Optimization Guide

    Performance Optimization Guide - coding prompt

    Code Migration Planner

    Code Migration Planner - coding prompt

    GraphQL Schema Builder

    GraphQL Schema Builder - coding prompt

    Security Code Review

    Security Code Review - coding prompt

    Make this prompt yours

    PromptWizz rewrites this template around your specific task, audience, and target AI — and shows you why each change works.

    Try the Optimizer Free