sqlmodel-data-modeling

SQLModel基于ORM的数据建模指南。用于定义数据库模型、字段、约束、关系(1:N,N:M)、继承、验证器以及处理JSON字段和时间戳。提供User、Task和Category模型的模板。

📖 中文导读:SQLModel基于ORM的数据建模指南。用于定义数据库模型、字段、约束、关系(1:N,N:M)、继承、验证器以及处理JSON字段和时间戳。提供User、Task和Category模型的模板。 以下正文为该技能的原始 SKILL.md 内容(英文),上方安装命令可直接使用。

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.