role-database:capacity-planning

What problem does it solve?

This Skill helps you plan and manage your database's capacity, preventing performance bottlenecks and unexpected costs by providing clear guidance on storage, memory, and scaling strategies.

Core Features & Use Cases

• Storage Growth Estimation: Predict future storage needs based on current data volume and growth rates.
• Memory Sizing: Determine optimal memory allocation for databases like PostgreSQL, MySQL, MongoDB, and Redis.
• Scaling Strategy: Advise on when to scale up, add read replicas, or implement sharding.
• Load Testing: Provide guidance on using tools like pgbench and sysbench for performance benchmarking.
• Cost Estimation: Help estimate cloud infrastructure costs for services like AWS RDS and DynamoDB.
• Use Case: You need to provision a new PostgreSQL database cluster and are unsure about the required instance size, storage, and read replica configuration. This Skill will guide you through the sizing and scaling decisions.

Quick Start

Use the capacity-planning skill to estimate the storage growth for a PostgreSQL database over the next year, assuming 100,000 new rows per day and an average row size of 200 bytes.