Memos Backup Reader

A client-only, read-only viewer for a memos SQLite backup — for reading your notes when the server is down.

The database is parsed in the browser with SQLite compiled to WebAssembly (sql.js). Nothing is uploaded; there is no backend.

Features

• Drop in a memos backup .db (or click to pick one)
• Memos and Archived tabs (row_status NORMAL / ARCHIVED)
• Filter by tag, with per-tag counts
• Substring search over memo content
• Created time, plus "edited" time when a memo was updated
• Attachments listed by filename and MIME type
• Pinned memos first; markdown rendered and sanitized

Usage

pnpm install
pnpm dev      # http://localhost:5173

Then drag your backup .db onto the page, or click to pick it.

To build a static bundle you can open from anywhere (a USB stick, a local folder):

pnpm build    # -> dist/
pnpm preview

Notes

• Backups often contain private data. .gitignore excludes *.db so a backup is never committed by accident.
• Tags come from the tags array in each memo's payload JSON column, which memos derives from the #hashtags in the content.
• Attachments are listed, not displayed. Memos usually keeps attachment bytes on the server's disk (storage_type LOCAL, with blob left NULL), so the files are not in the backup — only the filename and type are.
• Backups from older memos versions have no attachment table; those load fine and simply show no attachments.