Trino client

Enter the coordinator host, port and Username. Optional Catalog and Schema set the starting location. Set an IANA Time Zone for the session.

Sign in with a password, sent as HTTP Basic for LDAP or password-file authentication, or with a JWT access token sent as a bearer credential. Either one goes only over TLS: with SSL Disabled, a connection that holds one is refused before anything is sent. A client certificate and key on the SSL pane add mutual TLS.

SSL starts Disabled, which is plain HTTP; every other mode forces TLS with no plaintext fallback, and port 443 turns on Verify Identity. A redirect from a proxy in front of the coordinator is never followed; the error names where it pointed. Reach a coordinator behind a bastion through an SSH tunnel, and bring a trino:// URL in with Import from URL….

Query fully qualified catalog.schema.table names to join across catalogs. Browse catalogs, schemas, tables and materialized views; row-count estimates come from SHOW STATS.

bigint and decimal are read as exact text, not floating point. varbinary shows as hex, array, map and row as JSON, and timestamps keep the value the server returned.

Explain offers Logical, Distributed, IO, Validate and Analyze. Validate checks a query without running it, Analyze runs it and reports actual timings, and every plan comes back as raw text.

SET SESSION holds for the rest of the connection. Query > Cancel Query tells the coordinator to kill the running query, and that is the way to stop one: the connection’s query timeout does not reach Trino.

Cell edits use typed INSERT, UPDATE and DELETE statements. Trino reports no primary keys, so edits match every original column. Identical rows change together, with no transaction to undo them. Check for duplicates before editing.

The Structure tab creates tables and adds, drops, renames and retypes columns, in autocommit. Whether a change runs is up to the catalog’s connector, and a type change is the one fewest connectors accept.

There is no import. Export a table or a result as CSV, JSON, SQL, XLSX, Markdown, HTML and XML.

The iPhone and iPad app has no Trino driver. Trino connections synced from a Mac appear in its list but do not open.