trino_iceberg

What problem does it solve?

This Skill helps you create, query efficiently, and safely maintain Apache Iceberg tables when working through Trino, preventing slow scans caused by poor partitioning, missing stats, or incorrect maintenance workflows.

Core Features & Use Cases

• Design high-performance Iceberg tables: Define partition transforms, bucketing, and sorted writing to improve pruning and join efficiency, then validate behavior with EXPLAIN and stats.
• Execute all Iceberg DDL/DML operations in Trino: Cover CREATE, ALTER (including schema evolution and property updates), INSERT/UPDATE/DELETE/MERGE, TRUNCATE, and time travel reads for rollback.
• Run production maintenance and diagnostics: Perform OPTIMIZE, EXPIRE_SNAPSHOTS, REMOVE_ORPHAN_FILES, OPTIMIZE_MANIFESTS, then verify with metadata table queries like $partitions and $snapshots.

Quick Start

Use the trino_iceberg skill to diagnose a slow Iceberg query by running EXPLAIN (TYPE DISTRIBUTED) and then deciding whether to change partitioning, add bucketing/sorted_by, and apply ANALYZE or table maintenance.