Database Schema Design

İleridataEn az 32K bağlam

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

Kullanım alanları

  • 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

Örnek 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

Önerilen modeller

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

Uyumlu araçlar

claude-codecursorgithub-copilotkiroany

Modaliteler

Giriş: text
→
Çıkış: code, text

İlgili Skills

sql-generationapi-design

Yazar

OpenModels Community

@openmodelsrun