otty / apps
All apps/sq

sq

sq

A free/libre open-source data wrangling swiss-army knife to inspect, query, join, import, and export data.

Runs as sq|macOS, Linux, Windows|sq.io
Open form in Otty otty.toml

Command form

ai-draft · 2 tasks · 10 fields

Inspect a data source's metadata and schema. Queries, source management and other sq subcommands are left out.

Opens the form; the finished command lands at your prompt, unrun
Run in Otty
otty gui sq

sq inspect

Inspect a source or table

Show metadata, tables and columns for a source (@handle) or a table (@handle.table). Omit the target to use the active source.

Inspect a source or tableExample values, fixed in this page — nothing here reaches a terminal
Basic
Source or table*
string
JSON output
--json
TasksEach one presets the form for one job
Inspect as JSON
targetjson
Write HTML schema doc
targethtmloutput
ParametersOnly these flags are editable in the form
Source or table
@handle, @handle.table or .table; leave empty for the active source.
string · positional 0
JSON output
boolean
--json-j
YAML output
boolean
--yaml-y
Markdown schema document
boolean
--markdown
HTML schema document
boolean
--html
Metadata only
boolean
--overview-O
List schemas
boolean
--schemata-S
List catalogs
boolean
--catalogs-C
Verbose
boolean
--verbose-v
Output file
path
--output-o
SourcesEvery flag above is checked against these
help
Usage: sq inspect [@HANDLE|@HANDLE.TABLE|.TABLE] -j, --json Output JSON -y, --yaml Output YAML --markdown Output a Markdown schema document --html Output a standalone HTML schema document -O, --overview Show metadata only (no schema) -p…
helpv0.55.0

sq.io

Before it fills your prompt, Otty checks the installed sq against its version. A form that does not match your version is not offered.