blader/claudeception/prisma-connection-pool-exhaustion
Claude Code and agent skill by blader/claudeception
- community
Checking that the SKILL.md file is still in the repository.
Fix Prisma "Too many connections" and connection pool exhaustion errors in serverless environments (Vercel, AWS Lambda, Netlify). Use when: (1) Error "P2024: Timed out fetching a new connection from the pool", (2) PostgreSQL "too many connections for role", (3) Database works locally but fails in production serverless, (4) Intermittent database timeouts under load.
Install
npx vskill@latest install blader/claudeception/prisma-connection-pool-exhaustionSKILL.md
Prisma Connection Pool Exhaustion in Serverless
Problem
Serverless functions create a new Prisma client instance on each cold start. Each instance opens multiple database connections (default: 5 per instance). With many concurrent requests, this quickly exhausts the database's connection limit (often 20-100 for managed databases).
Context / Trigger Conditions
This skill applies when you see:
P2024: Timed out fetching a new connection from the connection pool- PostgreSQL:
FATAL: too many connections for role "username" - MySQL:
Too many connections - Works fine locally with
npm run devbut fails in production - Errors appear during traffic spikes, then resolve
- Database dashboard shows connections at or near limit
Environment indicators:
- Deploying to Vercel, AWS Lambda, Netlify Functions, or similar
- Using Prisma with PostgreSQL, MySQL, or another connection-based database
- Database is managed (PlanetScale, Supabase, Neon, RDS, etc.)
Solution
Step 1: Use Connection Pooling Service
The recommended solution is to use a connection pooler like PgBouncer or Prisma Accelerate, which sits between your serverless functions and the database.
For Supabase:
For Neon:
For Prisma Accelerate:
Step 2: Configure Prisma Connection Limits
In your schema.prisma:
In your connection URL or Prisma client:
Step 3: Singleton Pattern (Development)
Prevent hot-reload from creating new clients:
Step 4: URL Parameters
Add these to your connection string:
connection_limit=1: One connection per serverless instancepool_timeout=20: Wait up to 20s for available connectionconnect_timeout=10: Fail fast if can't connect in 10s
Verification
After applying fixes:
- Deploy to production
- Run a load test:
npx autocannon -c 100 -d 30 https://your-app.com/api/test - Check database dashboard—connections should stay within limits
- No more P2024 errors in logs
Example
Before (error under load):
After (with connection pooling):
Database connections stable at 10-15 even under heavy load.
Notes
- Different managed databases have different pooling solutions—check your provider's docs
- PlanetScale (MySQL) uses a different architecture and doesn't have this issue
connection_limit=1is aggressive; start there and increase if you see latency- The singleton pattern only helps in development; in production serverless, each
instance is isolated
- If using Prisma with Next.js API routes, each route invocation may be a separate
serverless function
- Consider Prisma Accelerate for built-in caching + pooling: https://www.prisma.io/accelerate
Security
- Security scanPassed, 95 of 100Pattern checks on the skill's files.
- Model reviewPassed
Quality evaluation
- Task evaluationNot runNo evaluation yet. Run one in Skill Studio.
Source
- SKILL.md in the repositoryCheckingexamples/prisma-connection-pool-exhaustion/SKILL.md
Popularity
- 7-day trend score
- 0
Refreshed 19 Mar 2026, 8 months ago.
Works with
Any agent vskill installs to: 56 targets in all. These 39 have a page on this site.
- Claude Code
- Cursor
- GitHub Copilot
- Windsurf
- Codex
- Gemini CLI
- Cline
- Amp
- Roo Code
- Goose
- Continue
- Kilo Code
- Junie
- Trae
- OpenHands
- Qwen Code
- AI Agent
- Tabnine Chat
- Sourcegraph Cody
- Amazon Q
- Firebase Genkit
- Sweep
- Devin
- Phind
- Mentat
- Claude Desktop
- Aider
- GPT Pilot
- Plandex
- bolt.new
- v0
- Replit Agent
- Anse
- TypingMind
- BetterChatGPT
- LibreChat
- Warp AI
- Pieces
- Fig AI
Embed badge
[](https://verified-skill.com/skills/blader/claudeception/prisma-connection-pool-exhaustion)