Part 3: Query Tenant Notes

Each request reads the tenant from the URL and only touches that tenant’s database.

Install the driver

pnpm add drizzle-orm @effect/sql-libsql

Connect to the tenant’s database

import * as Drizzle from "alchemy/Drizzle/LibSQL";

if (resource === "notes") {
  const db = yield* Drizzle.LibSQL(tenants.connect(tenant));
}

tenants.connect(tenant) returns the database’s URL and a token. The connection opens on the first query and closes when the request ends.

List notes

case "GET": {
  const notes = yield* db.select().from(Notes);
  return yield* HttpServerResponse.json({ notes });
}

Add a note

case "POST": {
  const { body } = (yield* request.json) as { body: string };
  const [note] = yield* db.insert(Notes).values({ body }).returning();
  return yield* HttpServerResponse.json({ note });
}

Deploy

pnpm alchemy deploy

Alchemy prints the Worker’s url.

Create two tenants

curl -X POST $URL/tenants/acme
curl -X POST $URL/tenants/globex

Each call creates a database with the tenant’s name. Names must be unique in your Turso organization.

Write a note

curl -X POST $URL/tenants/acme/notes -d '{"body":"hello from acme"}'
curl $URL/tenants/acme/notes

acme sees its note. globex has its own database, still empty:

curl $URL/tenants/globex/notes

Clean up

pnpm alchemy destroy

This deletes the Tenants group and every tenant database in it.