> ## Documentation Index
> Fetch the complete documentation index at: https://ngquct-feat-ai-sql-walkthroughs.mintlify.site/llms.txt
> Use this file to discover all available pages before exploring further.

# iCloud Sync

> Sync connections, table favorites, settings, and SSH profiles across Macs via iCloud

# iCloud Sync

TablePro syncs your connections, groups, table favorites, saved queries, settings, and SSH profiles across all your Macs via CloudKit. iCloud Sync requires an active license (Starter or Team, see [Licensing](/features/licensing)).

## What syncs (and what doesn't)

| Data                   | Synced | Notes                                                                                                                                   |
| ---------------------- | ------ | --------------------------------------------------------------------------------------------------------------------------------------- |
| **Connections**        | Yes    | Host, port, username, database type, SSH/SSL config                                                                                     |
| **Passwords**          | Opt-in | Via iCloud Keychain (end-to-end encrypted), nested under the Connections toggle                                                         |
| **Groups & Tags**      | Yes    | Full connection organization, including nested group hierarchy and sort order                                                           |
| **SSH Profiles**       | Yes    | Named [SSH profiles](/features/ssh-profiles). Has its own toggle.                                                                       |
| **Table Favorites**    | Yes    | Favorited table names shown in the Favorites tab and pinned in table lists                                                              |
| **Saved Queries**      | Yes    | Saved SQL queries and their folders. Has its own toggle.                                                                                |
| **Settings**           | Yes    | General, Appearance, Editor, Data Grid, History, Tabs, Keyboard, and AI settings, plus custom AI slash commands                         |
| **Linked SQL Folders** | No     | Folder paths are per-Mac. Link the same Git repo on each Mac after cloning. Cached file metadata (`linked_sql_index.db`) is also local. |
| **Sidebar state**      | No     | The sidebar's database filter and recent tables lists stay on each Mac                                                                  |

<Note>
  Passwords are not synced by default. Enable the **Passwords** toggle under Connections to sync them via Apple's iCloud Keychain. Enabling it only affects new saves: re-save a password to update its sync. With password sync off, enter the password once on each new Mac.
</Note>

## Enabling iCloud Sync

Open **Settings** (`Cmd+,`) > **Account**, toggle iCloud Sync on, choose which categories to sync, and click **Sync Now**. Sync is off by default.

<Frame caption="iCloud Sync settings">
  <img className="block dark:hidden" src="https://mintcdn.com/ngquct-feat-ai-sql-walkthroughs/Bj1EoTflf_jG6N_3/images/settings-sync.png?fit=max&auto=format&n=Bj1EoTflf_jG6N_3&q=85&s=a54cb98b8a122379a1ee98b374009f27" alt="iCloud Sync settings" width="1440" height="1176" data-path="images/settings-sync.png" />

  <img className="hidden dark:block" src="https://mintcdn.com/ngquct-feat-ai-sql-walkthroughs/Bj1EoTflf_jG6N_3/images/settings-sync-dark.png?fit=max&auto=format&n=Bj1EoTflf_jG6N_3&q=85&s=063464fc1d018d4106f771987aec335d" alt="iCloud Sync settings" width="1440" height="1176" data-path="images/settings-sync-dark.png" />
</Frame>

Connections (with a nested Passwords opt-in), Groups & Tags, SSH Profiles, Settings, Table Favorites, and Saved Queries each have their own toggle. Custom AI slash commands ride along with the Settings toggle.

## Excluding individual connections

Some connections (e.g., localhost, dev databases) don't make sense on other devices. Mark them as **Local only** to keep them off iCloud:

* **Connection form**: open the **Advanced** tab and toggle **Local only**
* **Context menu**: right-click a connection and choose **Exclude from iCloud Sync**

Local-only connections show an `icloud.slash` icon in the sidebar. The flag is preserved when duplicating or exporting connections.

TablePro auto-syncs on app launch, when you switch back to it, and 2 seconds after you modify synced data.

When the same record changes on two Macs, you choose to keep the local or remote version. Conflicts are per-record, not per-category.

When a license expires, sync stops but local data remains. Re-activate to resume.

## Troubleshooting

If no records sync, confirm iCloud is signed in and iCloud Drive is enabled, then click **Sync Now**. For "iCloud account unavailable," sign in via **System Settings** > **Apple Account**.