mr query schema
List every database table and its columns, for use as a reference
when authoring query Text. The response is a single JSON object whose
keys are table names and whose values are arrays of column name
strings. Both user-facing tables (e.g. resources, notes,
groups) and internal FTS/virtual tables appear in the output.
Handy as a quick discovery tool before writing a new saved query or MRQL expression.
Usage
mr query schema
Examples
Dump the full schema as JSON
mr query schema
List only the column names of the resources table
mr query schema --json | jq -r '.resources[]'
Flags
This command has no local flags.
Inherited global flags
| Flag | Type | Default | Description |
|---|---|---|---|
--json | bool | false | Output raw JSON |
--no-header | bool | false | Omit table headers |
--page | int | 1 | Page number for list commands (default page size: 50) |
--quiet | bool | false | Only output IDs |
--server | string | http://localhost:8181 | mahresources server URL (env: MAHRESOURCES_URL) |
Output
Object mapping table name (string) to an array of column names (string[])
Exit Codes
0 on success; 1 on any error