Skip to content

a5c-ai/babysitter / library/specializations/data-engineering-analytics/skills/cost-optimizer

Cost Optimizer (Cloud Data Platforms)

Verified

Analyzes and optimizes costs for cloud data platforms

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

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

Output Schema

{
  "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
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: 196kUpdated Claude CodeCodexVerifiedInstall
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: 192kUpdated Claude CodeCodexVerifiedInstall
ponytail-debtDietrichGebert/ponytailHarvest every shortcut: comment into one debt ledger, so deferrals get tracked instead of forgotten. One-shot report.Stars: 192kUpdated Claude CodeCodexVerifiedInstall
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: 192kUpdated Claude CodeCodexVerifiedInstall