cost-optimization-analyzer_skill

Overview

This skill analyzes cloud, API, database, and development costs to produce actionable optimization recommendations and ROI estimates. It aggregates resource usage, query performance, API spend, and development velocity to reveal waste and prioritize savings. The output focuses on concrete opportunities, estimated savings, and automation ROI to maximize infrastructure and team efficiency.

How this skill works

It inspects infrastructure metrics (CPU, memory, storage, scaling), tracks API usage and cost by service, and profiles database queries for execution time and frequency. It analyzes git commit patterns to estimate development velocity and calculates automation ROI for repetitive tasks. The skill synthesizes findings into prioritized recommendations, cost breakdowns, and potential savings with estimated dollar impacts.

When to use it

• You need a holistic audit of cloud and API spending to reduce monthly bills.
• You suspect inefficient or costly database queries causing high resource consumption.
• You want to evaluate developer time costs and the ROI of automating tasks.
• You are preparing a cost-reduction plan before scaling or fundraising.
• You need ongoing monitoring and alerts for API budget thresholds.

Best practices

• Collect baseline metrics for at least 30 days to identify meaningful patterns.
• Prioritize fixes by potential savings and implementation effort (quick wins first).
• Combine caching, rate-limiting, and batching to reduce external API calls.
• Use autoscaling and right-sizing guided by real traffic patterns, not peak estimates.
• Measure post-change impact to validate savings and adjust recommendations.

Example use cases

• Identify a high-frequency, slow SQL query and recommend indexing or caching to save CPU and database costs.
• Detect a third-party API consuming >30% of monthly API spend and propose response caching and rate limits.
• Analyze developer commit history to estimate monthly development cost and recommend automation with ROI and payback months.
• Generate a dashboard with infrastructure, API, and development cost breakdowns for monthly finance reviews.
• Alert when API spend reaches 80% of budget and suggest immediate throttling or fallback strategies.