Pydantic-SQLAlchemy
Generate Pydantic models from SQLAlchemy models for data validation and serialization.
What is Pydantic-SQLAlchemy?
Pydantic-SQLAlchemy is a Python library that automatically generates Pydantic models from existing SQLAlchemy models. It bridges the gap between database layer definitions and API data validation, enabling seamless use of SQLAlchemy models in Pydantic-based applications like FastAPI. The project is described as experimental, with the author now recommending SQLModel for a more robust solution.
Python developers working with SQLAlchemy for database modeling and Pydantic for data validation, particularly those building APIs with frameworks like FastAPI who need to avoid duplicating model definitions.
It eliminates the need to manually maintain separate Pydantic schemas by dynamically generating them from SQLAlchemy models, reducing boilerplate and ensuring consistency. However, the author notes limitations like lack of autocompletion and recommends SQLModel for most use cases as a more integrated alternative.
Overview
Tools to convert SQLAlchemy models to Pydantic models
Use Cases
Best For
- Automatically generating Pydantic validation models from existing SQLAlchemy declarative base classes.
Found a gem we're missing?
Open-Awesome is built by the community, for the community. Submit a project, suggest an awesome list, or help improve the catalog on GitHub.