EmberORM

A Prisma-like ORM for Firebird, written in TypeScript. Schema language, database introspection (db pull), generated typed client, and an object-based query API (where, select, include, orderBy, aggregations, transactions).

npm install @mateusseiboth/ember-orm

Quick start

# 1. scaffold a schema
npx ember init

# 2. point it at your database
export DATABASE_URL="firebird://SYSDBA:masterkey@localhost:3050//var/lib/firebird/app.fdb"

# 3. import an existing database into the schema
npx ember db pull

# 4. generate the typed client
npx ember generate

# 5. (optional) browse & edit your data in EmberStudio
npx ember studio

import { EmberClient } from "./generated";

const db = new EmberClient();
await db.$connect();

const users = await db.user.findMany({
  where: { active: true, email: { endsWith: "@acme.com" } },
  include: { posts: { where: { published: true } } },
  orderBy: { createdAt: "desc" },
  take: 20,
});

await db.$transaction(async (tx) => {
  const u = await tx.user.create({ data: { email: "[email protected]", name: "Ada" } });
  await tx.post.create({ data: { title: "Hi", author: { connect: { id: u.id } } } });
});

Schema example

datasource db {
  provider = "firebird"
  url      = env("DATABASE_URL")
}

generator client {
  provider = "ember-client-js"
  output   = "../generated"
}

model User {
  id        Int      @id @default(autoincrement())
  email     String   @unique @db.VarChar(255)
  name      String?
  posts     Post[]
  createdAt DateTime @default(now()) @map("CREATED_AT")

  @@map("USERS")
}

model Post {
  id       Int    @id @default(autoincrement())
  title    String
  author   User   @relation(fields: [authorId], references: [id], onDelete: Cascade)
  authorId Int    @map("AUTHOR_ID")
}

Feature overview

| Area | Supported | | ----------------- | ------------------------------------------------------------------------- | | Reads | findMany, findFirst(OrThrow), findUnique(OrThrow) | | Writes | create, createMany, update, updateMany, upsert, delete(Many) | | Aggregation | count, aggregate (_count/_sum/_avg/_min/_max), groupBy | | Filtering | equals/not/in/notIn/lt/lte/gt/gte/contains/startsWith/endsWith, mode | | Boolean logic | AND / OR / NOT | | Relation filters | some / every / none / is / isNot (compiled to EXISTS) | | Relations | include & nested select (batched, Prisma-style stitching) | | Nested writes | connect, create, connectOrCreate, disconnect, set, delete | | Pagination | take / skip (FIRST / SKIP) | | Transactions | interactive $transaction(fn) and sequential $transaction([...]) | | Raw | $queryRaw, $executeRaw, *Unsafe variants | | Migrations | ember migrate dev / deploy / status, ember db push (schema↔DB diff) | | Extensions | $extends (result/model/query/client), $use middleware, $on events | | Fluent API | relation traversal: db.user.findUnique(...).posts() | | More ops | omit, createManyAndReturn, groupBy having | | Counts | relation _count in select/include | | Versions | Firebird 2.1 / 2.5 / 3 / 4 / 5 (auto-detected; ?version= to override) | | Logging | log: true or a QueryEvent callback | | Studio | ember studio — local web GUI to browse & edit data (CRUD) | | Tooling | ember init / db pull / generate / format / validate / studio |

EmberStudio

A local web GUI to browse and edit your data — EmberORM's counterpart to Prisma Studio. It reads your schema, connects through the same query engine, and serves a spreadsheet-style UI.

npx ember studio              # http://127.0.0.1:5757
npx ember studio --port 8080  # custom port
npx ember studio --no-open    # don't open the browser

• Browse every model with filtering, column sorting, and pagination — choose the page size or switch to infinite scroll.
• Filter by field + operator, or drop into raw mode to pass a JSON WhereInput (with AND/OR/NOT) straight to the engine.
• Edit cells inline, add records via a schema-driven form, and delete rows — all through findMany / create / update / delete, so values are coerced exactly like the generated client.
• Follow relations: foreign-key cells link to the related model, pre-filtered.
• Visualizer: an ERD-style overview of every model, its fields, primary keys, and relations.
• SQL tab: write statements by hand with syntax highlighting and schema-aware autocompletion (Ctrl+Space); Ctrl/⌘+Enter runs them via $queryRawUnsafe / $executeRawUnsafe and shows the result grid.
• Console: a live, read-only log of every statement the engine executes, with SQL, params, duration, and row count.

EmberStudio binds to loopback (127.0.0.1) and has no authentication — it is a local development tool. Don't expose it to untrusted networks.

Editor support

The EmberORM VSCode extension gives .ember files a Prisma-like experience, powered by a dedicated language server: syntax highlighting, as-you-type diagnostics, canonical formatting with relation auto-completion (and format-on-save), go-to-definition, find references, rename, outline symbols, code actions, and context-aware completion (keywords, types, model/enum names, @/@@ attributes, @db.* native types, functions).

Install from the Marketplace, or from the Quick Open panel (Ctrl/⌘+P):

ext install MateusSeiboth.ember-orm-vscode

To build it from source instead (it lives in editors/vscode):

cd editors/vscode && npm install && npm run build   # then press F5 in VSCode

Editor tooling consumes the driver-free ember-orm/editor entry point (schema parser, validator, printer — no database driver).

Documentation

See /doc for the architecture, schema language, query API, and the Firebird-specific notes (identifier casing, transactions, pagination).

Safety

Every value is bound as a parameter (?) — identifiers are quoted and values are never string-interpolated. Every operation runs inside a transaction.