2025-08-26

exporting kindle vocaburary builder to json

  1. connect your kindle
  2. copy vocab.db (sqlite) to your desktop
❯ cp /Volumes/[DEVICE-NAME]/system/vocabulary/vocab.db ~/Desktop/vocab.db
  1. move to desktop
❯ cd ~/Desktop
  1. install sqlite if not installed
❯ brew install sqlite
❯ sqlite3 --version
  1. dump the table to json
❯ sqlite3 vocab.db -json \
"SELECT l.id, l.word_key as word, l.usage, b.title
FROM LOOKUPS l
LEFT JOIN BOOK_INFO b
ON l.book_key = b.id;" > lookups.json
// lookups.json
[
  {
    "id": "CR!22SBT:AegIA:111:8",
    "word": "en:chink",
    "usage": "I think Lee Sedol found a chink in its armor. ",
    "title": "The MANIAC"
  }
]