backend-models

定义具有适当关系、约束和数据完整性规则的数据库模型、模式和ORM映射。在创建或修改ORM模型类、数据库模式定义、模型关系、验证器或处理models.py、schema.prisma、实体类或Sequelize/TypeORM/ActiveRecord模型定义等文件时使用此技能。在定义主键、外键、索引、唯一约束、时间戳或实现模型验证逻辑、序列化器和数据类型映射时应用此技能。此技能确保模型遵循命名约定,包含适当的数据库约束,定义具有级联行为的清晰关系,平衡规范化与性能需求,并在模型和数据库级别维护数据完整性。

📖 中文导读:定义具有适当关系、约束和数据完整性规则的数据库模型、模式和ORM映射。在创建或修改ORM模型类、数据库模式定义、模型关系、验证器或处理models.py、schema.prisma、实体类或Sequelize/TypeORM/ActiveRecord模型定义等文件时使用此技能。在定义主键、外键、索引、唯一约束、时间戳或实现模型验证逻辑、序列化器和数据类型映射时应用此技能。此技能确保模型遵循命名约定,包含适当的数据库约束,定义具有级联行为的清晰关系,平衡规范化与性能需求,并在模型和数据库级别维护数据完整性。 以下正文为该技能的原始 SKILL.md 内容(英文),上方安装命令可直接使用。

name: Backend Models description: Define database models, schemas, and ORM mappings with proper relationships, constraints, and data integrity rules. Use this skill when creating or modifying ORM model classes, database schema definitions, model relationships, validators, or working with files like models.py, schema.prisma, entity classes, or Sequelize/TypeORM/ActiveRecord model definitions. Apply this skill when defining primary keys, foreign keys, indexes, unique constraints, timestamps, or when implementing model validation logic, serializers, and data type mappings. This skill ensures models follow naming conventions, include appropriate database constraints, define clear relationships with cascade behaviors, balance normalization with performance needs, and maintain data integrity at both the model and database levels.

Backend Models

This Skill provides Claude Code with specific guidance on how to adhere to coding standards as they relate to how it should handle backend models.

When to use this skill

  • When creating or modifying ORM model classes (Django models, SQLAlchemy, Prisma, TypeORM, ActiveRecord)
  • When defining database schemas, entity classes, or data models
  • When establishing relationships between models (one-to-many, many-to-many, foreign keys)
  • When adding database constraints (NOT NULL, UNIQUE, CHECK constraints)
  • When defining model validators, custom fields, or data type mappings
  • When working with files like models.py, schema.prisma, entities/, or model definition files
  • When implementing model-level business logic, computed properties, or hooks
  • When adding timestamps (created_at, updated_at) or soft delete functionality
  • When defining cascade behaviors for relationships (CASCADE, SET NULL, RESTRICT)
  • When optimizing model queries with select_related, prefetch_related, or eager loading
  • When creating model serializers, schemas, or data transfer objects (DTOs)
  • When balancing normalization with denormalization for performance

Instructions

For details, refer to the information provided in this file: backend models