skills.rest
jwmossmoz
jwmossmozCOMMUNITY
Explore all skills by this author →
GitHub

azure-cost-duckdb

Download Azure Cost Management exports and query them locally with DuckDB.

3|Updated Jan 8, 2026
Search Tags:#csv#parquet#duckdb#offline-analysis#blob-storage#cost-management#azure-cost
One-click install
npx skills add https://github.com/jwmossmoz/agent-skills --skill azure-cost-duckdb
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: azure-cost-duckdb
Source: https://github.com/jwmossmoz/agent-skills/tree/main/skills/azure-cost-duckdb
Command: npx skills add https://github.com/jwmossmoz/agent-skills --skill azure-cost-duckdb

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires duckdb>=1.3.0, and includes scripts (resource) and references (resource) components.

What problem does it solve?

Azure Cost Management exports can be downloaded and queried locally with DuckDB to analyze cloud spend without relying on live API calls or external dashboards.

Core Features & Use Cases

  • Download and query Azure Cost Management exports (Parquet/CSV) stored in Blob Storage using DuckDB.
  • Create local views azure_cost and azure_cost_files to analyze costs by file, service, and resource, with special handling for Azure tags to derive worker pools.
  • Use cases include monthly spend by service, per-resource cost breakdown, and ad-hoc cost exploration against a cached dataset.

Quick Start

Sync exports to your local cache and start querying with DuckDB for immediate offline analysis.

Frequently Asked Questions about azure-cost-duckdb

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I query Azure Cost Management exports locally for offline analysis?▼

To query Azure Cost Management exports locally, you download Parquet or CSV files from Blob Storage and load them into DuckDB to analyze cloud spend without hitting live APIs.

Do I need Azure CLI to download cost exports from Blob Storage?▼

Yes, you need the Azure CLI configured to authenticate and download your cost exports from Blob Storage before orchestrating the downloads and queries with the included Python script.

Can I analyze Azure resource costs by worker pool using DuckDB?▼

Yes, you can analyze Azure resource costs by worker pool because the script handles Azure tag columns and builds local DuckDB views like azure_cost to derive worker pool information.

What is the best way to analyze Azure cloud spend without relying on live API calls?▼

The best way to analyze Azure cloud spend offline is downloading exports to a local cache and querying them with DuckDB, which builds a local database to avoid live API dashboard dependencies.

Does this offline cost analysis approach support both Parquet and CSV exports?▼

Yes, offline cost analysis supports both Parquet and CSV file formats downloaded from Azure Blob Storage, loading them into a local DuckDB database to query costs by service or resource.

What limitations exist when querying cached Azure cost data locally?▼

The main limitation of querying cached Azure cost data locally is that data is only as fresh as your latest export, requiring a configured data root, config toml, and DuckDB installation to function.

Related Skills

Explore More Data & Analytics Skills→
InnerScopeHearingInnerScopeHearing

notion-export

Export Notion content to Azure Blob storage with ring-based classification.

Official
Advanced
patrykkopycinskipatrykkopycinski
6

kibana-lens

Create and edit Kibana Lens visualizations from Elasticsearch data views or SQL queries.

Community
Intermediate
microsoftmicrosoft
242

azure-storage

Automate Azure Storage management tasks via Azure CLI subcommands.

Official
Intermediate
nrminornrminor

duckdb

Query Parquet, CSV, and JSON files in place with DuckDB SQL.

Community
Intermediate