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