Database (Live Tables)
List Live Tables, inspect schemas, and query data with TQL from the trickest CLI.
On this page10
The database family manages Live Tables — structured datasets populated
by workflow runs and solutions. From the CLI you list tables, inspect schemas,
preview rows, and run TQL (Trickest Query Language) filters.
Command summary
| Subcommand | Description |
|---|---|
database ls | List tables |
database get <table> | Table detail view |
database schema <table> | Column types and constraints |
database preview <table> | First N rows |
database query <expr> | Run a TQL filter |
database live <table> | Create a live table connection |
database detect | Scan latest run outputs for JSONL tables |
database rm <table> | Delete a table |
Listing and inspecting
database ls
trickest database ls[{"id":"1a66b80e-…","name":"merge-all_merge-all","status":"live","schema":{"fields":[{"name":"id","type":"int64","is_key":true}, …]}}]database schema / preview / get
trickest database schema 1a66b80e-…
trickest database preview 1a66b80e-… --limit 10
trickest database get 1a66b80e-…Querying with TQL
database query runs a filter-only expression — not SQL SELECT.
Syntax
- Operators:
=,!=,>,<,~(contains),!~(not contains) - Combine with:
AND,OR - No
SELECT,JOIN,GROUP BY, aggregates, or wildcards
Examples:
severity = "critical"
port > 443 AND service = "http"
hostname ~ ".*staging.*"Running a query
trickest database query "id > 0" --table 1a66b80e-… --limit 10
trickest database query "severity = critical" --table 1a66b80e-… --limit 1 --select id,name,severity| Flag | Description |
|---|---|
--table <id> | Table ID (required) |
--limit <n> | Max rows returned |
--offset <n> | Pagination offset |
--select <cols> | Comma-separated columns |
--order-by <expr> | e.g. "severity DESC" |
--sql | Raw SQL — backend-gated (405 until POST /view ships) |
Row shape
Each row includes system columns prefixed with _ (_id, _status,
_is_active, _first_seen, _last_seen, _timestamp, _execution_id,
_user) plus your dataset fields. Filter on user fields; _ columns are
platform bookkeeping.
Counting rows
There is no COUNT(*). Run the same filter with --limit 1 and read
total_count from the response.