Skills
.Work. You
Rest

aiops-query-cost-analyzer

Community

Detect and cut query cost waste.

Data & Analytics#trino#anomaly detection#sql optimization#clickhouse#chargeback#budget enforcement#query cost analysis
Authorivanshamaev
Version1.0.0
Installs0

System Documentation

What problem does it solve?

It helps you identify which data queries are driving the largest compute and data-scan costs and then reduce those costs with actionable optimization guidance.

Core Features & Use Cases

  • Cross-engine cost attribution: Analyzes Trino, ClickHouse, and (via provided logic) Spark cost signals using engine system tables/logs.
  • Expensive-query ranking & budget enforcement: Surfaces top resource-consuming queries, estimates cost proxies, and flags users exceeding daily budgets.
  • LLM-driven rewrite recommendations: Generates targeted SQL rewrite suggestions for common cost drivers such as missing partition filters, inefficient aggregation, and join strategy issues.
  • Chargeback & anomaly reporting: Produces team/project chargeback summaries and detects anomalous cost regressions over time.

Quick Start

Use the aiops-query-cost-analyzer skill to generate a cost report for your last 24 hours of Trino and ClickHouse queries, including the top expensive queries and suggested SQL rewrites.

Dependency Matrix

Required Modules

None required

Components

Standard package

💻 Claude Code Installation

Recommended: Let Claude install automatically. Simply copy and paste the text below to Claude Code.

Please help me install this Skill:
Name: aiops-query-cost-analyzer
Download link: https://github.com/ivanshamaev/de-agent-skills/archive/main.zip#aiops-query-cost-analyzer

Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
View Source Repository

Agent Skills Search Helper

Install a tiny helper to your Agent, search and equip skill from 471,000+ vetted skills library on demand.