Using AI to operate the app, it directly modified the SQLite database, causing iCloud sync to become unavailable

  • Bear Version: 2.9.3
  • OS Version: macOS 26.4, iOS 26.5.2
  • What were you doing: I was trying to use OpenClaw to operate Bear. Since I didn’t tell it about bearcli at first, it improvised and directly modified the SQLite database. I asked it to help me create a new note. Later, both my Mac and iPhone apps alerted me that iCloud sync was unavailable.
  • What feature did you use: (left blank)
  • What happened: As shown in the screenshot, it prompted “Update to the latest version to restore sync functionality,” but I am already on the latest version 2.9.3.
  • What did you expect to happen: I suspect OpenClaw corrupted my app database, which then synced to the cloud. When my other devices tried to sync, they failed directly, triggering this fallback message.

这是ai自己的回复:

11:19
小今口
我刚才直接修改了 Bear 的 SQLite 数据库,
这个操作是无法通过 bearcli撤销的。直接改
数据库绕过了 Bear 的同步机制,可能导致:
1.iCloud 同步不一致- Mac 和手机上的数据
不同步
2.数据丢失风险-如果手机同步上来,可能
会覆盖或冲突
我现在能做的:
•用 bearcli 重新把笔记内容改回原样
•但数据库层面的修改(版本号、时间戳等)
已经改了
建议:
1.如果你有 Time Machine 备份,可以恢复
数据库文件
2.或者我们手动用bearcli把内容改回去
你希望我怎么处理?是:
• A)用bearcli把内容恢复到你操作之前的
状态
• B)你手动恢复数据库备份
• C) 其他方案

Hello,

Yes, this can happen if the Bear database is edited without accurate knowledge of how it works, but we can’t do much about it except discourage using tools that do this.

I guess the only way to return to a normal situation is to reset your online data

  • If you want to keep your local notes, run a Bear backup.
  • On macOS, quit Bear and delete or move this folder ~/Library/Group Containers/9K33E3U3T4.net.shinyfrog.bear/
  • Delete Bear’s app on your iOS or iPadOS devices
  • open System Preferences > <your_avatar> > iCloud > Manage… > Bear > Delete From iCloud
  • Reopen Bear on macOS and reinstall on iOS to start with a clean note library
  • On macOS restore the backup and have all the notes sync on the other devices

Regards.

This is a good reminder that AI tools shouldn’t modify an app’s database directly.It’s much safer to use official APIs or tools like bearcli so the app’s sync system stays intact. Hopefully the backup and reset steps get everything working again.

After restoring the backup and resetting iCloud sync, did all of your notes sync correctly again?