wanikani-sync
by mart1n-xyz
Search & ResearchBrief
Sync WaniKani Japanese learning progress data from the API to local storage for analysis and insights.
Description
What This Skill Does
Fetches WaniKani learning progress via the API and stores it in a local SQLite database. Supports incremental sync to avoid redundant API calls. Data includes assignments, reviews, level progressions, subjects, and statistics.
Storing data locally in SQLite lets you run arbitrary SQL queries and build custom reports without hitting API rate limits on every analysis.
When to Use It
- Backing up WaniKani progress data locally
- Identifying leeches and low-accuracy items
- Analyzing review accuracy by subject type
- Tracking time spent at each WaniKani level
- Querying SRS stage distribution across all items
Example Workflow
User asks: show me my worst leeches
- 1
Run incremental sync with python3 scripts/sync.py to fetch latest data
- 2
Confirm wanikani.db is updated with recent reviews and assignments
- 3
Run python3 scripts/queries.py leeches to query low-accuracy Apprentice-stage items
- 4
Join review_statistics with subjects and assignments tables to include kanji characters
A ranked list of up to 15 items with characters, SRS stage, total fails, and accuracy percentage
Requirements
- WANIKANI_API_TOKEN environment variable
- WaniKani account at wanikani.com
Installation
clawhub install mart1n-xyz/wanikani-syncRun the CLI command, or paste the prompt into Claude Code, Cursor, Codex or whichever coding agent you use.