Query Pilot Library

Help ID: query-runner.library

The Library target tab browses reusable scripts from multiple sources without leaving Query Pilot.

Sources

The tree is source-first:

  • Repo is the saved-query library stored in the Minion repository database.
  • Local sources are folders on the workstation.
  • UNC sources are shared folders such as \\server\share\sql.

Each source root has its own icon. Folders under a source use folder icons and switch to an open folder icon when expanded. Local and UNC source definitions are saved in %APPDATA%\MidnightDBA\MinionEnterprise\QueryRunnerLibrarySources.json.

Open And Save

Double-click a script to open it in the active editor tab. The tab keeps the library link, so later Save current updates the same script instead of creating a duplicate.

If a tab is not linked to a library script yet, Save current opens a save dialog where the user chooses the target source, folder, and script name.

Renaming a tab that is linked to a saved script also renames the script. For local or UNC scripts, the underlying file path is updated through the local library service.

Use the search box with the Names, Tags, and SQL toggles:

  • Names searches script names, descriptions, folder paths, and source labels.
  • Tags searches explicit and inherited tags.
  • SQL searches the script body. Turn this off for faster searches over large folder sources.

Search applies across Repo, Local, and UNC sources that are currently loaded.

Source Tags

Local and UNC sources can have tags. Source tags are inherited by scripts underneath that source and participate in tag search.

Removed Library Run Button

Execution uses the main Query Pilot Run button. The Library pane no longer has its own Run button, so saved and ad hoc scripts follow the same target, database, policy, logging, and run-state path.

Related: Query Pilot, Script Library.

Documentation revision: 1F3F59C7DE77FE08