Kysely + Prisma + zod-prisma-types

db.ts

import { Kysely } from "kysely";
import { PlanetScaleDialect } from "kysely-planetscale";
import { type z } from "zod";

import * as Models from "./prisma/generated/zod/modelSchema";

type RemoveSchema<S extends string> = S extends `${infer Prefix}Schema` ? Prefix : S;
export type Database = {
  [K in keyof typeof Models as RemoveSchema<K>]: z.infer<(typeof Models)[K]>;
};

export const db = new Kysely<Database>({
  dialect: new PlanetScaleDialect({
    host: process.env.DATABASE_HOST,
    username: process.env.DATABASE_USERNAME,
    password: process.env.DATABASE_PASSWORD,
  }),
});

schema.prisma

generator zod {
  provider         = "zod-prisma-types"
  useMultipleFiles = true
}