Execute a read-only SQL query on Trino and return results as JSON.

Retrieve the list of table names in the configured Trino catalog and schema.

Assess Iceberg table health using metadata tables (snapshots, history, files, partitions, manifests, metadata_log_entries). Returns structured JSON summaries, recent activity, and health signals. Pass the table as name or catalog.schema.table (e.g. flights or iceberg.default.flights).

List Iceberg metadata tables available for a table. Pass table or catalog.schema.table (e.g. flights or iceberg.default.flights).

Describe the schema of an Iceberg metadata table (e.g. snapshots, files, refs).

Query an Iceberg metadata table with a safe row limit. Optional comma-separated columns.

List Iceberg snapshots for a table ordered by committed_at (most recent first).

List snapshot history from the Iceberg $history metadata table.

Get metadata for a single Iceberg snapshot ID including parsed summary stats.

List Iceberg branches and tags from the refs metadata table.

Time-travel read using FOR VERSION AS OF snapshot_id. Optional column list and limit.

Time-travel read using FOR TIMESTAMP AS OF timestamp (e.g. '2024-07-18 10:12:20').

Compare two Iceberg snapshots by ID and return metadata and summary diffs.

Return the Trino EXPLAIN plan for a read-only SELECT or WITH query.

EXPLAIN a read-only query and heuristically assess whether partition pruning is likely.

Estimate full-scan cost signals from Iceberg files/partitions metadata for a table.

List the hottest Iceberg partitions by file count and record count to detect skew.