iCloud Drive sync
functionalOpt in to keep connections, snippets, queries and settings the same on every Mac through your own iCloud Drive. Passwords stay in each Mac's keychain.
iCloud sync keeps your saved connections, snippets, SQL Library queries and look-and-feel settings the same on every Mac you use. It goes through a folder in your own iCloud Drive, so your setup travels through Apple's sync, not a SQLly server. It is off until you turn it on, and your passwords never leave the Mac they were saved on.
Turning it on
- Make sure the Mac is signed in to iCloud with iCloud Drive turned on (System Settings › Apple Account › iCloud › iCloud Drive).
- In SQLly, open Settings › Workspace › iCloud Sync and tick Sync with iCloud.
- Do the same on each other Mac. SQLly syncs right away, again about once a minute while it is open, and whenever you click Sync Now.
The pane shows when SQLly last synced and how many changes came in. If the Mac isn't
signed in to iCloud, or iCloud Drive is off, it says which, and syncs nothing until
that is fixed. The sync files live in a folder called SQLLY Sync in your
iCloud Drive; leave it in place.
What syncs, and what never does
| Items | |
|---|---|
| Syncs | Saved connections, with their notes, clients, projects, environments, colors, icons and safety switches, and tunnel profiles. |
| Syncs | Snippets and quick actions. |
| Syncs | Queries in the SQL Library while it is in its default folder, up to 1 MB per file. A library you moved to a folder of your own is left alone. |
| Syncs | Appearance, editor, keyboard shortcut, SQL formatting, result formatting, conditional formatting, sensitive-column, server explorer, tab and transaction settings. |
| Never syncs | Passwords, SSH key passphrases, tokens and API keys. They stay in each Mac's keychain. |
| Never syncs | Shared logins, query history, open tabs, AI and MCP settings, connections from a provisioning file, and settings that point at programs or files on one Mac (external editors, command-line tools, a custom translation file). |
Because the password never travels, a connection that arrives on another Mac asks for it the first time you connect there. After that, each Mac keeps its own saved password, and editing the connection on one Mac never disturbs the password saved on another. A connection that used a shared login arrives as a plain sign-in with the same user name.
Connections, snippets and queries from another Mac appear as soon as a sync brings them in. Settings that arrive from another Mac are saved straight away and take full effect the next time SQLly starts.
When two Macs disagree
- The most recent change wins. Each connection, label, snippet, query and settings file is merged on its own, so changing one connection on one Mac and another connection on a second Mac keeps both changes.
- Deletes stick. Deleting an item on one Mac deletes it on the others, and a Mac that was offline for a while can't bring it back with its old copy.
- Edited queries are never thrown away. If a query you changed on this Mac loses to a newer version from another Mac, your version is saved beside it as
name (conflicted copy date time).sql, and that copy syncs too. - A Mac that joins later takes the shared copy. When you turn sync on for a second Mac, settings that are already in iCloud replace that Mac's own; its connections, snippets and queries are added to the shared set.
Safety
- Damaged or half-downloaded files are skipped. Each Mac writes its own file in the
SQLLY Syncfolder, replacing it whole. A file that is damaged, still downloading from iCloud, or written by a newer version of SQLly is skipped and named in the pane; nothing on your Mac changes because of it. - Unreadable local files are left alone. If one of your own settings files can't be read, SQLly neither sends it nor treats it as deleted.
- Secrets are removed before anything is written. Every password slot in a connection or tunnel profile is emptied before it goes to iCloud, whichever slot it is.
Turning it off
Untick Sync with iCloud. Syncing stops on that Mac, and nothing is removed from the Mac or from iCloud. Turn it back on later and SQLly picks up where it left off: changes you made in the meantime, including deletes, go out on the next sync.
Where it is available
iCloud sync is part of the direct-download edition of SQLly for macOS. The Mac App Store edition doesn't offer it, and neither do Windows and Linux. To move connections there, use File › Export Connections… and File › Import Connections…, or point a file-sync tool at the SQLly folder as described in Everything is a file.
iCloud sync arrives in the next SQLly release for macOS. If your copy has no Settings › Workspace › iCloud Sync page yet, update SQLly.