How to set globally the prisma client?

[igmtdev]

Can someone help me to set up the prisma client globally, so I can call anywhere on my routes, like this c.get("prisma").user.findMany()

[mapokapo]

I personally just have a providers/ directory in my project structure which contains global long-lived objects like the database connection. You could have a file called prisma.ts with the following contents:

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

/**
 * The Prisma client instance.
 */
export const prismaClient = new PrismaClient();

Then simply import prismaClient in any file that needs it.