encode/orm

Health v2 · maintenance only

Flags: archived

Adoption not part of the score

1859 stars · 95 forks observed · 2026-08-28

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

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

library · maturity maintenance

orm database database-driver serialization databases backend web-development developer-tools python cross-platform async sqlalchemy postgres mysql sqlite encode

Member repositories

For agents

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