The hsql CLI
hsql runs SQL against any database Harlequin has an adapter for, with one set
of flags and one output contract. It reads the same config files as the IDE, so
one profile serves both.
For a tutorial, see Using hsql. For more detailed information on hsql and its features, keep reading.
Pages
| Page | What it covers |
|---|---|
| Exit Codes and Streams | The six codes, stdout and stderr, --stats, --on-error |
| Exploring the Catalog | --catalog, --path, --catalog-search |
| Formats and Layouts | Every format, the layout switches, -o, --result |
| Config Modes | --config list-profiles, show, validate, schema, init |
| Running Safely | --limit, --read-only, --timeout, adapter capabilities |
| Differences from psql | What carries over, and what does not |
| Reference: hsql CLI | Every option, generated from hsql itself |
| The hsql Agent Skill | What the skill says, and how to install it |