Help us improve
Share bugs, ideas, or general feedback.
From role-database
Configures connection pools like PgBouncer, pgcat, ProxySQL for PostgreSQL/MySQL, app-level pools (Prisma, SQLAlchemy, HikariCP), serverless proxies (RDS Proxy, Neon). Optimizes sizing, detects leaks.
npx claudepluginhub rnavarych/alpha-engineer --plugin role-databaseHow this skill is triggered — by the user, by Claude, or both
Slash command
/role-database:connection-managementThis skill is limited to the following tools:
The summary Claude sees in its skill listing — used to decide when to auto-load this skill
- PostgreSQL: ~10 MB per connection (per-process model)
Optimizes database connection pooling for PostgreSQL and MySQL with sizing formulas, PgBouncer transaction-mode, serverless management, monitoring, and leak detection. Use for exhaustion errors, high latency, or idle connection buildup.
Audits connections, calculates pool sizes, configures app-level pooling params, and deploys PgBouncer/ProxySQL for PostgreSQL/MySQL to prevent exhaustion and boost throughput.
Pool sizing, connection lifetime, health checks, and resource exhaustion prevention.
Share bugs, ideas, or general feedback.
Load from references/ based on what's needed:
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.
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.