fastapi/sqlmodel

Health v2 · maintenance only

Adoption not part of the score

18386 stars · 892 forks observed · 2026-10-14

What it is AI-extracted, prompt v1, taxonomy v1, 2026-08-29, confidence not recorded

SQLModel is a Python library for interacting with SQL databases using Python objects, built as a thin layer on top of SQLAlchemy and Pydantic. It lets a single type-annotated model serve as both the database schema and the validation/serialization model, minimizing code duplication.

Use cases

• define database models with python type hints
• use one model for both orm and api validation
• interact with sql databases in a fastapi app
• avoid duplicating sqlalchemy and pydantic models
• query and persist rows using python objects
• build crud apis backed by a relational database

When to choose

• you're building a FastAPI application that needs a SQL database
• you want Pydantic validation and SQLAlchemy ORM in a single model
• you value editor autocompletion and minimal boilerplate
• you want a simple, modern-Python ORM with sensible defaults

When to avoid

• you need advanced SQLAlchemy features not exposed by the thin layer
• you're working outside Python or with NoSQL databases
• you already have separate mature SQLAlchemy and Pydantic model layers
• you need a fully mature 1.0-guaranteed API (it's still 0.x)

Facets

library · maturity stable

orm database serialization api-framework databases web-development backend developer-tools python cross-platform sqlalchemy pydantic fastapi sql type-annotations data-modeling

Member repositories

For agents

markdown · JSON · MCP: product_card(name="fastapi/sqlmodel")