# alfateam/orange-orm

The ultimate ORM for Node and Typescript

Repository: https://github.com/alfateam/orange-orm
Canonical: https://ross.abutalabs.com/products/orange-orm
Homepage: https://orange-orm.io
Language: JavaScript
License: ISC
License Family: permissive
Topics: postgresql, postgres, nodejs, orm, mssql, mysql, sap, sqlite, orms, mssqlserver, rdb, database, sql, typescript
Last push: 2026-08-26T14:03:16+00:00

## Health v2 (maintenance only)
Score: 98/100 (v2, computed 2026-09-03T02:20:16.233290+00:00)
- activity 99, release rhythm 96, longevity 100
- inputs: {"age_days": 4846, "days_push": 7, "days_rel": 24, "gap_med": 6, "n_releases_24m": 48}
- flags: none
- formula: round(0.45*activity + 0.35*rhythm + 0.20*longevity); archived -> min(score, 10)

## Adoption (not part of the score)
Stars 1012, forks 22 (observed 2026-08-28T04:03:13.290162+00:00)

## What it is
Orange ORM is an Object Relational Mapper for Node.js, Bun, and Deno supporting TypeScript and JavaScript with an Active Record pattern and rich querying model. It works with many databases including Postgres, MySQL, SQLite, MS SQL, Oracle, and SAP ASE, and can run in the browser via Express or Hono plugins.

## Use cases
- map database tables to typed objects in typescript without code generation
- query postgres from node with an active record orm
- use an orm that works in bun and deno
- access a sql database from the browser through a safe plugin
- build crud apis against mysql or mssql with full intellisense
- run sqlite queries in cloudflare workers

## When to choose
- you want a typed active record orm across many sql databases and runtimes
- you need full intellisense without code generation steps
- you target multiple runtimes like node, bun, deno, or cloudflare workers

## When to avoid
- you need a mature orm with a very large community and ecosystem
- you prefer a data-mapper style orm like typeorm or prisma
- you need nosql or vector database support

## Facets
- artifact type: library
- maturity: active
- function: orm, database, database-driver
- domain: databases, backend, web-development, developer-tools
- platform: bun, browser, cross-platform
- tags: typescript, active-record, sql, postgresql, mysql, sqlite, mssql, oracle, sap-ase, cloudflare-d1, pglite, no-codegen, nodejs, deno

## Member repositories
- alfateam/orange-orm (main) score 98

## Provenance
- Observed fields: from GitHub, fetched 2026-08-28T04:03:13.290162+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-30T07:11:43.799883+00:00, confidence not recorded.
  - readme: https://github.com/alfateam/orange-orm (fetched 2026-08-28T04:03:13.290162+00:00, sha 859fd56aa2a9)
  - homepage: https://orange-orm.io (fetched 2026-08-29T13:11:31.053948+00:00, sha 01c6513c4f6a)
  - site_page: https://orange-orm.io/installation.html (fetched 2026-08-29T13:11:31.057597+00:00, sha 2f02b93685f7)
- Data as of 2026-08-30T08:39:29.467469+00:00.