Connect to Prisma Postgres from Cloudflare Workers

You can build applications on Cloudflare Workers that connect to Prisma Postgres with a few configuration steps! This project is a full sample based on Prisma's sample project.

Get this project running to connect from Cloudflare Workers to Prisma Postgres

1. Run npm install to install project dependencies.
2. Rename .dev.vars.example to .dev.vars and set your DATABASE_URL to the one provided in your Prisma Postgres instructions (this is required for local development using Cloudflare Workers Secrets).
3. Rename .env.example to .env and set your DATABASE_URL to the one provided in your Prisma Postgres instructions (this is required for the prisma CLI to be able to apply migrations).
4. Run npx prisma migrate dev --name init to create the tables in your Postgres database based on your schema.
5. Run npx prisma generate --no-engine to create a Prisma Client with the Accelerate extension.
6. Run npm run dev to run the project, and navigate to http://localhost:8787 to see the results.
7. Run npx wrangler secret put DATABASE_URL to set up your DATABASE_URL secret in Cloudflare.
8. Run npm run deploy to deploy the project.

Add Prisma Postgres to your own Cloudflare Worker project

1. Run npm install prisma @prisma/client@latest @prisma/extension-accelerate to install the Prisma edge client and the Prisma Accelerate extension.
2. Run npx prisma init to create your prisma/schema.prisma schema files, which define the schema of your database.
3. Create a .dev.vars and set a DATABASE_URL variable to the database URL provided in your Prisma Postgres instructions (this is required for local development using Cloudflare Workers Secrets).
4. Create a .env file and set a DATABASE_URL variable to the database URL provided in your Prisma Postgres instructions (this is required for the prisma CLI to be able to apply migrations).
5. Run npx prisma migrate dev --name init to create the tables in your Prisma Postgres database.
6. Run npx prisma generate --no-engine to create a Prisma Client with the Accelerate extension.
7. Configure your database URL with Cloudflare Workers and Prisma. You need to override the datasourceUrl in the PrismaClient instantiation with the database url provided by Cloudflare environment variables. https://www.prisma.io/docs/orm/reference/prisma-client-reference#programmatically-override-a-datasource-url. See the code in src/index.ts

   export default {
    async fetch(request, env, ctx): Promise<Response> {
      const connectionString = `${env.DATABASE_URL}`;
      console.log(connectionString);
   
      const prisma = new PrismaClient({
        datasources: {
          db: {
            url: env.DATABASE_URL,
          },
        },
      }).$extends(withAccelerate());
   
      ...
   
    }
   }
   

8. Run npm run dev to run the project, and navigate to http://localhost:8787 to see the results.
9. Run npx wrangler secret put DATABASE_URL to set up your DATABASE_URL secret in Cloudflare.
10. Run npm run deploy to deploy the project.

FAQ

• Is it possible to connect to Prisma Postgres using Cloudflare Hyperdrive? No, Prisma Postgres does not provide direct connection to the underlying Postgres database. It must be accessed through Prisma Accelerate which provides authentication, connection pooling and caching over HTTP.