sqlmodel-extSQLModel Enhancement Library

Define models, inherit Mixins, get a complete async CRUD API

One-line Async CRUD

save / get / update / delete / count / get_with_count, with built-in pagination, time filtering, and relation preloading

Rich Field Types

Str64, Port, HttpUrl, SafeHttpUrl, IPAddress, Array[T], etc. — Pydantic validation + SQLAlchemy column types in one step

Polymorphic Inheritance

Zero-config support for Joined Table Inheritance (JTI) and Single Table Inheritance (STI), with automatic discriminator columns and subclass registration

Redis Query Caching

CachedTableBaseMixin provides a dual-layer cache (ID + query), with automatic invalidation on CRUD and polymorphic inheritance support

Safe & Reliable

Optimistic locking for concurrency control, @requires_relations to prevent MissingGreenlet, and AST static analysis at startup