Run any Skill in Manus with one click

farming-labs-orm

Stars14

Forks1

UpdatedApril 6, 2026 at 16:17

Use when working in the Farming Labs ORM monorepo. Covers the schema DSL, runtime drivers, relation translation, docs updates, release flow, and real local database integration tests. Triggers: createOrm, Prisma driver, Drizzle driver, Kysely driver, MikroORM driver, TypeORM driver, Sequelize driver, Neo4j driver, SurrealDB, Cloudflare D1, Cloudflare KV, Redis, Supabase JS, Xata, EdgeDB, Firestore, DynamoDB, Unstorage, Mongo runtime, Mongoose runtime, update docs, test:local, release latest, compound unique, native relation loading.

Installation

Install with Codex or Claude Copy this prompt, paste it into Codex, Claude, or another assistant, and let it review the skill page and install it for you.

Run Skill in Manus

Source

farming-labs

farming-labs/orm

View GitHub Repository View Creator Repositories

Download

Run Skill in Manus

Related occupationsSOC

Based on SOC occupation classification

Software DevelopersComputer and Mathematical Occupations·SOC 15-1252

SKILL.md

readonly

name

farming-labs-orm

description

Farming Labs ORM

Use this skill when the task is inside the Farming Labs ORM repository or needs repo-specific knowledge about the unified ORM API.

Repo map

packages/orm Core schema DSL, manifest, generators, memory runtime, and createOrm(...)
packages/sql Direct SQL runtime for SQLite, MySQL, and PostgreSQL
packages/prisma Prisma runtime driver
packages/drizzle Drizzle runtime driver
packages/kysely Kysely runtime driver
packages/mikroorm MikroORM runtime driver
packages/typeorm TypeORM runtime driver
packages/sequelize Sequelize runtime driver
packages/edgedb EdgeDB / Gel SQL runtime driver
packages/neo4j Neo4j graph runtime driver
packages/surrealdb SurrealDB multi-model runtime driver
packages/d1 Cloudflare D1 runtime driver
packages/kv Cloudflare KV runtime driver
packages/redis Redis and Upstash-compatible runtime driver
packages/supabase Supabase JS runtime driver
packages/xata Xata runtime driver
packages/firestore Firestore runtime driver
packages/dynamodb DynamoDB runtime driver
packages/unstorage Unstorage runtime driver for lightweight key-value/document storage
packages/mongo Native MongoDB runtime driver
packages/mongoose Mongoose runtime driver
apps/docs Documentation site
apps/demo Swap-style demo app that exercises multiple runtimes

Core expectations

Keep the unified API portable. Library-facing code should go through createOrm(...), not backend-specific query APIs.
Preserve the schema as the source of truth. Relations, mapped column names, constraints, and generated artifacts should derive from the schema DSL.
Prefer real integration coverage when backend behavior changes. If runtime semantics change, add or update the relevant local.integration.ts suite. SQL, Prisma, Drizzle, Kysely, MongoDB, and Mongoose no longer keep separate fake runtime test layers.
Keep docs aligned with shipped behavior. If runtime support, query semantics, or release flow changes, update apps/docs and README.md in the same change.

Runtime conventions

orm.$driver exposes the attached runtime handle.
orm.$driver.kind identifies the backend family.
orm.$driver.client is the original high-level instance passed into the driver where possible.
Transaction-scoped ORM instances should preserve the same driver handle shape.

Testing workflow

Start with:

pnpm typecheck
pnpm test

pnpm test already includes the real backend matrix. Use these when you want to rerun specific local suites:

pnpm test:local

Targeted commands:

pnpm test:local:sql
pnpm test:local:d1
pnpm test:local:kv
pnpm test:local:edgedb
pnpm test:local:neo4j
pnpm test:local:surrealdb
pnpm test:local:drizzle
pnpm test:local:kysely
pnpm test:local:mikroorm
pnpm test:local:sequelize
pnpm test:local:typeorm
pnpm test:local:dynamodb
pnpm test:local:redis
pnpm test:local:supabase
pnpm test:local:xata
pnpm test:local:unstorage
pnpm test:local:mongodb
pnpm test:local:prisma

For live credential-backed verification, use the opt-in path:

pnpm test:xata:real

Use the package-local test files to find coverage:

