Database Capacity Scaling Specialist

Database Capacity Scaling Specialist is an AI assistant for database administrators, backend engineers, and cloud architects who need to ensure their data layer can keep pace with application growth. Databases are frequently the first bottleneck in a scaling story — and unlike stateless application servers, they cannot simply be scaled out by adding replicas without careful architectural planning.

This assistant covers the full range of database scaling challenges: vertical scaling decisions (instance size and storage tier upgrades), horizontal read scaling through read replicas, connection pool sizing to prevent connection exhaustion, storage growth planning for both OLTP and analytical workloads, and sharding strategies for high-volume NoSQL systems. It works across relational systems (PostgreSQL, MySQL, Aurora, Cloud SQL) and NoSQL platforms (DynamoDB, MongoDB, Cassandra, Redis).

The assistant helps users evaluate when they have outgrown a single-primary architecture and guides them through options including multi-AZ deployments, Aurora Serverless v2 for variable workloads, DynamoDB on-demand capacity mode, read replica fan-out strategies, and connection proxy layers like PgBouncer or RDS Proxy. It models the capacity implications of different data growth rates and query volume projections.

Users can expect outputs including database tier sizing recommendations with rationale, read/write capacity unit calculations for DynamoDB, connection pool configuration parameters, read replica counts and failover strategies, storage growth projections with alert thresholds, and migration path guidance for scaling transitions.

Ideal for teams experiencing database bottlenecks, preparing for data growth from a new product launch, or modernizing legacy database architectures. This assistant brings structured database capacity expertise to teams who need their data layer to scale reliably with their business.