I remember this guy did an external tool in Java that you could use to edit your collection of cards in Anki.
If I recall correctly, he used sqlite to load up the collection of Anki and edit it.
Does anyone here know how I can do it with sqlite? To read and edit the collection?
I suggest using this open source app https://sqlitebrowser.org/
I would not recommend editing the database directly as any unintended changes could cause the database to suddenly not working with the Anki version (saw similar stuff happening as a developer with ‘advanced’ end users with a pro photo app). Or at least make a lot of backups.