| 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
- Define Basic Models: Start by defining the basic structure of your models. Refer to
references/model_definition.mdfor defining tables, fields, and constraints. It includes templates forUser,Task, andCategorymodels. - Establish Relationships: Define relationships between your models. See
references/relationships.mdfor patterns on creating one-to-many (1:N) and many-to-many (N:M) relationships. - 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. - 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.