fastapi/sqlmodel

SQLModel is a Python library that makes it easier to work with SQL databases, the kind of structured databases used to store and retrieve data in rows and columns, by letting you describe your data using plain Python classes instead of writing raw SQL queries. The core idea is that you define a model class (like a Hero class with fields for name, age, and ID) and SQLModel uses that single definition both to create the database table and to validate the data your application works with. This avoids having to define your data structure twice, once for the database layer and once for data validation, which is a common friction point when building web APIs or backend services. Under the hood, SQLModel is built on top of two well-established libraries: SQLAlchemy (which handles the database communication and query logic) and Pydantic (which handles data validation and type checking). Because it sits on top of both, you can use the full power of either library whenever you need more advanced features. The library is designed to work especially well with FastAPI, a popular Python web framework, and was created by the same author. The code examples in the README show how you can create a model class, instantiate it as a Python object (representing a database row), and save it to a database with a few lines of code. Querying the database works similarly, you write a Python expression and get back typed objects your code editor can auto-complete. You would use SQLModel if you are building a Python backend or API and want a straightforward, type-safe way to read and write data to a SQL database without a lot of boilerplate.