Apple notes

Query and export your notes from Apple Notes with SQL.

Installation

anyquery install notes

Usage

-- Get all your notes (will probably fail with pretty output mode due to the amount of html to print. Switch to json,csv, plain, etc.)
SELECT * FROM notes_items;

-- Get all your notes with a specific title
SELECT * FROM notes_items WHERE name = 'My note title';

-- Get all your notes that talk about a specific topic
SELECT * FROM notes_items WHERE html_body LIKE '%my topic%';

-- Get your 10 most recent notes
SELECT * FROM notes_items ORDER BY creation_date DESC LIMIT 10;

-- Get the folder with the most notes
SELECT folder, COUNT(*) AS notes_count FROM notes_items GROUP BY folder ORDER BY notes_count DESC LIMIT 1;

# Export all your notes to a csv file
anyquery -q "SELECT * FROM notes_items" --csv > my_notes.csv

Schema

Column index	Column name	type
0	id	TEXT
1	name	TEXT
2	creation_date	TEXT
3	modification_date	TEXT
4	html_body	TEXT
5	folder	TEXT
6	account	TEXT

Caveats

The plugin is read-only, you can't yet create or modify notes.
The plugin is not yet tested on all versions of Apple Notes, please report any issues you encounter.
The plugin caches the notes for an hour to avoid querying too often. If you want to clear the cache, run SELECT clear_plugin_cache('notes');.
The plugin is a bit slow. If fetches two notes per second on a Macbook Air M1 for non-cached notes.