ormar-orm/ormar

Health v2 · maintenance only

Adoption not part of the score

1802 stars · 97 forks observed · 2026-08-28

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

Ormar is an async mini ORM for Python supporting Postgres, MySQL, and SQLite, built on SQLAlchemy Core with pydantic validation. It lets you maintain a single model that works directly as FastAPI request and response models.

Use cases

• build async FastAPI apps with database models
• use one model for both ORM and pydantic validation
• query Postgres, MySQL, or SQLite asynchronously
• generate migrations with alembic
• avoid duplicating pydantic and ORM models

When to choose

• you use FastAPI or Starlette and want a single model for validation and persistence
• you need a lightweight async ORM without maintaining separate schemas
• you want SQLAlchemy Core query building with pydantic-style models

When to avoid

• you need the full SQLAlchemy ORM feature set like advanced relationship loading
• your project is synchronous-only
• you need databases beyond Postgres, MySQL, and SQLite

Facets

library · maturity active

orm database serialization form-handling databases web-development backend apis python cross-platform async pydantic fastapi sqlalchemy-core alembic single-model

Member repositories

For agents

markdown · JSON · MCP: product_card(name="ormar-orm/ormar")