This is written current as of macOS Tahoe 26.0. Safari keeps a SQLite database of cross-device tabs at `$HOME/Library/Containers/com.apple.Safari/Data/Library/Safari/CloudTabs.db`. You likely need to allow Full Disk Access (System Preferences > Security & Privacy) to the Terminal app to access it. ```sql CREATE TABLE cloud_tab_devices( device_uuid TEXT PRIMARY KEY NOT NULL, system_fields BLOB NOT NULL, device_name TEXT, device_type_identifier TEXT, has_duplicate_device_name BOOLEAN DEFAULT 0, is_ephemeral_device BOOLEAN DEFAULT 0, last_modified REAL NOT NULL ); CREATE TABLE cloud_tabs( tab_uuid TEXT PRIMARY KEY NOT NULL, system_fields BLOB NOT NULL, device_uuid TEXT NOT NULL, position BLOB NOT NULL, title TEXT, url TEXT NOT NULL, is_showing_reader BOOLEAN DEFAULT 0, is_pinned BOOLEAN DEFAULT 0, reader_scroll_position_page_index INTEGER, scene_id TEXT, last_viewed_time REAL DEFAULT 0, FOREIGN KEY(device_uuid) REFERENCES cloud_tab_devices(device_uuid) ON DELETE CASCADE ); CREATE TABLE cloud_tab_close_requests( close_request_uuid TEXT PRIMARY KEY NOT NULL, system_fields BLOB NOT NULL, destination_device_uuid TEXT NOT NULL, url TEXT NOT NULL, tab_uuid TEXT NOT NULL, FOREIGN KEY(destination_device_uuid) REFERENCES cloud_tab_devices(device_uuid) ON DELETE CASCADE ); CREATE TABLE metadata( key TEXT NOT NULL UNIQUE, value ); ``` `system_fields` is a plist like: ```bash $ sqlite3 ~/Library/Containers/com.apple.Safari/Data/Library/Safari/CloudTabs.db "select hex(system_fields) from cloud_tab_close_requests" | xxd -r -p | plutil -convert xml1 - -o - ``` ```xml $archiver NSKeyedArchiver $objects $null CloudTabCloseRequest $class CF$UID 8 RecordName CF$UID 3 ZoneID CF$UID 4 15522CA7-FE12-4A44-9D5C-2BE66DD6D1BB $class CF$UID 7 ZoneName CF$UID 5 anonymousCKUserID CF$UID 0 databaseScopeKey 0 ownerName CF$UID 6 CloudTabs __defaultOwner__ $classes CKRecordZoneID NSObject $classname CKRecordZoneID $classes CKRecordID NSObject $classname CKRecordID $class CF$UID 10 NS.time 780376728.16100001 $classes NSDate NSObject $classname NSDate $class CF$UID 8 RecordName CF$UID 12 ZoneID CF$UID 13 __defaultOwner__ $class CF$UID 7 ZoneName CF$UID 14 anonymousCKUserID CF$UID 0 databaseScopeKey 0 ownerName CF$UID 15 _defaultZone __defaultOwner__ $class CF$UID 8 RecordName CF$UID 17 ZoneID CF$UID 13 __defaultOwner__ Joe’s Mac mini mfxf03to /4m8Qg== $top AllPCSKeyIDs CF$UID 0 BaseToken CF$UID 0 ChainParentPublicKeyID CF$UID 0 ChainPrivateKey CF$UID 0 ChainProtectionData CF$UID 0 ConflictLoserEtags CF$UID 0 CreatorUserRecordID CF$UID 11 DisplayedHostname CF$UID 0 ETag CF$UID 19 ExpirationDate CF$UID 0 Expired HasUpdatedExpiration HasUpdatedParentReference HasUpdatedShareReference KnownToServer LastModifiedUserRecordID CF$UID 16 MergeableValueDeltaRecord ModifiedByDevice CF$UID 18 MutableEncryptedPublicSharingKey CF$UID 0 NeedsRollAndCounterSignKey PCSKeyID CF$UID 0 ParentReference CF$UID 0 Permission 0 PreviousParentReference CF$UID 0 PreviousProtectionDataEtag CF$UID 0 PreviousProtectionDataEtagFromUnitTest CF$UID 0 PreviousShareReference CF$UID 0 ProtectionData CF$UID 0 ProtectionDataEtag CF$UID 0 RecordCtime CF$UID 9 RecordID CF$UID 2 RecordMtime CF$UID 9 RecordType CF$UID 1 RoutingKey CF$UID 0 ShareEtag CF$UID 0 ShareReference CF$UID 0 TombstonedPublicKeyIDs CF$UID 0 URL CF$UID 0 UpdatedExpiration CF$UID 0 UseLightweightPCS WantsChainPCSKey WantsPublicSharingKey WasCached ZoneProtectionDataEtag CF$UID 0 ZoneishKeyID CF$UID 20 $version 100000 ``` `cloud_tabs.position` is a gzip'ed JSON like: ```json { "sortValues": [ { "changeID": 0, "sortValue": 27893000, "deviceIdentifier": "1EBFBD4B-F483-44C6-9808-DFBE4097937C" } ] } ``` `cloud_tab_close_requests` is as expected. There does not appear to be a way to open tabs on remote devices. ``` $ sqlite3 -csv -header ~/Library/Containers/com.apple.Safari/Data/Library/Safari/CloudTabs.db "select close_request_uuid, destination_device_uuid, url, tab_uuid from cloud_tab_close_requests" close_request_uuid,destination_device_uuid,url,tab_uuid 15522CA7-FE12-4A44-9D5C-2BE66DD6D1BB,1EBFBD4B-F483-44C6-9808-DFBE4097937C,https://news.ycombinator.com/item?id=45335635,1E7D3D06-B4BC-4FF1-94E8-0CF39169BF94 ```