
huntly-knowledge-base
by lcomplete
Your Personal AI-Powered Information Hub
Use Cases
Efficient Code Generation
Auto-generate boilerplate code to reduce development time.
Code Review Assistance
Analyze PR changes and suggest improvements.
Refactoring Suggestions
Suggest refactoring options to improve code quality.
Test Code Generation
Auto-generate unit tests and E2E tests.
SKILL.md
name: Huntly Knowledge Base description: This skill should be used when the user asks about their saved content, bookmarks, starred articles, highlights, reading history, tweets, or knowledge base in Huntly sqlite database. Triggers include "我的收藏", "知识库", "我保存了什么", "my bookmarks", "my library", "what did I save".
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)
| Type | Condition | Order By |
|---|---|---|
| My List | library_save_status = 1 | saved_at |
| Archive | library_save_status = 2 | archived_at |
| Starred | is_starred = 1 | starred_at |
| Read Later | is_read_later = 1 | read_later_at |
Main Table: page
| Field | Description |
|---|---|
id, title, url | Basic identifiers |
description, content | Text content (content is HTML) |
author, author_screen_name | Author info |
domain, site_name | Source website info |
thumb_url | Thumbnail image URL |
library_save_status | 0/NULL=unsaved, 1=My List, 2=Archive |
is_starred, is_read_later, is_mark_read | Boolean flags |
connector_type | NULL=web, 1=RSS, 2=GitHub |
connector_id | FK → connector |
content_type | 0=history, 1=tweet, 2=markdown, 3=quoted tweet, 4=snippet |
collection_id | FK → collection |
created_at, saved_at, starred_at, archived_at, read_later_at | Timestamps |
highlight_count | Statistics |
page_json_properties | JSON string with extra data (see below) |
page_json_properties Field
JSON string containing type-specific metadata:
For tweets (content_type=1): TweetProperties
tweetIdStr,userIdStr,userName,userScreeName,userProfileImageUrlfullText,createdAtquoteCount,replyCount,retweetCount,favoriteCount,viewCountmedias[](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,homepagestargazersCount,forksCount,watchersCounttopics[],updatedAt
Related Tables
page_highlight:page_id,highlighted_text,created_atconnector:id,name,type(1=RSS, 2=GitHub),subscribe_url,folder_idcollection:id,name,parent_idfolder:id,name(RSS folder organization)
Score
Total Score
Based on repository quality metrics
SKILL.mdファイルが含まれている
ライセンスが設定されている
100文字以上の説明がある
GitHub Stars 1000以上
1ヶ月以内に更新
10回以上フォークされている
オープンIssueが50未満
プログラミング言語が設定されている
1つ以上のタグが設定されている
Reviews
Reviews coming soon

