lcomplete/huntly/huntly-knowledge-base

Huntly Knowledge Base

Access user's personal knowledge base stored in Huntly via SQLite database.

REQUIRED: Get Database Path First

STOP immediately after this skill triggers. Ask the user for the database path before ANY action.

"I need to access your Huntly database. What is the path to your db.sqlite file?"
Examples:
- /Users/username/Library/Application Support/Huntly/db.sqlite
- ~/Library/Application Support/Huntly/db.sqlite
- /home/username/.config/Huntly/db.sqlite"

DO NOT proceed with any queries until you have the database path. DO NOT auto-search for the file.

Core Rule: Library Content First

By default, query Library content (user actively saved), not auto-collected content.

Library Filter:

WHERE library_save_status IN (1, 2) 

Main Table: page

page_json_properties Field

JSON string containing type-specific metadata:

For tweets (`content_type=1`): TweetProperties

• tweetIdStr, userIdStr, userName, userScreeName, userProfileImageUrl
• fullText, createdAt
• quoteCount, replyCount, retweetCount, favoriteCount, viewCount
• medias[] (mediaUrl, type, videoInfo), hashtags[], urls[], userMentions[]
• quotedTweet, retweetedTweet (nested TweetProperties)
• card (title, description, imageUrl, url, domain)

For GitHub repos (`connector_type=2`): GithubRepoProperties

• name, nodeId, defaultBranch, homepage
• stargazersCount, forksCount, watchersCount
• topics[], updatedAt

Related Tables

• `page_highlight`: page_id, highlighted_text, created_at
• `connector`: id, name, type (1=RSS, 2=GitHub), subscribe_url, folder_id
• `collection`: id, name, parent_id
• `folder`: id, name (RSS folder organization)