a5c-ai/babysitter / library/specializations/data-engineering-analytics/skills/cost-optimizer
Cost Optimizer (Cloud Data Platforms)
VerifiedAnalyzes and optimizes costs for cloud data platforms
SKILL.md
View on GitHub---
name: Cost Optimizer (Cloud Data Platforms)
description: Analyzes and optimizes costs for cloud data platforms
version: 1.0.0
category: Cost Management
skillId: SK-DEA-012
allowed-tools:
- Read
- Write
- Edit
- Glob
- Grep
- Bash
graph:
domains: [domain:data-engineering]
specializations: [specialization:data-engineering-analytics]
skillAreas: [skill-area:big-data-tools, skill-area:data-warehouse-modeling]
roles: [role:data-engineer, role:analytics-engineer]
workflows: [workflow:data-pipeline-deployment]
---
# 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
Related skills
| Skill | Stars | Updated | Works with | Status | Install |
|---|---|---|---|---|---|
| slack-gif-creatoranthropics/skillsKnowledge and utilities for creating animated GIFs optimized for Slack. Provides constraints, validation tools, and animation concepts. Use when users request animated GIFs for Slack like "make me a GIF of X doing Y for Slack." | Stars: 198k | Updated | Claude CodeCodex | Verified | Install |
| ponytailDietrichGebert/ponytailLazy senior dev mode for any coding task: the smallest change that fully solves it, and a reply a busy human understands in one read. | Stars: 194k | Updated | Claude CodeCodex | Verified | Install |
| ponytail-debtDietrichGebert/ponytailHarvest every shortcut: comment into one debt ledger, so deferrals get tracked instead of forgotten. One-shot report. | Stars: 194k | Updated | Claude CodeCodex | Verified | Install |
| ponytail-debtDietrichGebert/ponytailList every `shortcut:` comment (and older `ponytail:` ones) as a debt ledger. One-shot report, changes nothing. Use for "ponytail debt", "what did ponytail defer", "list the shortcuts", /ponytail-debt. | Stars: 194k | Updated | Claude CodeCodex | Verified | Install |