sticky-notes_skill

Overview

This skill reads, lists, searches, creates and updates Windows Sticky Notes directly from the local SQLite database using the built-in winsqlite3.dll. It uses lightweight PowerShell helpers with P/Invoke so there are zero external dependencies. The skill works on Windows 10/11 and requires the Sticky Notes app to have been initialized (opened and at least one note created).

How this skill works

The skill opens the Sticky Notes database (plum.sqlite) under %LocalAppData% and calls winsqlite3.dll via P/Invoke to execute SQL against the Note table. Read operations use SQLITE_OPEN_READONLY so they are safe while the app is running. Write operations require closing the Sticky Notes app and use SQLITE_OPEN_READWRITE. Timestamps are stored as .NET ticks and GUIDs identify notes.

When to use it

• Quickly list all current notes and previews from the local machine.
• Search note content (case-insensitive LIKE) including non-ASCII text via UTF-8 binding.
• Export or archive notes for backup or migration workflows.
• Programmatically create or update notes when Sticky Notes can be temporarily closed.
• Audit or inspect the Note table schema across Windows versions.

Best practices

• Open Sticky Notes at least once before running read commands so the database exists.
• Use read-only mode (flag 1) when inspecting notes to avoid conflicts with the app.
• Close the Sticky Notes app before running create/update scripts to prevent database locks and corruption.
• Convert .NET ticks to DateTime for human-friendly timestamps when displaying results.
• Sanitize and parameterize search or insert values; use prepared statements and sqlite3_bind to avoid SQL injection.

Example use cases

• List all notes with previews and last-updated timestamps for a quick audit.
• Search for a specific keyword across all sticky notes and return matching note IDs for follow-up.
• Export notes as part of a local backup or migration script by reading the Note table and saving contents.
• Create a new note from automation (e.g., a reminder created by a scheduled script) — close app, run insert, then reopen Sticky Notes.
• Discover the current SQLite schema when troubleshooting Sticky Notes across different Windows builds.