# Cost Optimizer (Cloud Data Platforms)

> Cost Optimizer (Cloud Data Platforms) is an Agent Skill for devops & security published in the a5c-ai/babysitter repository on GitHub: a SKILL.md instruction file an AI agent can load to do this task.

Analyzes and optimizes costs for cloud data platforms

- Skill name: `Cost Optimizer (Cloud Data Platforms)`
- Category: [DevOps & Security](https://www.openparable.com/skill/devops-security/1)
- Source: https://github.com/a5c-ai/babysitter/blob/HEAD/library/specializations/data-engineering-analytics/skills/cost-optimizer/SKILL.md
- Repository: a5c-ai/babysitter (1,548 GitHub stars when collected)

## SKILL.md

# Cost Optimizer (Cloud Data Platforms)

## Overview

Analyzes and optimizes costs for cloud data platforms. This skill provides deep expertise in platform-specific cost structures and optimization strategies.

## Capabilities

- Snowflake credit analysis and optimization
- BigQuery slot and on-demand optimization
- Redshift node sizing
- Storage cost optimization
- Query cost estimation
- Warehouse scheduling recommendations
- Data lifecycle policy recommendations
- Reserved capacity planning

## Input Schema

```json
{
  "platform": "snowflake|bigquery|redshift|databricks",
  "usageMetrics": "object",
  "billingData": "object",
  "queryHistory": "object"
}
```

## Output Schema

```json
{
  "currentCost": "number",
  "optimizedCost": "number",
  "savings": "percentage",
  "recommendations": [{
    "category": "string",
    "action": "string",
    "impact": "number",
    "effort": "low|medium|high"
  }]
}
```

## Target Processes

- Data Warehouse Setup
- Query Optimization
- Pipeline Migration

## Usage Guidelines

1. Provide platform-specific usage metrics
2. Include billing data for cost baseline
3. Share query history for optimization analysis
4. Prioritize recommendations by impact and effort

## Best Practices

- Regularly review and optimize warehouse sizes
- Implement auto-suspend and auto-resume policies
- Use clustering and partitioning to reduce scan costs
- Consider reserved capacity for predictable workloads
- Monitor and alert on cost anomalies

---

Source: https://www.openparable.com/skill/devops-security/cost-optimizer-cloud-data-platforms (OpenParable). Cite the canonical URL above.