Reference
Send one v3 query request to a local instance or a Helix Cloud database and print the JSON
response. Local and Cloud.
Usage
request_type (read or write)
and query. Query bundles are not supported.
Arguments
Options
Input (pick one)
Connection (local only)
Output
Behavior
Target resolution
- A typed
tenant:<id>/cluster:<id>target works without ahelix.toml. - With no target, the CLI uses the
devinstance (local or Cloud), then the only instance, then a picker in a terminal. - Otherwise it fails and lists the instances you can pass.
Local queries
- Local queries post to the auth-disabled local
/v2/query. --host,--port, and read-only--warmare local options; Cloud targets reject them.- If nothing is listening, the error suggests
helix start <instance>.
Cloud queries
Cloud queries use the WorkOS session and go through the broker — the Helix Cloud backend service that forwards CLI queries to your database. The CLI never calls the Cloud gateway (the database endpoint that applications reach with an application key) directly.readuses the backend read-query RPC and requiresdatabase.query.read.writeuses the backend write-query RPC and requiresdatabase.query.write.- The backend rejects an operation/envelope mismatch before gateway dispatch.
- No database key, custom auth header, or direct gateway URL is accepted.
- A mutation is never retried after dispatch, timeout, or ambiguous transport failure.
- Cloud query bodies, parameters, results, operational gateway authorization, and credentials are not logged by the broker.
TypeScript input
-eand--ts-fileneed Node.js 20+. The expression must evaluate to areadBatch()orwriteBatch()builder.- On first use, the CLI installs the pinned
@helix-db/helix-dbSDK into the Helix cache directory (override withHELIX_CACHE_DIR). No running instance is needed to build the request.
Output
- The response goes to stdout as syntax-highlighted, pretty-printed JSON. A dim footer with the HTTP status, latency, and target (for example
200 OK · 12ms · dev) goes to stderr, so stdout stays pipeable. --jsonprints only the compact JSON response.--quietstill prints the response but drops the footer.- An empty response prints nothing. A non-2xx response fails with the HTTP status and body.
Examples
Related
helix shell— send several requests interactively.helix start— start the local instance you query.- Local workflow — iterate on queries locally.
- Helix Cloud workflow — query a Cloud database.