otty / apps
All apps/Sqitch

Sqitch

sqitch

Sensible database-native change management for framework-free development and dependable deployment.

Runs as sqitch|macOS, Linux, Windows|sqitch.org
Open form in Otty otty.toml

Command form

ai-draft · 4 tasks · 17 fields

Deploy or revert database changes, or add a new change to the plan. Other subcommands (init, tag, rebase, bundle, status, verify) are not covered.

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

sqitch deploy

Deploy changes

Deploy changes from the plan to a target database. Positional target and change arguments are left out; use the target and to-change fields.

Deploy changesExample values, fixed in this page — nothing here reaches a terminal
Basic
Target*
string
Verify each change
--verify
TasksEach one presets the form for one job
Deploy to a target
targetverify
Deploy and verify each change
targetto_changeverify
ParametersOnly these flags are editable in the form
Target
A database URI or the name of a configured target.
string
--target-t
Deploy up to change
Defaults to the last point in the plan.
string
--to-change--change--to
Failure reversion mode
enum
--modealltagchange
Verify each change
boolean
--verify
Log only
Record changes as deployed without running the deploy scripts.
boolean
--log-only
Client variables
One name=value per entry.
string · repeatable
--set-s
Lock timeout (seconds)
integer
--lock-timeout

sqitch revert

Revert changes

Revert deployed changes from a target database. Positional arguments are left out.

Revert changesExample values, fixed in this page — nothing here reaches a terminal
Basic
Target*
string
Revert to change
string
TasksEach one presets the form for one job
Revert a target
targetto_change
ParametersOnly these flags are editable in the form
Target
string
--target-t
Revert to change
Defaults to reverting all changes.
string
--to-change--change--to
Revert to earliest modified change
boolean
--modified-m
Log only
boolean
--log-only
Skip confirmation prompt
boolean
-y

sqitch add

Add a change

Add a new change and its deploy, revert and verify scripts to the plan.

Add a changeExample values, fixed in this page — nothing here reaches a terminal
Basic
Change name*
string
Required changes
string
Note
string
TasksEach one presets the form for one job
Add a change
changerequiresnote
ParametersOnly these flags are editable in the form
Change name
string
--change-c--change-name
Required changes
string · repeatable
--requires-r
Conflicting changes
string · repeatable
--conflicts-x
Note
string
--note-n
Open scripts in editor
boolean
--edit-e
SourcesEvery flag above is checked against these
deploy-pod
=item C<-t> =item C<--target> The target database to which to connect. This option can be either a URI or the name of a target in the configuration. =item C<--to-change> =item C<--change> =item C<--to> Specify the deployment change. Defaults to the last point in the plan. =item C<--mode> Specify the reversion mode to use in case of deploy or verify failure.…
manualHEAD 2026-10-27

github.com

revert-pod
=item C<-t> =item C<--target> The target database to which to connect. This option can be either a URI or the name of a target in the configuration. =item C<--to-change> =item C<--change> =item C<--to> Specify the reversion change. Defaults to reverting all changes. =item C<-m> =item C<--modified> Finds the change to revert onto based on modifications to dep…
manualHEAD 2026-10-27

github.com

add-pod
sqitch add widgets [options sqitch add slinkies --require sprockets --set schema=industry =item C<-c> =item C<--change> =item C<--change-name> The name of the change to add. =item C<-r> =item C<--requires> Name of a change that is required by the new change. May be specified multiple times. =item C<-x> =item C<--conflicts> Name of a change that conflicts…
manualHEAD 2026-10-27

github.com

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