OpenParable
Skip to content
← Back to skills

Trino CLI

Apps & Automation
trino-cli

Trino CLI is an Agent Skill for apps & automation published in the majiayu000/claude-skill-registry repository on GitHub: a SKILL.md instruction file an AI agent can load to do this task.

Trino CLI for TD interactive queries. Covers connection to regional endpoints, batch mode (--execute, --file), output formats (CSV, JSON, TSV), and session properties.

View on GitHub ↗
QUICK START

How to use this skill

Bring this guide into your coding agent with a prompt tailored to the tool you use.

  1. Open your project in Codex.
  2. Copy and paste the prompt below.
  3. Review files and risks before approving any action.
Prompt to paste
Inspect the Agent Skill at https://github.com/majiayu000/claude-skill-registry/blob/HEAD/skills/development/trino-cli/SKILL.md and all supporting files. Report provenance, permissions, scripts, dependencies, and security risks. Propose an exact installation into .agents/skills/trino-cli, but wait for my approval before writing files or running scripts.

Copying this prompt does not install or run the skill. Review third-party files before use.

Trino CLI for Treasure Data

Installation

curl -o trino https://repo1.maven.org/maven2/io/trino/trino-cli/477/trino-cli-477-executable.jar
chmod +x trino
sudo mv trino /usr/local/bin/

Requires Java 11+.

Connection

export TD_API_KEY="your_api_key"

trino \
  --server https://api-presto.treasuredata.com \
  --catalog td \
  --user $TD_API_KEY \
  --schema your_database

Regional Endpoints:

  • US: https://api-presto.treasuredata.com
  • Tokyo: https://api-presto.treasuredata.co.jp
  • EU: https://api-presto.eu01.treasuredata.com

Batch Mode

# Single query
trino --server ... --execute "SELECT COUNT(*) FROM events"

# From file
trino --server ... --file queries.sql

# From stdin
echo "SELECT * FROM events LIMIT 10" | trino --server ...

Output Formats

# CSV for spreadsheets
--output-format CSV_HEADER > results.csv

# JSON for programmatic use
--output-format JSON > results.json

# TSV for data processing
--output-format TSV_HEADER > results.tsv

# Markdown for docs
--output-format MARKDOWN

Available: CSV, CSV_HEADER, CSV_UNQUOTED, TSV, TSV_HEADER, JSON, MARKDOWN, NULL

Interactive Commands

CommandDescription
USE schemaSwitch database
SHOW SCHEMASList databases
SHOW TABLESList tables
DESCRIBE tableShow structure
EXPLAIN queryShow plan

Configuration File

# ~/.trino_config
server=https://api-presto.treasuredata.com
catalog=td
user=$TD_API_KEY
schema=sample_datasets

Session Properties

trino \
  --session query_max_run_time=1h \
  --session query_priority=2 \
  --execute "SELECT ..."

Common Options

OptionDescription
--execute "SQL"Run query and exit
--file queries.sqlRun from file
--output-formatOutput format
--client-request-timeout 30mQuery timeout
--ignore-errorsContinue on error
--no-progressDisable progress

Resources