configuring-connection-pools
CommunityTune database connections for scalable apps.
Authordjankies
Version1.0.0
Installs0
System Documentation
What problem does it solve?
Serverless and high-concurrency environments can exhaust database connections if pool sizing is not configured properly. This Skill covers sizing strategies and best practices for Prisma Client pools.
Core Features & Use Cases
- Standard pool sizing: connection_limit ≈ (CPU cores × 2) + 1.
- Serverless per-instance pattern: limit = 1 to prevent cross-instance exhaustion.
- PgBouncer guidance for high concurrency and transaction-mode pooling.
- Production readiness: pool_timeout, connect_timeout, and monitoring.
Quick Start
Update DATABASE_URL with an appropriate connection_limit and pool_timeout; consider PgBouncer for scaling beyond per-instance limits.
Dependency Matrix
Required Modules
None requiredComponents
references
💻 Claude Code Installation
Recommended: Let Claude install automatically. Simply copy and paste the text below to Claude Code.
Please help me install this Skill: Name: configuring-connection-pools Download link: https://github.com/djankies/claude-configs/archive/main.zip#configuring-connection-pools Please download this .zip file, extract it, and install it in the .claude/skills/ directory.