@alpha.consultings/eloquent-orm.js
Advanced tools
A Laravel Eloquent-inspired ORM Multi Driver SQL & NoSQL and Cache System and Artisan CLI like for Node.js Lovers
Quick info:
@alpha.consultings/eloquent-orm.js
Laravel-inspired ORM + CLI for Node.js + TypeScript with SQL and MongoDB runtime support.Quick info:
@alpha.consultings/eloquent-orm.jsv1.1.4v1.1.4 latestv1.1.31.1.0, emit PostgreSQL boolean defaults as TRUE / FALSE instead of 0 / 1, order brand-new create migrations by dependencies declared in both static schema and static database.foreignKeys, resolve the shipped CLI banner version from package.json instead of the stale v1.0 literal, and lock the CLI SemVer rule in the published versioning policy while preserving the clean NodeNext source-tree, CommonJS dist/* build, and 100% coverage baseline.belongsTo, hasMany, belongsToMany, morph*).npm install @alpha.consultings/eloquent-orm.js
The following versions are the current supported and CI-tested prerequisites.
| Component | Supported / tested version |
|---|---|
| Node.js | `^20 |
| TypeScript | ^5.9.3 |
| MySQL | 8.0 |
| PostgreSQL | 16 |
| MongoDB | 7 |
| SQLite | SQLite 3.x via better-sqlite3 12.2.0 |
| Memcached | 1.6+ server, client package ^2.2.2 |
Run commands with:
npx eloquent
npx eloquent make:model User --with-migration
Note: command syntax is eloquent make:model User, not eloquent: make: model.
Express.js is the required runtime for HTTP-facing usage in this project and integrates without issues.
import { registerModels } from "@alpha.consultings/eloquent-orm.js";
import { User } from "./app/models/User";
import { Post } from "./app/models/Post";
registerModels([User, Post]);
npx eloquent make:migration --all
npx eloquent migrate:run --test --all-migrations
import { setupCache } from "@alpha.consultings/eloquent-orm.js";
setupCache(); // Memory/Staging/Production cache selector from env
npx eloquent make:model User --with-migrationnpx eloquent make:service Usernpx eloquent make:controller Usernpx eloquent make:seed User --count 10npx eloquent make:migration --allnpx eloquent migrate:runnpx eloquent migrate:fresh --force --yesnpx eloquent db:seed --class BlogScenarioSeeder --testUse static safe-finders for targeted reads and creation, and use loaded instances for persistence updates.
import { User } from "./app/models/User";
// List all
const users = await new User().all();
// Safe finder + query chain
const recentActiveUsers = await User.where("is_active", true)
.orderBy("created_at", "desc")
.limit(20)
.get();
const oneByEmail = await User.findOneBy("email", "alice@example.com");
const byId = await User.find(10);
// Create
const created = await User.create({
name: "Alice",
email: "alice@example.com",
});
// Update via instance persistence
if (created) {
created.update({ name: "Alice Johnson" });
await created.save();
}
// Patch directly if already persisted
const persisted = await User.findOneBy("email", "alice@example.com");
await persisted?.patch?.({ name: "Alice K." });
// Delete
await User.deleteById(1);
// Bulk helpers
await User.createMany([
{ name: "Bob", email: "bob@example.com" },
{ name: "Carol", email: "carol@example.com" },
]);
await User.updateMany([1, 2], { is_active: false });
await User.deleteMany([1, 2]);
Soft delete is supported by model mixins, and delete behavior is routed to deleted_at when that field is present in your schema/model state.
await User.deleteById(1); // marks deleted_at
await User.restoreById(1); // clears deleted_at
If your model does not currently use soft-delete columns, keep delete/restore aligned with your schema.
npx eloquent make:service User
Generated service (app/services/UserService.ts):
const service = new UserService();
await service.all();
await service.find(1);
await service.create({ name: "Alice", email: "alice@example.com" });
await service.update(1, { email: "new@example.com" });
await service.delete(1);
await service.restore(1);
This keeps controller code simple and centralizes persistence logic per domain entity.
setupCache() configures the active cache driver based on environment.
For read-heavy endpoints, cache at service/query boundary using CacheManager (public API).
import { CacheManager, setupCache } from "@alpha.consultings/eloquent-orm.js";
setupCache();
export async function getActiveUsersFromCache() {
const key = "users:active:v1";
const cached = await CacheManager.get(key);
if (cached) return cached;
const users = await User.where("is_active", true).orderBy("created_at", "desc").get();
await CacheManager.set(key, users, 60);
return users;
}
export async function createUser(payload: Record<string, unknown>) {
const user = await User.create(payload);
await CacheManager.delete("users:active:v1"); // invalidate read cache after write
return user;
}
CLI cache helpers:
npx eloquent cache:stats (inspect runtime cache stats)npx eloquent cache:clear (clear all cache entries)The full consumer documentation is organized around the main usage paths:
Get Started: installation, quick start, common scenarios, and cookbook guidesRuntime: CRUD, querying, models, controllers, services, and cacheTest: Jest/runtime testing, factories, seeds, scenarios, and pack smokeORM: relations, mixins, soft deletes, migrations, multi-connection strategy, and Mongo guidanceCLI: commands, generators, production-safety rules, and test matrix guidanceOfficial documentation:
Start with:
.map files to keep the install surface smaller.Some package scanners flag this package for network access and eval-like behavior. Those signals are expected for this runtime shape and should be read in context:
DB_HOST, DB_PORT, PG_HOST, PG_PORT, MONGO_URI, MONGO_TEST_URI, MEMCACHED_HOST, and MEMCACHED_PORT.mongodb+srv:// URI and set MONGO_DNS_SERVERS, the runtime may call Node's in-process DNS resolver override for Mongo SRV lookups.mysql2 dependency, which generates row parsers dynamically for performance.readCodeFor arbitrary code injection issue affected mysql2 versions earlier than 3.9.7. This package currently depends on mysql2 ^3.15.2, which is above that fixed line and is not in the vulnerable range.mysql2 project continued shipping security hardening after that fix. The official 3.19.1 release notes mention bounds checks, malformed payload handling, and config-injection hardening, and npm currently lists 3.20.0 as the latest stable release as of March 25, 2026.mysql2 < 3.9.7 was vulnerable, while this package's supported range is above that threshold.For the current hosted docs and security guidance:
FAQs
A Laravel Eloquent-inspired ORM Multi Driver SQL & NoSQL and Cache System and Artisan CLI like for Node.js Lovers
The npm package @alpha.consultings/eloquent-orm.js receives a total of 496 weekly downloads. As such, @alpha.consultings/eloquent-orm.js popularity was classified as not popular.
We found that @alpha.consultings/eloquent-orm.js demonstrated a healthy version release cadence and project activity because the last version was released less than a year ago. It has 1 open source maintainer collaborating on the project.
Did you know?
Socket for GitHub automatically highlights issues in each pull request and monitors the health of all your open source dependencies. Discover the contents of your packages and block harmful activity before you install or update your dependencies.
Security News
Open source is under attack because of how much value it creates. It has been the foundation of every major software innovation for the last three decades. This is not the time to walk away from it.
Security News
Socket CEO Feross Aboukhadijeh breaks down how North Korea hijacked Axios and what it means for the future of software supply chain security.
Security News
OpenSSF has issued a high-severity advisory warning open source developers of an active Slack-based campaign using impersonation to deliver malware.