The Complete Production SOP: How to Deploy and Run Prisma Accelerate Global Edge Caching & Connection Pool in Autonomous AI Agents

Autonomous runtimes parse directory-mounted markdown skills at initiation to resolve trigger phrases. For Codex Desktop and Claude Code, mount the skill under your user or project agent rules directory. For Cursor and Windsurf, link it within the workspace `.cursor/rules` or `.windsurfrules` hierarchy so the agent recognizes triggers like 'setup prisma accelerate' or 'serverless connection pool prisma'.

---
name: "prisma-accelerate-connection-pool"
description: "Scale serverless database connections and cache queries globally using Prisma Accelerate."
metadata:
  author: "Prisma"
  version: "1.0.0"
  runtime_compatibility:
    - "codex"
    - "claude-code"
    - "cursor"
    - "windsurf"
triggers:
  - "setup prisma accelerate"
  - "cache query with prisma accelerate"
  - "serverless connection pool prisma"
permissions:
  fs_read: true
  fs_write: "workspace"
  shell_exec: false
  net_access: false
---

Prisma Accelerate requires substituting the direct PostgreSQL/MySQL URL with the managed proxy protocol `prisma://accelerate.prisma-data.net/?api_key=...`. Instruct the agent to check `.env` templates without printing plain-text secrets to stdout, then install `@prisma/extension-accelerate`.

The skill instructs the agent to create a centralized, singleton-safe Prisma Client instance extended with `withAccelerate()`. It directs the agent to apply granular caching headers (`ttl` for absolute cache freshness and `swr` for stale-while-revalidate background regeneration) on high-frequency read queries.

import { PrismaClient } from '@prisma/client';
import { withAccelerate } from '@prisma/extension-accelerate';

const globalForPrisma = globalThis as unknown as {
  prisma: ReturnType<typeof makeClient> | undefined;
};

function makeClient() {
  return new PrismaClient().$extends(withAccelerate());
}

export const prisma = globalForPrisma.prisma ?? makeClient();

if (process.env.NODE_ENV !== 'production') {
  globalForPrisma.prisma = prisma;
}

export type ExtendedPrismaClient = typeof prisma;

Before reporting task completion, the agent runs workspace-scoped type checking and tests to ensure the extended client preserves full Prisma type inference and respects Accelerate query argument contracts.