Moving connections and queries

Exporting connections

File → Export connections writes your connections to a single encrypted file.

1. Tick the connections to include — Select all and Deselect all are there for long lists, and the header shows how many of how many are selected.
2. Enter an encryption passphrase and confirm it.
3. Choose where to save the file.

The file is encrypted with AES-256-GCM using that passphrase. It contains your database passwords, so the passphrase is the only thing protecting them — pick accordingly, and send it through a different channel than the file itself.

The passphrase cannot be recovered

There is no reset and no backdoor. Lose the passphrase and the exported file is unreadable.

Importing connections

File → Import connections, pick the file, enter the passphrase used at export time.

Connections are matched by their internal ID. Any that already exist are skipped rather than duplicated, so re-importing the same file twice is harmless. NabuSQL reports how many connections were added, and tells you when every one already existed.

Moving to a new computer

1. Export your connections on the old machine.
2. Install NabuSQL on the new one and import the file.
3. Activate your license there. The license is bound to the machine, so you will need a re-issued key — see Trial and license.

Copying connections.json between machines by hand works, but the encrypted export exists so that the file is safe while it is in transit.

Saved queries

Queries you save in the SQL editor are stored inside NabuSQL and are not part of the connection export.

If you want your queries to travel — or to live in version control alongside the project they belong to — set a Queries folder on the connection instead. NabuSQL then reads .sql files from {folder}/{database}/ and shows them in the sidebar. Those files are plain SQL on disk: back them up, commit them, share them, edit them in any editor.

Inside NabuSQL file-backed queries are read-only, marked From file (read only). Right-click the Queries group to open the folder in your file manager.