From role-database
Database capacity and growth planning. Storage growth estimation, IOPS requirements, memory sizing (buffer pool, shared_buffers), connection count estimation, sharding triggers, read replica scaling, cost estimation per cloud provider. Load testing (pgbench, sysbench, YCSB, HammerDB). When to shard vs scale up vs read replicas. Use when planning database capacity, sizing infrastructure, or evaluating scaling strategies.
npx claudepluginhub rnavarych/alpha-engineer --plugin role-databaseThis skill is limited to using the following tools:
Load from `references/` based on what's needed:
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.
Designs, implements, and audits WCAG 2.2 AA accessible UIs for Web (ARIA/HTML5), iOS (SwiftUI traits), and Android (Compose semantics). Audits code for compliance gaps.
Load from references/ based on what's needed:
Row size calculation queries (pg_column_size, bytes_per_row from pg_class). Storage growth projection formula with worked example. Memory sizing rules: PostgreSQL (shared_buffers, work_mem formula), MySQL (innodb_buffer_pool), MongoDB (WiredTiger cache), Redis (maxmemory). IOPS estimation by workload type. AWS RDS IOPS reference table. Scaling decision framework: when to scale up vs read replicas vs shard. Decision matrix. Load when: sizing infrastructure, estimating growth, or choosing a scaling strategy.
Load testing tool comparison (pgbench, sysbench, YCSB, HammerDB, cassandra-stress). pgbench and sysbench command examples with key output metrics. Cloud cost estimation examples for RDS PostgreSQL Multi-AZ and DynamoDB On-Demand. Capacity planning checklist (8 steps). Load when: benchmarking database capacity or estimating cloud infrastructure costs.