Skip to content

Tools and prompts

The assistant picks these tools on its own; you don't call them by name. This page shows what it can do.

Parameters marked optional can be left out when TRINO_CATALOG / TRINO_SCHEMA are set. Results come back as JSON unless noted otherwise.

Explore

Tool What it does Parameters
show_catalogs List all catalogs none
show_schemas List the schemas in a catalog catalog optional
show_tables List the tables in a schema catalog, schema_name optional
show_catalog_tree Tree of all catalogs, schemas and tables (can be slow) none
describe_table Columns and types of a table table; catalog, schema_name optional
show_create_table The CREATE TABLE statement table; catalog, schema_name optional
show_create_view The CREATE VIEW statement view; catalog, schema_name optional
show_stats Column statistics table; catalog, schema_name optional

Query

Tool What it does Parameters
execute_query Run a SQL statement and return the rows query
show_query_history Recent queries on the cluster, newest first limit optional

Iceberg metadata

All take table, plus optional catalog and schema_name.

Tool Shows
show_table_properties Table properties
show_table_history When each snapshot became current
show_snapshots Snapshots with operation and change summary
show_metadata_log_entries Metadata file log
show_manifests Manifest files; all_snapshots=true for every snapshot
show_entries Manifest entries; all_snapshots=true for every snapshot
show_partitions Partitions with record counts and sizes
show_files Data files in the current snapshot
show_refs Branches and tags

Iceberg maintenance

These change tables. Clients that support it ask you before running them, and they are hidden in read-only mode.

Tool What it does Parameters
optimize Compact small data files table; catalog, schema_name optional
optimize_manifests Rewrite and compact manifest files table; catalog, schema_name optional
expire_snapshots Remove snapshots older than a threshold table; retention_threshold (default 7d); catalog, schema_name optional

Prompts

Prompts are ready-made conversation starters. In Claude Code they show up as slash commands.

Prompt What it does
explore_data Start exploring a catalog or schema
maintain_iceberg Discuss which maintenance an Iceberg table needs