skills.rest
ivanshamaev
ivanshamaevCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

trino-self-healing-platform

Detect hung, OOM-failed, and stalled Trino queries and apply automated remediation.

14|1|Updated May 5, 2026
Search Tags:#trino#airflow#self-healing#watchdog#iceberg maintenance#query anomaly detection#rca automation
One-click install
npx skills add https://github.com/ivanshamaev/de-agent-skills --skill trino-self-healing-platform
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: trino-self-healing-platform
Source: https://github.com/ivanshamaev/de-agent-skills/tree/main/group_skills/trino_group_skills/trino_self_healing_platform
Command: npx skills add https://github.com/ivanshamaev/de-agent-skills --skill trino-self-healing-platform

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

It reduces on-call burden by autonomously detecting and recovering from common Trino cluster failures (hung queries, worker loss, OOM-killed queries) and by proactively maintaining query performance and Iceberg health.

Core Features & Use Cases

  • Hung Query Killer: Classifies queries by source (interactive vs batch) and kills those exceeding time thresholds.
  • Memory Pressure Relief: Detects critical memory pressure and terminates low-priority queries to restore stability.
  • Iceberg Auto-Maintenance: Triggers Iceberg compaction and stale statistics ANALYZE based on small-file and staleness signals.
  • RCA Generation: Produces structured incident root-cause analysis using a Claude-based workflow when alerts fire.
  • Use Case: When Prometheus/AlertManager signals elevated latency or query failures, run this skill to kill stuck queries, relieve memory pressure, compact/ANALYZE impacted Iceberg tables, and generate an RCA report for operators.

Quick Start

Ask the agent to enable the Trino self-healing watchdog and configure it to run every 15 minutes against your Trino coordinator, using AlertManager webhooks and Airflow scheduling.

Frequently Asked Questions about trino-self-healing-platform

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

FAQPage Schema
How do I automatically kill hung Trino queries causing platform incidents?▼

Automatically kill hung Trino queries by classifying query sources as interactive or batch and terminating those exceeding defined time thresholds. This autonomous remediation detects stalled queries and prevents platform incidents.

What is the best way to relieve memory pressure on a Trino coordinator?▼

Relieve Trino memory pressure by detecting critical memory states and terminating low-priority queries to restore cluster stability. This automated action prevents OOM-killed queries and worker loss.

How do I automate Iceberg table compaction and ANALYZE statistics in Trino?▼

Automate Iceberg table maintenance by triggering compaction and stale statistics ANALYZE based on small-file and staleness signals. This proactive maintenance preserves query performance and table health.

Can I generate automated root-cause analysis for Trino alerts using Airflow?▼

Generate structured incident root-cause analysis for Trino alerts using a Claude-based workflow integrated with Airflow and AlertManager. This RCA automation produces reports for operators when alert webhooks fire.

Do I need Prometheus AlertManager to run Trino self-healing workflows?▼

Prometheus AlertManager is optional for Trino self-healing workflows. The watchdog requires integration with Trino coordinator REST endpoints, while AlertManager and Airflow provide alert-driven triggers and scheduling.

Why does Trino experience OOM-killed queries and stalled interactive workloads?▼

Trino experiences OOM-killed queries and stalled workloads due to unmanaged memory pressure and unclassified long-running queries. Autonomous detection and query kill/resubmission logic resolves these cluster health failures.

Related Skills

Explore More Software Engineering Skills→
ivanshamaevivanshamaev
14

trino-admin-cluster-health

Diagnose Trino cluster health via REST endpoints, JMX metrics, and logs.

Community
Advanced
aws-samplesaws-samples
18

automated-remediation

Execute predefined runbooks to remediate known failure patterns in AWS.

Official
Advanced
LucasSantana-DevLucasSantana-Dev

Homelab Monitoring Stack

Operate and troubleshoot a Prometheus, Grafana, Loki, and Alertmanager monitoring stack.

Community
Advanced
jeremylongshorejeremylongshore
2.6k

monitoring-database-health

Monitor PostgreSQL and MySQL database health with real-time metrics and alerts.

Community
Advanced