Magic Note

Magic Note

Intelligent note-taking and query system supporting tags, feelings, mentions, todos, and relationship visualization between notes.

Database Location

• Config file path: /Users/guyanhua/.claude/note (This is a text file storing the sqlite database path)
• First-time setup:

1. Check if /Users/guyanhua/.claude/note exists
2. If it exists, read the sqlite database path from it
3. If it doesn't exist, ask user "Please enter SQLite database save path (e.g., /Users/guyanhua/.claude/notes.sqlite)" and write that path to the config file

Table Structure

| Field | Type | Description | |-------|------|-------------| | content | TEXT | Note content | | tag | TEXT | Category tag (#tag) | | feel | TEXT | Feeling at the time ($feel) | | who | TEXT | Related person/thing (@who) | | todo | BOOLEAN | Is this a todo item (&) | | time | TIMESTAMP | Record time |

Workflow

1. Save Notes

Trigger words: save, record, write, add note

Syntax:

save/record [content] [#tag] [$feel] [@who] [&todo]

Examples:

• save Need to add more stock positions today → Auto-analyze and extract
• record #stock Market crashed today $pain @guyanhua
• save & Buy toilet paper today

Processing steps:

1. Check if /Users/guyanhua/.claude/note exists

• If it's a text file, read the sqlite path from it
• If it doesn't exist or is empty:
• Ask user: "Please enter SQLite database save path" (provide default suggestion like /Users/guyanhua/.claude/notes.sqlite)
• Write user's chosen path to /Users/guyanhua/.claude/note file

1. Call scripts/save_note.py to save the note
2. Automatically parse content to extract tag, feel, who, todo
3. Important: tag only uses existing tags; feel and who can be freely created
4. Return extracted fields (whether explicitly specified or auto-analyzed)

Python script:

python3 scripts/save_note.py "note content"

2. Query Notes

2.1 Review Notes (containing @ or $)

Trigger words: review, need review, notes to review

Example: What notes need review from past 1 day?

Processing: Query notes containing feel or who

Python script:

python3 scripts/query_notes.py --review 1

2.2 Query by Feeling

Trigger words: notes with {feel}, {feel} notes from past X days

Example: Any excited notes from past 1 day

Python script:

python3 scripts/query_notes.py --feel excited --days 1

2.3 Query by Tag

Trigger words: {tag} notes from past X months, {tag} related notes

Example: Stock notes from past month

Python script:

python3 scripts/query_notes.py --tag stock --days 30

3. Relationship Visualization

Trigger words: {tag} from past X months implies need for relationship graph

Processing steps:

1. Get all notes for that tag within the specified time range
2. Use AI to analyze potential relationships between notes (common keywords, semantic similarity, time correlation, etc.)
3. Generate ASCII art graph with notes as nodes, connected if related

ASCII graph example:

         Read
        Apple's
xx       report     xx
    |         |         |
    |         |         |
    Study Apple stock────ios ecosystem────xx
    |         |         |
    |         |        |
    |         xx      |
    |          |        |
   xx──xx──xx

Script Documentation

scripts/note_db.py

Database operation module, providing the following functions:

• init_db() - Initialize database
• add_note(content, tag, feel, who, todo) - Add note
• get_existing_tags() - Get list of existing tags
• get_notes_by_days(days) - Get notes from N days
• get_notes_with_feel_or_mention(days) - Get notes containing feel/who
• get_notes_by_feel(feel, days) - Query by feeling
• get_notes_by_tag(tag, days) - Query by tag

scripts/parse_note.py

Parse note content to extract tag/feel/who/todo:

from parse_note import parse_note
parsed = parse_note("Need to add stock today $excited", existing_tags)
# Returns: {"tag": "stock", "feel": "excited", "who": None, "todo": False, ...}

scripts/save_note.py

Main entry point for saving notes:

python3 scripts/save_note.py "note content"

scripts/query_notes.py

Main entry point for querying notes:

# Review notes (notes with @ or $ from past N days)
python3 scripts/query_notes.py --review 1

# Query by feeling
python3 scripts/query_notes.py --feel excited --days 1

# Query by tag
python3 scripts/query_notes.py --tag stock --days 30

# Query ALL notes from past N days
python3 scripts/query_notes.py --all 30

IMPORTANT: --all N means "query all notes from past N days", NOT "query all notes ever".

• --all 1 → past 1 day only
• --all 30 → past 30 days
• Do NOT use --all 1 --days 30 together (the --all parameter already specifies the days)

Source & license

This open-source skill is cataloged on AgentStack and links to its original source — we do not rehost the code.

• Author: buhe
• Source: buhe/claude-common-skills
• License: MIT

Install and usage instructions live in the source repository linked above.