# Rnavarych Alpha Engineer Role Databaseconnection Management > Connection Management - Skill: `tomevault-io/rnavarych-alpha-engineer-role-databaseconnection-management` (Agent Skill, multi-file: 2 files) - Install (CLI): `npx skillmds@latest add tomevault-io/rnavarych-alpha-engineer-role-databaseconnection-management` - Raw SKILL.md: https://api.skillmd.com/api/skills/tomevault-io/rnavarych-alpha-engineer-role-databaseconnection-management/raw - Safety review: pending (external: skill-scanner PASS, skillspector PASS) - Works with: Claude Code, Claude.ai, OpenAI Codex - Category: Coding & Dev Tools - Author: tomevault-io (https://skillmd.com/u/tomevault-io) - Updated: 2026-09-17 - Page: https://skillmd.com/skills/tomevault-io/rnavarych-alpha-engineer-role-databaseconnection-management --- # Connection Management ## Why Connection Pooling - PostgreSQL: ~10 MB per connection (per-process model) - MySQL: ~1-4 MB per connection (per-thread model) - Without pooling: N app instances × M connections = N×M database connections - Pool reuses ~20 persistent connections to serve 100 simultaneous requests ## Reference Files Load from `references/` based on what's needed: ### references/pgbouncer-proxysql.md PgBouncer pool modes (transaction/session/statement), full pgbouncer.ini config, admin console monitoring commands. pgcat Rust-based alternative with read/write routing config. AWS RDS Proxy overview. ProxySQL MySQL read/write splitting with hostgroups and query routing rules. Serverless strategy comparison table (Prisma Accelerate, RDS Proxy, Neon, Supabase, Hyperdrive). Load when: configuring PgBouncer, pgcat, ProxySQL, or serverless connection proxies. ### references/app-pooling-sizing.md Application pool configuration: node-postgres, Prisma, SQLAlchemy, HikariCP (Java), database/sql (Go). Pool sizing formula: (core_count * 2) + spindle_count with worked examples. Connection leak detection queries for PostgreSQL and MySQL. Leak prevention checklist. Load when: configuring pools inside application code or diagnosing connection leaks. --- > Source: [rnavarych/alpha-engineer](https://github.com/rnavarych/alpha-engineer) — distributed by [TomeVault](https://tomevault.io).