# encode/orm

An async ORM. 🗃

Repository: https://github.com/encode/orm
Canonical: https://ross.abutalabs.com/products/encode-orm
Homepage: https://www.encode.io/orm
Language: Python
License: BSD-3-Clause
License Family: permissive
Archived: true
Last push: 2022-08-30T10:12:31+00:00

## Health v2 (maintenance only)
Score: 10/100 (v2, computed 2026-09-02T17:46:02.011165+00:00)
- activity 0, release rhythm 8, longevity 100
- inputs: {"age_days": 2759, "days_push": 1464, "days_rel": null, "gap_med": null, "n_releases_24m": 0}
- flags: archived
- formula: round(0.45*activity + 0.35*rhythm + 0.20*longevity); archived -> min(score, 10)

## Adoption (not part of the score)
Stars 1859, forks 95 (observed 2026-08-28T04:05:45.166184+00:00)

## What it is
An async ORM for Python supporting Postgres, MySQL, and SQLite, built on SQLAlchemy core, the databases library, and typesystem validation. It provides declarative model definitions with async query APIs and works with Alembic for migrations.

## Use cases
- async database access in python
- define models for postgres with asyncio
- query sqlite asynchronously
- use an orm with fastapi
- validate model fields in python
- manage mysql models without sync blocking

## When to choose
- you need an asyncio-native ORM for Postgres, MySQL, or SQLite
- you want a lightweight declarative model layer built on SQLAlchemy core
- you already use encode/databases and want model support

## When to avoid
- you need a mature, actively developed ORM - the project has seen little activity since 2022
- you need advanced ORM features like complex relationships or lazy loading
- you prefer Django ORM or SQLAlchemy ORM's full feature set

## Facets
- artifact type: library
- maturity: maintenance
- function: orm, database, database-driver, serialization
- domain: databases, backend, web-development, developer-tools
- platform: python, cross-platform
- tags: async, sqlalchemy, postgres, mysql, sqlite, encode

## Member repositories
- encode/orm (main) score 10

## Provenance
- Observed fields: from GitHub, fetched 2026-08-28T04:05:45.166184+00:00.
- Health v2: computed from the inputs above; adoption is never an input.
- Inferred fields (summary, facets, guidance): AI-extracted, prompt v1, taxonomy v1, on 2026-08-30T03:16:00.332439+00:00, confidence not recorded.
  - readme: https://github.com/encode/orm (fetched 2026-08-28T04:05:45.166184+00:00, sha 64186f471793)
  - homepage: https://www.encode.io/orm (fetched 2026-08-29T10:55:09.949682+00:00, sha 9aa2e767183c)
  - registry_pypi: https://pypi.org/pypi/orm/json (fetched 2026-08-29T10:55:09.959995+00:00, sha 37d87a704ae4)
- Data as of 2026-08-30T08:39:29.467469+00:00.