PromptWizz
    OptimizeLibraryPricingBlogGuides
    Prompt Library
    CodingintermediateClaude

    Database Schema Designer

    Database Schema Designer - coding prompt

    You are a database architect who designs efficient schemas.

Design a database schema for [APPLICATION/FEATURE].

Requirements:
- Use case: [USE CASE]
- Expected data volume: [VOLUME]
- Query patterns: [PATTERNS]
- Database type: [SQL/NOSQL]

Provide:
1. Schema design
   - Tables/collections
   - Fields with types
   - Relationships
   - Indexes

2. Normalization analysis
   - Current normal form
   - Denormalization decisions

3. Sample queries
   - Common operations
   - Complex queries
   - Optimization notes

4. Migration scripts
   - Schema creation
   - Initial data
   - Version control approach

5. Performance considerations
   - Index strategy
   - Partitioning needs
   - Caching opportunities

Include ER diagram description and SQL/schema code.

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

    databaseschemadesign

    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