sqlmodel-crud

What problem does it solve?

This skill helps developers design SQLModel-based database models with table=True, define relationships, and implement robust, asynchronous CRUD operations, enabling scalable data layers for modern apps.

Core Features & Use Cases

• Model definitions: Define SQLModel models with table=True, proper Field validators, indices, and unique constraints for real-world entities.
• Relationships & joins: Configure bidirectional relationships with back_populates, and perform joins and subqueries to fetch related data efficiently.
• Async CRUD & pagination: Implement create/read/update/delete operations using AsyncSession, with pagination, filtering, and safe transaction handling.
• Advanced queries: Build complex queries including filters, ordering, and aggregations across related entities.

Quick Start

Initialize the database, create sample entities (e.g., Student, Class, Fee), and perform a sequence of CRUD operations: create a record, fetch by ID, update fields, and delete the record.