Database Schema Design

advanceddataMin 32K context

Designs normalized database schemas from business requirements. Covers entity relationships, indexing strategies, migration planning, and performance considerations. Supports PostgreSQL, MySQL, MongoDB, and other databases with dialect-specific optimizations.

databaseschemapostgresqlmigrationsdata-modelingerd

Use Cases

  • Designing schemas for new applications from requirements
  • Normalizing existing denormalized data structures
  • Planning database migrations with zero-downtime strategies
  • Optimizing query performance through indexing
  • Designing multi-tenant database architectures

Example Prompt

Design a database schema for the following system:

"[describe the system and its entities]"

Requirements:
- Target database: [PostgreSQL / MySQL / MongoDB]
- Expected scale: [rows, queries/sec, growth rate]
- Key access patterns: [list main queries]

Deliverables:
1. Entity-relationship diagram (text-based)
2. CREATE TABLE statements with constraints
3. Index recommendations with justification
4. Migration strategy from current state (if applicable)
5. Performance considerations and trade-offs

Recommended Models

claude-opus-4-6gpt-5gemini-2-5-pro

Compatible Tools

claude-codecursorgithub-copilotkiroany

Modalities

Input: text
→
Output: code, text

Related Skills

sql-generationapi-design

Author

OpenModels Community

@openmodelsrun