Recovering Apple Notes from NoteStore.sqlite
The NoteStore.sqlite file can usually be found in the ~/Library/Group Containers/group.com.apple.notes/ directory.
The contents of this database file can be parsed and exported with this tool.
As listed in the projects readme, the tool can be run in a docker container. The following command can be used to process a NoteStore.sqlite file in the current working directory:
docker run --rm -v "%cd%":/data:ro -v "%cd%"/output:/app/output ghcr.io/threeplanetssoftware/apple_cloud_notes_parser -f /data/NoteStore.sqlite --one-output-folder
The most useful output for us is the html format, which lists all of the notes and their contents in a single html file.