P
Prisma•2mo ago
Pong

Prisma ORM in cloudflare Worker (hono)

Is it possible to use Prisma in a Cloudflare Worker? I use Hono there, and I wanted to use Prisma for typing. I was told to use "driverAdapters," but that's outdated. Any tutorials on the best way? No client issues?
2 Replies
Prisma AI Help
Prisma AI Help•2mo ago
You've gone full bot mode! Let me fetch that AI answer for you ASAP. Yes, it is possible to use Prisma ORM in a Cloudflare Worker, including with Hono, but there are important requirements and limitations. Key points: - You must use Prisma’s driver adapters (not the traditional Rust query engine) because Cloudflare Workers do not support Node.js binaries. This is not outdated—driver adapters are the current, supported way to use Prisma in edge/serverless environments like Cloudflare Workers. Prisma Accelerate is another option for broader database support, but for most use cases, driver adapters are recommended and actively maintained [Deploy to Cloudflare Workers & Pages]. - Supported databases include Cloudflare D1, PlanetScale, Neon, and Turso (libSQL). For PostgreSQL, you can use Prisma Accelerate or an edge-compatible driver [General considerations when deploying to Cloudflare Workers]. - Example for Cloudflare D1: 
    import { PrismaClient } from './generated/prisma/client';
    import { PrismaD1 } from '@prisma/adapter-d1';

    export interface Env { DB: D1Database; }

    export default {
      async fetch(request: Request, env: Env, ctx: ExecutionContext): Promise<Response> {
        const adapter = new PrismaD1(env.DB);
        const prisma = new PrismaClient({ adapter });
        const users = await prisma.user.findMany();
        return new Response(JSON.stringify(users));
      },
    };
    
    import { PrismaClient } from './generated/prisma/client';
    import { PrismaD1 } from '@prisma/adapter-d1';

    export interface Env { DB: D1Database; }

    export default {
      async fetch(request: Request, env: Env, ctx: ExecutionContext): Promise<Response> {
        const adapter = new PrismaD1(env.DB);
        const prisma = new PrismaClient({ adapter });
        const users = await prisma.user.findMany();
        return new Response(JSON.stringify(users));
      },
    };
[Implement the Worker] - Bundle size warning: Prisma Client can be large and may exceed Cloudflare’s 1MB script limit for free accounts. Consider this if your Worker is complex [Deploy failed in the cloudflare dashboard]. - No global Prisma instance: Do not cache the Prisma Client globally in Workers, as each request is isolated and sharing can cause errors [The right way to use Prisma with Cloudflare Workers]. Tutorial: The official Prisma + Cloudflare D1 guide is the best starting point. Summary: Use driver adapters, follow the official guide, and be mindful of script size and request isolation. This is the current, supported approach.
Nurul
Nurul•2mo ago
Was the bot response helpful?

Did you find this page helpful?