CLI reference

The RawTree CLI command is rtree.

Install

curl -sSf https://rawtree.com | sh

Global options

Option	Description
`--database <database>`	Override the database for this command.
`--org <organization>`	Override the organization for this command.
`--json`	Print machine-readable output.
`--version`	Print the CLI version.

Environment variables

Variable	Description
`RAWTREE_API_KEY`	JWT or API key.
`RAWTREE_DATABASE`	Default database.
`RAWTREE_ORG`	Default organization.

Resolution order:

Database: --database, then RAWTREE_DATABASE, then saved config.
Organization: --org, then RAWTREE_ORG, then saved config.
API key: --api-key, then RAWTREE_API_KEY, then saved credentials from rtree login.

Authentication

rtree login
rtree login --token rt_...
rtree logout
rtree status

Databases

rtree database list
rtree database create analytics
rtree database use analytics
rtree database delete analytics

Organizations

rtree organization list
rtree organization create team-alpha
rtree organization use team-alpha
rtree organization rename team-alpha team-beta
rtree organization delete team-beta

Insert

rtree insert --table events --data '{"action":"click"}'
rtree insert --table events --file ./events.jsonl
rtree insert --table events --url https://example.com/events.jsonl
rtree insert --table traces --data '{"resource":{"attributes":[{"key":"service.name","value":{"stringValue":"api"}}]},"scopeSpans":[{"spans":[{"name":"GET /health","spanId":"abc"}]}]}' --transform otlp-traces

See Transforms for supported transform names, input shapes, and emitted rows, including the AWS Firehose HTTP endpoint transform.

Query

rtree query "SELECT * FROM events LIMIT 10"
rtree query --sql "SELECT count() FROM events"
cat query.sql | rtree query -
rtree query --limit 10 "SELECT * FROM events"

Logs

rtree logs --since 1h --limit 50
rtree logs --type insert --status error --table events
rtree logs --start-time 2026-04-24T10:00:00Z --end-time 2026-04-24T11:00:00Z

Tables

rtree table list
rtree table describe events

API keys

rtree key list
rtree key create --name ci --permission read_write
rtree key delete <id_or_token>

Utility

rtree ping
rtree docs
rtree open
rtree completions zsh

CLI

On this page