01
An editor that knows your schema.
IntelliSense reads real tables, columns and types — by default from a non-production
database, so writing a script never touches prod. Every script opens in its own tab,
Ctrl+K formats it, and an error leaves a marker on the line that failed.
02
No surprise runs against prod.
Flag a connection as production once. From then on, a run that would touch it stops and
asks first. On the command line the answer is a --yes flag, and AI agents hit
the same check, so automation cannot skip what the app insists on.
03
One script for staging and prod.
Put what changes between environments — retention days, a schema name, a row limit
— in variables with a value per environment. Switch environment and the same script
does the right thing. Variables survive every GO and quote themselves
correctly as text, identifier, number or raw.
04
One tenant out of fifty failed? You'll know which.
Every failure names the database, the batch and the line; click it and the editor opens
there. Decide in advance what a failure does, per script: carry on, skip the rest of the
script, stop that database, or stop everything.
05
Changes to your targets get reviewed like code.
Connections, target groups and environments are plain files, so adding a server to
All Prod goes through a pull request like any other change. No passwords in them
— those stay in the Windows credential store. Commit, push and diff from the built-in
git panel.
06
“What did we run last night?” Answered.
History keeps every run: the target group, how many databases, what succeeded, what failed,
and what pre-flight stopped before anything connected. Double-click a run to bring its
results back.