AWS Price CSV Generator for Openclaw

A powerful tool for generating itemized AWS pricing CSVs from service lists using real-time API or cached bulk data.

crazylion
v1.0.0
Mar 5, 2026
0
1.1k
0

Install & Download

1. ClawHub CLI

The fastest way to install a skill directly from the registry.

npx clawhub@latest install aws-price-csv

2. Manual Installation

Copy the skill folder to one of these locations

Global
~/.openclaw/skills/
Workspace
<project>/skills/

Priority: Workspace > Local > Bundled

3. Prompt Installation

Copy this prompt to OpenClaw to install it automatically.

Help me install aws-price-csv using Clawhub. If Clawhub is not installed, install it first (npm i -g clawhub).

Prefer to download?

Get the raw skill files in a ZIP archive.

What is AWS Price CSV Generator?

The AWS Price CSV skill is a specialized utility designed to bridge the gap between architectural planning and financial forecasting. By leveraging Openclaw Skills, this tool processes structured service lists—containing EC2 instances, S3 storage, or EBS volumes—and produces a detailed cost breakdown in CSV format. It is particularly useful for teams that need to generate quotes or budget estimates without manually navigating the AWS Pricing Calculator.

This skill provides the flexibility to source data directly from the AWS Price List API for real-time accuracy or via cached bulk JSON files for high-speed, offline processing. By integrating this into your workflow, you can ensure that every proposed infrastructure change is accompanied by a transparent and accurate cost analysis, all managed through the extensible framework of Openclaw Skills.

AWS Price CSV Generator Use Cases

  • Creating professional cost estimates for client proposals or internal stakeholders.
  • Auditing infrastructure costs by comparing On-Demand rates against Reserved Instance savings.
  • Generating pricing reports in restricted environments where live IAM access is limited by using bulk mode.
  • Automating the conversion of technical YAML resource lists into financial CSV summaries.

How AWS Price CSV Generator Works

  1. The user prepares an input file in YAML or JSON format defining the AWS services, regions, and usage quantities.
  2. The skill parses the input and determines the appropriate data source: either the live AWS Price List API or local bulk JSON files.
  3. It applies specific filters—such as instanceType, operatingSystem, and termType—to identify the exact price point for each line item.
  4. The engine calculates the total cost by multiplying the quantity by the price per unit, accounting for different usage units like hours or GB-Mo.
  5. It compiles the data into a CSV file with detailed columns and a final total row for immediate delivery.

AWS Price CSV Generator Setup

To get started with this skill, ensure you have the AWS CLI and PyYAML installed. For API-based lookups, your environment must be authenticated with AWS.

# Install required Python dependencies
pip install pyyaml

# Run the pricing generator using bulk data for speed
python3 scripts/generate_pricing_csv.py \
  --input inputs/sample.yml \
  --region us-east-1 \
  --source bulk \
  --output aws_estimate.csv

AWS Price CSV Generator Data Schema & Taxonomy

The skill organizes pricing data into a structured CSV format. The following table describes the primary columns generated:

Column Description
item_name User-defined label for the resource.
service_code The official AWS service identifier (e.g., AmazonEC2).
term_type Pricing model used: On-Demand or Reserved.
price_per_unit_usd The base rate retrieved from the AWS Pricing data.
cost_usd The total calculated cost (Quantity x Price).
TOTAL A summary row at the end of the file aggregating all costs.

AWS Price CSV Generator Advanced Features

  • Dual Sourcing Logic: Seamlessly switch between the AWS Pricing API and local bulk JSON caches to balance speed and data freshness.
  • Automated Cache Management: Includes built-in logic to refresh cached pricing data every 30 days, ensuring Openclaw Skills remain accurate over time.
  • Support for Reserved Terms: Fine-tune estimates by specifying LeaseContractLength, PurchaseOption, and OfferingClass for Reserved Instances.
  • Custom Bulk File Overrides: Manually provide specific service JSON files to bypass the standard cache for bespoke pricing analysis.

SKILL.md


Loading

Related Openclaw Skills

METADATA

Github Stars: 0
forks: 0

Featured*