Agent skill

Cost Optimizer (Cloud Data Platforms)

Analyzes and optimizes costs for cloud data platforms

Stars 514
Forks 31

Install this agent skill to your Project

npx add-skill https://github.com/a5c-ai/babysitter/tree/main/library/specializations/data-engineering-analytics/skills/cost-optimizer

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

Expand your agent's capabilities with these related and highly-rated skills.

a5c-ai/babysitter

gsd-tools

Central utility skill for GSD operations. Provides config parsing, slug generation, timestamps, path operations, and orchestrates calls to other specialized skills. Acts as the unified entry point that the original gsd-tools.cjs provided via its lib/ modules (commands, config, core, init).

514 31
Explore
a5c-ai/babysitter

model-profile-resolution

Resolve model profile (quality/balanced/budget) at orchestration start and map agents to specific models. Enables cost/quality tradeoffs by selecting appropriate AI models for each agent role.

514 31
Explore
a5c-ai/babysitter

verification-suite

Plan structure validation, phase completeness checks, reference integrity verification, and artifact existence confirmation. Provides the structured verification layer ensuring GSD artifacts are well-formed and complete.

514 31
Explore
a5c-ai/babysitter

state-management

STATE.md reading, writing, and field-level updates. Provides cross-session state persistence via .planning/STATE.md with structured fields for current task, completed phases, blockers, decisions, and quick tasks.

514 31
Explore
a5c-ai/babysitter

git-integration

Git commit patterns, formats, and conventions for GSD methodology. Provides atomic commits per task, structured commit messages, planning file commits, branch management, and milestone tag operations.

514 31
Explore
a5c-ai/babysitter

frontmatter-parsing

YAML frontmatter parsing and manipulation for .planning/ documents. Provides read, write, update, query, and validation operations on frontmatter blocks in GSD markdown artifacts.

514 31
Explore

Didn't find tool you were looking for?

Be as detailed as possible for better results