NyanSQLitePydantic-native SQLite Wrapper

Pydantic models as database schemas.
Type-safe, High-performance, Full-text search enabled.

Pydantic Native

Automatically generate tables by registering Pydantic models. Use type hints directly as your schema.

Pydantic's powerful validation runs automatically on inserts and updates, ensuring data integrity.

Intuitive keywords like `name__like` or `age__gt` for complex searches without writing SQL.

Built-in FTS5 support. Enable rapid text search by simply adding the `Searchable` annotation.

Transparently store and retrieve complex types like lists, dicts, datetime, and Enums via automatic JSON serialization.

Bilingual (EN/JA) documentation covering everything from tutorials to best practices.