Help us improve
Share bugs, ideas, or general feedback.
From role-database
Plans database capacity and growth: storage/IOPS estimation, memory sizing (PostgreSQL shared_buffers/MySQL innodb_buffer_pool/MongoDB/Redis), connections, sharding/read replicas, cloud costs. Guides pgbench/sysbench load testing.
npx claudepluginhub rnavarych/alpha-engineer --plugin role-databaseHow this skill is triggered — by the user, by Claude, or both
Slash command
/role-database:capacity-planningThis skill is limited to the following tools:
The summary Claude sees in its skill listing — used to decide when to auto-load this skill
Load from `references/` based on what's needed:
Analyzes CPU, memory, storage, network utilization; forecasts growth trends; recommends scaling strategies with cost estimates. Useful for infrastructure capacity planning and bottleneck identification.
Produces a structured capacity planning document for a service covering traffic forecasts, resource requirements, scaling strategy, and cost projections.
Forecast infrastructure resource needs (compute, storage, network). Model growth scenarios and utilization targets. Use when planning infrastructure investments or optimizing costs.
Share bugs, ideas, or general feedback.
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.