Project and script

A project is a set of .sql files and how to run them: which scripts, in what order, which are enabled, and the execution settings that apply to the run.

The filesystem is the source of truth for the files themselves. A project records only what the filesystem cannot — order, enablement, each script's error policy, and which database its IntelliSense resolves against. Scripts are referenced by path relative to the project file, so a project moves with its folder.

A project belongs to exactly one workspace, and borrows every connection and target group from it. A project owns no connections of its own.