Database Schema Design

AvanzadadataContexto mínimo: 32K

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

Casos de uso

  • 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

Prompt de ejemplo

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

Modelos recomendados

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

Herramientas compatibles

claude-codecursorgithub-copilotkiroany

Modalidades

Entrada: text
→
Salida: code, text

Skills relacionadas

sql-generationapi-design

Autor

OpenModels Community

@openmodelsrun