opensite-ai/opensite-skills / aws-billing-and-cost-management
aws-billing-and-cost-management
VerifiedAnalyze AWS costs, find savings, manage budgets, evaluate Savings Plans and Reserved Instances, right-size EC2/Lambda/RDS/EBS with Compute Optimizer, look up service pricing, query CUR with Athena, detect cost anomalies, scope costs to billing views, and monitor Free Tier usage. Triggers on: AWS bill, cost analysis, reduce spend, savings plan, reserved instance, right-size, budget alert, cost optimization, pricing, free tier, cost anomaly, CUR, cost audit, billing view, billing view ARN.
| File | Kind | Size |
|---|---|---|
| .aws-skill-metadata | other | 18 B |
| SKILL.md | skill md | 8.9 KB |
| references/budgets.md | markdown | 2.4 KB |
| references/cost-audit.md | markdown | 3.2 KB |
| references/cost-explorer.md | markdown | 7.3 KB |
| references/cost-optimization-hub.md | markdown | 7.2 KB |
| references/cur-athena.md | markdown | 7.0 KB |
| references/deterministic-calculations.md | markdown | 2.5 KB |
| references/ebs-optimization.md | markdown | 2.7 KB |
| references/ec2-rightsizing.md | markdown | 3.3 KB |
| references/free-tier.md | markdown | 1.6 KB |
| references/lambda-optimization.md | markdown | 2.2 KB |
| references/pricing-lookup.md | markdown | 3.8 KB |
| references/rds-optimization.md | markdown | 1.8 KB |
| references/reserved-instances.md | markdown | 2.3 KB |
| references/savings-plans.md | markdown | 3.3 KB |
| references/service-optimization.md | markdown | 3.0 KB |
references/rds-optimization.md
View on GitHub# RDS Optimization
## Compute Optimizer for RDS
Supported engines: MySQL, PostgreSQL, Aurora MySQL, Aurora PostgreSQL.
**Metrics analyzed:** CPUUtilization, DatabaseConnections, NetworkReceive/TransmitThroughput, ReadIOPS/WriteIOPS, ReadThroughput/WriteThroughput, EBSIOBalance%/EBSByteBalance%, FreeStorageSpace. With Performance Insights: DBLoad, os.swap.in/out.
**Finding classifications:** `Overprovisioned`, `Underprovisioned`, `Optimized`.
**Finding reason codes:** CPUOverprovisioned, CPUUnderprovisioned, MemoryUnderprovisioned (high swap/OOM), NetworkBandwidthOver/Under, EBSThroughput/IOPSOver/Under, NewGenerationAvailable, NewEngineVersionAvailable.
**Storage findings:** EBSVolumeAllocatedStorageUnderprovisioned, EBSVolumeIOPS/ThroughputOver/Under, NewGenerationStorageTypeAvailable.
```bash
aws compute-optimizer get-rds-db-instance-recommendations \
--filters Name=Finding,Values=Overprovisioned
```
## Multi-AZ Considerations
- Changes apply to both primary and standby instances
- Failover timing may be affected by instance changes
- Multi-AZ reduces downtime during modifications
## Read Replica Considerations
- Recommendations synchronized with writer for promotion tiers ≤1
- Smaller replica instances may increase replication lag
## Storage Considerations
- Storage can only be increased, not decreased
- Storage type changes may require specific instance types
- gp3 provides more flexible IOPS/throughput provisioning than gp2
## Gotchas
- DB instance modifications typically require brief downtime (5-10 min)
- Engine version upgrades require compatibility assessment
- Parameter group changes may be required after instance class change
- Always take a snapshot before implementing changes
- Performance risk scale: 0-1 Very Low, >1-2 Low, >2-3 Medium, >3-4 High
Related skills
| Skill | Stars | Updated | Works with | Status | Install |
|---|---|---|---|---|---|
| rea-analysis-optimizationmorluto/reaOptimize REA providers and shared analysis workflows for agent context, latency, CPU, and memory while preserving correctness and Evidence. Use for analysis bottlenecks and cache or query design; CI/test-suite optimization belongs to rea-ci-tests-audit. | Stars: 472k | Updated | Claude CodeCodex | Verified | Install |
| rea-ci-tests-auditmorluto/reaAudit REA CI and test suites for correctness, fixture drift, false passes, and measured performance; use for suite or workflow investigations and efficiency changes, rather than ordinary feature testing or a single test failure. | Stars: 472k | Updated | Claude CodeCodex | Verified | Install |
| rea-tool-designmorluto/reaAudit, investigate, design, or change REA investigation tools, CLI/MCP contracts, provider capabilities, and Evidence semantics. | Stars: 472k | Updated | Claude CodeCodex | Verified | Install |
| ponytail-auditDietrichGebert/ponytailQuality audit of the whole repo: bugs, security, real load, missing tests, speed, and what to delete. Most important first. | Stars: 194k | Updated | Claude CodeCodex | Verified | Install |