Implements Active Record database access in Node.js, Bun, and Deno across multiple SQL databases.
npx skills add https://github.com/alfateam/orange-orm --skill orange-orm
Please help me install this Agent Skill. Skill: orange-orm Source: https://github.com/alfateam/orange-orm Command: npx skills add https://github.com/alfateam/orange-orm --skill orange-orm
Writing and maintaining database access code for Node.js, Bun, or Deno applications often requires boilerplate SQL, manual relation handling, and code generation for type safety. This Skill provides authoritative guidance for using Orange ORM to map tables, query, insert, update, and delete rows with full TypeScript IntelliSense and no code generation.
Ask the AI to define an Orange ORM table mapping for your schema and write a query that fetches rows with related data using a where filter.
High-intent search queries and answers about installing and using this skill.
Use orange.map() with x.table() to declare tables and column() to define each column's name, type, and constraints like .primary() and .notNull(). Relationships are added in a second chained .map() call using hasMany, hasOne, and references with .by('foreignKey').
Pass a where option to getMany or getOne using column operators like eq, greaterThan, contains, and startsWith. Relation sub-filters such as lines.any(), all(), none(), and count() let you filter parents based on child rows.
Orange ORM supports PostgreSQL, SQLite, MySQL, MariaDB, MS SQL, Oracle, SAP ASE, PGlite, and Cloudflare D1. Each database has a dedicated connector method on the map object, such as map.postgres() or map.sqlite().
Yes, through the Express or Hono server adapter, which replays client method calls on the server without exposing raw SQL. The browser client connects via map.http() pointing at the mounted endpoint, and raw SQL queries are blocked over HTTP.
No, Orange ORM provides full IntelliSense directly from the map definition without code generation. Insert payloads, filters, and results are type-checked, and you can extract row types using ReturnType<typeof db.table.tsType>.
Wrap operations in db.transaction() and use the provided tx object for all queries and inserts. If the callback throws, everything rolls back; note that transactions are not supported on Cloudflare D1.
sraloffEnforce naming, normalization, key, and constraint rules for SQL schemas.
ColdBoxParse and generate RSS 2.0 and Atom feeds for ColdBox applications.
Hopin-incIdentify and remediate authentication, authorization, and data-handling weaknesses in GraphQL APIs.
NevaberryUpdate Drizzle ORM code for v1 beta imports, drivers, relations, and migrations.
