AgentSkillsCN

sqlmodel-data-modeling

使用 SQLModel 进行 ORM 数据建模的指南。用于定义数据库模型、字段、约束、关系（1:N、N:M）、继承、验证器以及处理 JSON 字段和时间戳。提供用户、任务和类别模型的模板。

SKILL.md
--- frontmatter
name: sqlmodel-data-modeling
description: Guide for ORM-based data modeling with SQLModel. Use for defining database models, fields, constraints, relationships (1:N, N:M), inheritance, validators, and handling JSON fields and timestamps. Provides templates for User, Task, and Category models.

SQLModel Data Modeling

This skill provides guidance and code patterns for creating robust and efficient data models using SQLModel.

Workflow

  1. •Define Basic Models: Start by defining the basic structure of your models. Refer to references/model_definition.md for defining tables, fields, and constraints. It includes templates for User, Task, and Category models.
  2. •Establish Relationships: Define relationships between your models. See references/relationships.md for patterns on creating one-to-many (1:N) and many-to-many (N:M) relationships.
  3. •Implement Advanced Patterns: For more complex scenarios, consult references/advanced_patterns.md. This guide covers model inheritance, a base model with audit timestamp fields, computed properties, and handling of JSON data.
  4. •Add Validation: Implement data validation to ensure integrity. Examples of model validation using SQLModel's features are in references/validation.md.

Always consult the relevant reference document for detailed code examples and best practices for each step.