indchess-db-schema

Shared Prisma schema and migration bundle for ind-chess services. Each service installs this package, applies the packaged migrations, and generates its own Prisma Client that targets the shared database schema.

Install

npm install indchess-db-schema prisma @prisma/client
# or
pnpm add indchess-db-schema prisma @prisma/client

prisma and @prisma/client are peer dependencies so everyone uses the same CLI and client version when applying migrations.

Apply migrations

Run the Prisma CLI against the config and schema shipped in this package. Ensure the service has the correct DATABASE_URL in its environment.

npx prisma migrate deploy --config node_modules/indchess-db-schema/prisma.config.ts

This command reads prisma/schema.prisma and prisma/migrations/ from the package and applies the canonical migration history.

Generate a local client

Each service generates its own Prisma Client so the query engine binaries match the deploy environment.

npx prisma generate --schema node_modules/indchess-db-schema/prisma/schema.prisma

The default generator output is node_modules/@prisma/client, so you can import the client normally:

import { PrismaClient } from "@prisma/client";

export const prisma = new PrismaClient();

If you prefer to place the generated client elsewhere, set PRISMA_CLIENT_OUTPUT before running prisma generate. Add the deploy/generate commands to your service scripts or CI pipelines so every environment stays aligned with the shared schema.

Contributing migrations

Create new migrations inside this repository only. Run npm run dev to create and preview schema changes, bump the package version, and publish. Downstream services should only consume published versions and must not create migrations locally.