Skip to content

opensite-ai/opensite-skills / aws-billing-and-cost-management

aws-billing-and-cost-management

Verified

Analyze 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.

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
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: 472kUpdated Claude CodeCodexVerifiedInstall
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: 472kUpdated Claude CodeCodexVerifiedInstall
rea-tool-designmorluto/reaAudit, investigate, design, or change REA investigation tools, CLI/MCP contracts, provider capabilities, and Evidence semantics.Stars: 472kUpdated Claude CodeCodexVerifiedInstall
ponytail-auditDietrichGebert/ponytailQuality audit of the whole repo: bugs, security, real load, missing tests, speed, and what to delete. Most important first.Stars: 194kUpdated Claude CodeCodexVerifiedInstall