Quickstart

Use a verified release

GitHub Latest release. :::

1. Initialize the workspace

sqlrs init

2. Add explicit repository recipes

chinook.prep.s9s.yaml:

kind: psql
args:
  - -f
  - chinook/prepare.sql

smoke.run.s9s.yaml:

kind: psql
args:
  - -f
  - queries/smoke.sql

Paths inside an alias file resolve relative to that file. The alias files belong in source control; local workspace configuration remains in .sqlrs/.

3. Prepare and run

sqlrs prepare chinook run smoke

This composite contains exactly two stages. The run consumes the instance produced by prepare, so it does not also accept --instance in this form.

Raw equivalent shape

sqlrs prepare:psql -- -f init.sql run:psql -- -c "select count(*) from users"

Arguments after -- belong to psql. sqlrs supplies the connection and rejects conflicting psql connection arguments.