packages/*/test/local.integration.ts
packages/orm/test/core.test.ts
packages/orm/test/runtime.test.ts

Docs workflow

Main docs pages to keep in sync:

apps/docs/app/docs/runtime/page.mdx
apps/docs/app/docs/integrations/*.mdx
apps/docs/app/docs/schema/*.mdx
apps/docs/app/docs/use-cases/multi-storage-walkthrough/page.mdx
README.md

After docs changes:

pnpm --filter docs test

Release workflow

Current release flow:

pnpm release:latest

That command now runs the full stable release flow, including npm publish. bump.config.ts uses the workspace-recursive release flow.

The release files, commit message, and tag pattern are configured in bump.config.ts.

Beta flow:

pnpm release:beta

Runtime matrix

Current runtime packages in this repo:

@farming-labs/orm
- memory runtime
@farming-labs/orm-sql
- SQLite
- MySQL
- PostgreSQL
@farming-labs/orm-prisma
- real PrismaClient-backed runtime
@farming-labs/orm-drizzle
- Drizzle-backed runtime using the SQL runtime underneath
@farming-labs/orm-kysely
- Kysely-backed runtime using the SQL runtime underneath
@farming-labs/orm-mikroorm
- MikroORM-backed runtime using the SQL runtime underneath
@farming-labs/orm-typeorm
- TypeORM runtime
@farming-labs/orm-sequelize
- Sequelize runtime
@farming-labs/orm-edgedb
- EdgeDB / Gel SQL runtime bridge
@farming-labs/orm-neo4j
- Neo4j graph runtime
@farming-labs/orm-surrealdb
- SurrealDB multi-model runtime
@farming-labs/orm-d1
- Cloudflare D1 runtime
@farming-labs/orm-kv
- Cloudflare KV runtime
@farming-labs/orm-redis
- Redis and Upstash-compatible key-value runtime
@farming-labs/orm-supabase
- direct Supabase JS runtime alongside the raw PostgreSQL helpers in @farming-labs/orm-sql
@farming-labs/orm-xata
- Xata runtime
@farming-labs/orm-firestore
- Firestore runtime
@farming-labs/orm-dynamodb
- DynamoDB runtime
@farming-labs/orm-unstorage
- lightweight key-value/document runtime
@farming-labs/orm-mongo
- native MongoDB runtime
@farming-labs/orm-mongoose
- Mongoose runtime

Current common features:

compound unique lookups
integer() and json()
relation loading
native relation translation for the SQL family and Prisma on supported shapes
orm.$driver access to the attached runtime handle

Important boundary:

@farming-labs/orm-d1 is Worker-friendly at runtime, but @farming-labs/orm-runtime/setup is still for local, CI, or other Node-managed bootstrap flows.
@farming-labs/orm-kv is a Worker-friendly Cloudflare key-value runtime for sessions, tokens, cache metadata, rate limits, and lightweight framework state. It is not the preferred fit for highly relational or join-heavy workloads.
@farming-labs/orm-edgedb is a runtime-first bridge through the official Gel SQL client. It is meant for query execution on top of an existing Gel database, not for replacing the app's own Gel schema or migration workflow.
@farming-labs/orm-neo4j is a runtime-first graph backend through the official Neo4j driver and session shapes. It is a good fit for connected app data, auth/org/member graphs, and shared storage layers that still want one ORM surface, but it is not a Cypher-native graph query builder.
@farming-labs/orm-surrealdb is a runtime-first multi-model backend through the official SurrealDB client. It keeps one schema and one ORM surface, but the current runtime stores ORM-managed records and unique lookups and keeps relation loading conservative instead of claiming native graph or SQL join planning.
@farming-labs/orm-redis is for Redis and Upstash-compatible key-value workloads such as sessions, cache metadata, tokens, and rate limits. It is not the preferred fit for highly relational or join-heavy workloads.
@farming-labs/orm-supabase uses Supabase's own client API rather than a hidden raw pg bridge. It is query-first, keeps setup as a no-op, and is a good fit when the app already owns a createClient(...) instance. Keep the normal @farming-labs/orm-sql path when the app already owns a raw PostgreSQL client connected to Supabase.
@farming-labs/orm-xata uses the official Xata client through its SQL surface. It preserves the shared setup path and Postgres-style numeric ID and namespace behavior, but it keeps transaction semantics conservative instead of claiming full long-lived rollback behavior. Use pnpm test:xata:real for opt-in live-project verification when credentials are available.
@farming-labs/orm-unstorage is meant for lightweight key-value/document storage and shared storage layers, not for highly relational or join-heavy workloads.