# ormar

Async Python ORM that uses pydantic models for validation and is designed for async frameworks such as FastAPI.


Source: https://findsoftware.frbit.cloud/ormar/
Last reviewed: 2026-11-16
Listed since: 2026-11-16

## Record

### Links

- home: https://ormar-orm.github.io/ormar/latest/
- repository: https://github.com/ormar-orm/ormar

### Identity

- status: active
- maintainer: Radosław Drążkiewicz
- maintainerType: unknown
- parent: unknown
- firstRelease: 2020
- hqCountry: unknown

### Kind

- category: library
- hosting: python
- language: python
- runtime: python
- runtimeMin: python 3.11
- basedOn: sqlalchemy

### Content

- contentStore: not applicable
- databases: postgres, mysql, sqlite
- adminUi: not applicable
- headlessApi: not applicable
- templating: not applicable
- i18n: not applicable

### Rendering and deploy

- runsAs: not applicable
- renderingModes: not applicable
- installMethod: pip

### License

- licenseModel: open-source
- license: MIT

### Releases

- currentMajor: 0
- latestReleaseDate: 2026-11-16

### Adoption

- githubStargazers: 1797
- packagistDownloads: not applicable
- npmWeeklyDownloads: not applicable
- contributors: 52
- pluginCount: unknown
- packagistMonthlyDownloads: unknown
- ecosystemsMonthlyDownloads: unknown
- httpArchiveSites: unknown
- wordpressActiveInstalls: unknown
- dependentRepos: 127
- dependentPackages: 10

### Sources

- urls: https://ormar-orm.github.io/ormar/latest/ (read 2026-11-16)
- urls: https://api.github.com/repos/ormar-orm/ormar (read 2026-11-16)
- maintainer: https://github.com/ormar-orm/ormar/blob/master/LICENSE.md (read 2026-11-16)
- firstRelease: https://pypi.org/pypi/ormar/json (read 2026-11-16)
- category: https://ormar-orm.github.io/ormar/latest/ (read 2026-11-16)
- language: https://api.github.com/repos/ormar-orm/ormar (read 2026-11-16)
- runtime: https://github.com/ormar-orm/ormar/blob/0.30.0/pyproject.toml (read 2026-11-16)
- runtimeMin: https://github.com/ormar-orm/ormar/blob/0.30.0/pyproject.toml (read 2026-11-16)
- databases: https://github.com/ormar-orm/ormar/blob/master/README.md (read 2026-11-16)
- basedOn: https://github.com/ormar-orm/ormar/blob/master/README.md (read 2026-11-16)
- installMethod: https://github.com/ormar-orm/ormar/blob/master/docs/install.md (read 2026-11-16)
- license: https://api.github.com/repos/ormar-orm/ormar (read 2026-11-16)
- licenseModel: https://github.com/ormar-orm/ormar/blob/master/README.md (read 2026-11-16)
- currentMajor: https://github.com/ormar-orm/ormar/releases/tag/0.30.0 (read 2026-11-16)
- latestReleaseDate: https://github.com/ormar-orm/ormar/releases/tag/0.30.0 (read 2026-11-16)
- githubStargazers: https://api.github.com/repos/ormar-orm/ormar (read 2026-11-16)
- contributors: https://api.github.com/repos/ormar-orm/ormar/contributors?per_page=1 (read 2026-11-16)
- dependentPackages: https://packages.ecosyste.ms/api/v1/registries/pypi.org/packages/ormar (read 2026-11-16)
- dependentRepos: https://packages.ecosyste.ms/api/v1/registries/pypi.org/packages/ormar (read 2026-11-16)

## Notes

ormar is an async object-relational mapper for Python. Its models are pydantic models, so the same class validates data and can serve as a request or response model in a FastAPI app. It is built on SQLAlchemy core for query building, and a translation tool for existing SQLAlchemy models is documented. The [documentation](https://ormar-orm.github.io/ormar/latest/) covers models, queries, relations and use with FastAPI.

## Worth knowing

The README says the project is still under development and recommends pinning the version. Its versioning note says breaking changes bump the minor number, so a minor update within the 0.x line can carry breaking changes.

---

Data licensed CC BY 4.0 (https://creativecommons.org/licenses/by/4.0/). Attributes are recorded, never scored; absent means unknown.
Credit, in full: FindSoftware, CC BY 4.0
