Database Schema Design

ПродвинутыйdataМинимальный контекст: 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

Варианты использования

  • 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

Пример промпта

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

Рекомендуемые модели

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

Совместимые инструменты

claude-codecursorgithub-copilotkiroany

Модальности

Вход: text
→
Выход: code, text

Похожие Skills

sql-generationapi-design

Автор

OpenModels Community

@openmodelsrun