Search in my Anki collection, via command line

Question

Anki is a flashcards app, for instance to memorize obscure vim tricks.

Sometimes I want to quickly search a fact I don't remember, without having to open the Anki GUI.

Is there a script I could use for this?

Requirements:

• Command-line
• No configuration needed, should find the SQLite file itself
• Search all fields, output all fields
• Open source

Answer 1

Since anki2 files are sqlite-based, you may try my filegrep script. (It needs file2txt and sqlite3 as helpers).

Examples:

filegrep ubuntu *.sqlite
filegrep ".*linux" *.anki2
filegrep -r "keyword" path/to/databasedir

You can use most of the classic grep switches with it.

The output will be in SQL, which you may filter with other tools.