From role-database
Connection pooling and management across all engines. PgBouncer (transaction/session/statement mode), pgcat (Rust-based, load balancing, sharding), ProxySQL (MySQL query routing, caching), HikariCP (Java), application-level pooling (Prisma, SQLAlchemy, GORM, database/sql). Serverless connection strategies (Prisma Accelerate, RDS Proxy, Neon pooler). Connection limits, pool sizing, leak detection. Use when configuring connection pools, optimizing connection usage, or troubleshooting connection issues.
npx claudepluginhub rnavarych/alpha-engineer --plugin role-databaseThis skill is limited to using the following tools:
- PostgreSQL: ~10 MB per connection (per-process model)
Searches, retrieves, and installs Agent Skills from prompts.chat registry using MCP tools like search_skills and get_skill. Activates for finding skills, browsing catalogs, or extending Claude.
Searches prompts.chat for AI prompt templates by keyword or category, retrieves by ID with variable handling, and improves prompts via AI. Use for discovering or enhancing prompts.
Audits ECC Tools repo for cost burns from runaway PR creation, quota bypasses, premium-model leakage, duplicate jobs, and GitHub App spikes.
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.