Contracts · Query API · Runnable example
:::caution Requires Prisma ORM 8.0.0-rc and PostgreSQL 17+. Pin the ORM and CLI versions used by your Alchemy release. :::
Install the dependencies
bun add alchemy @alchemy.run/cloudflare @alchemy.run/neon @alchemy.run/prisma effect @prisma/orm-postgres arktype
bun add -d prisma Cloudflare setup · Neon setup · Define a contract
Configure validation for Workers
// src/prisma/validation.ts
import { configure } from "arktype/config";
configure({ jitless: true }); Import the bootstrap before the contract builder:
import "./validation.ts";
import { defineContract } from "@alchemy.run/prisma/ORM"; If your package uses "sideEffects": false, preserve this module:
{ "sideEffects": ["./src/prisma/validation.ts"] } PSL-first projects skip this step.
Provision the database and migrations
// src/db.ts
import * as Neon from "@alchemy.run/neon";
import * as Prisma from "@alchemy.run/prisma";
import * as Effect from "effect/Effect";
export const Db = Effect.gen(function* () {
const contract = yield* Prisma.Contract("contract");
const project = yield* Neon.Project("app-db");
const branch = yield* Neon.Branch("app-branch", { project });
yield* Prisma.Migrate("migrate", {
url: branch.connectionUri,
contract,
});
return branch;
}); Add Hyperdrive
// src/db.ts
import * as Cloudflare from "@alchemy.run/cloudflare";
export const Hyperdrive = Effect.gen(function* () {
const branch = yield* Db;
return yield* Cloudflare.Hyperdrive.Connection("app-hyperdrive", {
origin: branch.origin,
caching: { disabled: true },
});
}); Caching is disabled so reads immediately reflect writes. Hyperdrive guide.
Connect in a Worker
// src/api.ts
import * as Cloudflare from "@alchemy.run/cloudflare";
import * as PrismaPostgres from "@alchemy.run/prisma/ORM/Postgres";
import * as Effect from "effect/Effect";
import * as HttpServerResponse from "effect/http/HttpServerResponse";
import { contract } from "./prisma/contract.ts";
import { Hyperdrive } from "./db.ts";
export default class Api extends Cloudflare.Worker<Api>()(
"Api",
{ main: import.meta.url },
Effect.gen(function* () {
const conn = yield* Cloudflare.Hyperdrive.Connect(Hyperdrive);
const db = yield* PrismaPostgres.Postgres(conn.connectionString, { contract });
return {
fetch: Effect.gen(function* () {
const users = yield* db.orm.public.User.all();
return yield* HttpServerResponse.json({ users });
}),
};
}).pipe(Effect.provide(Cloudflare.Hyperdrive.ConnectBinding)),
) {} Use a PSL contract
import { makeDatabase } from "./prisma/generated/client.ts";
const conn = yield* Cloudflare.Hyperdrive.Connect(Hyperdrive);
const db = yield* makeDatabase(conn.connectionString); Generate the PSL client before compiling. The handler and binding layer stay the same.
Wire the stack
// alchemy.run.ts
import * as Alchemy from "alchemy";
import * as Cloudflare from "@alchemy.run/cloudflare";
import * as Neon from "@alchemy.run/neon";
import * as Prisma from "@alchemy.run/prisma";
import * as Effect from "effect/Effect";
import * as Layer from "effect/Layer";
import Api from "./src/api.ts";
export default Alchemy.Stack(
"PrismaWorker",
{
providers: Layer.mergeAll(
Cloudflare.providers(),
Neon.providers(),
Prisma.providers(),
),
state: Alchemy.localState(),
},
Effect.gen(function* () {
const api = yield* Api;
return { url: api.url };
}),
); Deploy and query
bun alchemy deploy
curl https://<your-worker>.workers.dev This demo route is public. Add authentication before exposing private data.
Clean up
bun alchemy destroy Destroy removes the example's Worker, Hyperdrive configuration, and Neon resources, including the database data.