pydantic-sqlite

pydantic-sqlite makes it easy to store Pydantic models directly in a SQLite database and retrieve fully-typed objects -> no manual serialization.

pydantic-sqlite bridges the gap between Pydantic models and SQLite persistence. Instead of manually mapping your models to database columns or writing SQL, you work directly with your Pydantic BaseModel instances. The library automatically handles serialization and deserialization. You can store BaseModel instancea directly in the database, and when querying, you always get back fully reconstructed, ready-to-use Pydantic objects—just like your originals.

Documentation and Examples

For documentation, and examples, visit: pydantic-sqlite Documentation

Installation

Using pip

pip install pydantic-sqlite

Using uv

uv add pydantic-sqlite

Using poetry

poetry add pydantic-sqlite

Quick Start

from pydantic import BaseModel
from pydantic_sqlite import DataBase

class Person(BaseModel):
    uuid: str
    name: str
    age: int

# Create a database
db = DataBase()

# Add a person - just pass your model instance
person = Person(uuid="1", name="Alice", age=30)
db.add("Persons", person)

# Retrieve all people - you get back Person instances, not raw rows
for person in db("Persons"):
    print(f"{person.name} is {person.age} years old")
    assert isinstance(person, Person)  # ✓ True

Support

• Repository: GitHub
• Issues: Report bugs or request features

License

MIT – See LICENSE for details.